I want to generate Field Service Work Orders using Flow. The Step requires me to specify the Work Order number. as this should be an auto-generated when the record is created in Dynamics. It works fine if I specify a Work Order number manually but I can't do this in real life as this needs to be auto-generated when the record is created in Dynamics.
Hi there. I wonder if it might work to add a step beforehand to get the most recent WO number, and then increment that into a Compose to use in that field in your Create Work Order step?
You might even be able to store the Most recent workorder number in FS somewhere and just poll that to speed things up.
Either way, keep us posted.
If you liked this reply, please give it a thumbs up! If this reply has answered your question or resolved your challenge, please consider marking it as a Solution. This helps other users find it more easily via search.
Ed- Hi. It’s a good suggestion but I am really hoping I can get the WO number generated within D365 rather than by the Flow. Why? Because in the time it takes to retrieve the last WO number and increment it, someone might just log a Work Order manually on the system and then the Flow will fail. I was hoping there is a more robust way, but let’s see.
Ya, I had thought of that also. Wasn't sure what the setup was.
Most likely, the WO number is coming from a workflow inside D365 (I'm not super familiar with FS, but that sounds like the case).
I'm wondering if you can trigger a workflow to create the WO record from within D365 and then pass the WO # back to Power Automate for you to update with your dynamic data.
Check out the on demand sessions that are available now!
ISV Studio is designed to become the go-to Power Platform destination for ISV’s to monitor & manage published applications.
See the latest Power Automate innovations, updates, and demos from the Microsoft Business Applications Launch Event.