I’m still pretty new to swagger, but I’ve made my own custom connector for a PowerApps mobile ticketing app. I would love to compare notes sometime! I’m still trying to figure out how to reference the total time logged on a ticket per agent. But there’s always more ways to integrate, which is part of what makes APIs fun!
I really haven’t gotten to mess with Power Automate/BI much yet, can you actually pull data directly into power bi or are you actually doing a real time sync of data into some sort of SharePoint storage that PowerBi is connected to?
Been a busy last week or so here. Today’s not any better thanks to a big windstorm in our area last night taking out power and Internet. Sigh. I’ll dive back into this later this week “if the Good Lord is willing the creek don’t rise.”
This isn’t totally related to the Power Platform Connector for Syncro but it is related to Power Automate.
I expanded on our Power Automate/Syncro integration and put together something really neat for automating the deployment of Intune and the importing of hardware hashes for Autopilot.
Managed to piece together a script to do unattended Intune enrollment that can be pushed out via Syncro. Updates two reg keys that affect enrollment and creates a scheduled task to reach out to Intune for provisioning. This works on devices that are Azure AD Joined.
Managed to get Syncro to capture the Autopilot Hardware Hash with a single line of powershell script and send it to Power Automate where the hash is captured, a JSON payload is generated, and a POST call is made to the Microsoft Graph API to import the hardware hash as an Autopilot Device.
It’s certainly not the first Intune/Autopilot deployment this community has seen, but I thought it was a unique method for automating the deployment. I still need to document the Azure App permissions and the Graph API Endpoints I used but after that I’ll create a post to cover the deployment in case it can be useful to someone else.
Excited to see what else Syncro and Power Automate can do together.
I’ve been waiting for a ‘slow day’ to work on scheduling something with the few here to discuss. I think I’ll just poke a hole in next week somewhere and make the space. Any votes for day/time/timeframe?
I am so glad I came across this post. We have been looking into this and just don’t have the internal bandwidth to get the project going. Would you be interested in collaborating on this effort and perhaps outsourcing to an offshore outfit specializing in Power BI?
We hired a developer a couple months ago to build out our Power BI reporting. We store historical data in O365 for it to run queries against, and then we have it query the Syncro API for all of the real time data and metrics. We also built out customer dashboards in Power BI that we send out to our client key ops. It lets our clients see historical data as well as the real time data from Syncro for their open tickets, and we just recently added CSATs as well. They really seem to enjoy it thus far. Had a lot of great feedback from them.
We started by storing ticket data in a protected Excel sheet and had Power BI query the Excel sheet. However, the Excel sheet quickly got far too big and began crashing. I think it made it to about 2GB in size before it started crashing.
We just recently migrated all of that data into the Microsoft Dataverse (effectively it’s a Microsoft cloud hosted database that’s part of the Power Platform).
We store the last 12 months of data for historical queries, and then real time data is queried from the API.
We even leveraged some of the Syncro tech data to build out a Calendly/Slack integration that alerts the individual techs via Slack whenever someone schedules a meeting with them. On the next iteration of this we’re going to allow techs to set a status on a ticket (Needs Scheduling) and then Syncro will automatically send out a one time use Calendly scheduling link unique to that technician.
Happy to hop on a call to discuss or provide pointers to anyone looking to take a similar approach or discuss automation ideas even if they extend beyond Syncro.
Super keen to collaborate with some of you on whats possible with this type of integration. I just made another post with some instructions on how we setup our Power Platform to Syncro connector so hopefully that will help a few of you who have been asking in this thread for help.
Super intersted to discuss in more detail different ideas, and hear what type of automations everyone is doing?
We have only just started with our automations but we plan to automatically feed live stock data from our suppliers into Syncro. Basically we either web scrape using Power Automate Desktop or import CSV data into Power Automate and store the data in Dataverse tables. Then from this information we will match SKU’s up with Syncro SKU’s and help with providing live pricing and stock availability data with future plans to also automate purchase orders (for suppliers who only allow for checkout via shopping cart/website).
Anyway hopefully the info i provided is helpful. Look forward to hearing what others have come up with.