Hello everyone,
I'm currently facing a challenge in Power Automate, and I'm hoping you can offer some guidance.
I'm looking to refresh a specific dataflow within a Power App environment, but I'd like to do it based on the dataflow's name.
My approach involves obtaining a list of all the dataflows available in my environment, and then filtering this list to retrieve the dataflow's ID that matches the name I'm searching for.
I'm aware that you can retrieve a list of all Power Automate Flows in the environment, but I'm struggling to find a similar method for Power App dataflows.
I'd greatly appreciate any assistance or suggestions you can provide.
Thank you in advance for your help!
Hi @MGuyot , It seems that you can only use graph api with action that I mentioned above. I am afraid that you might have to go with premium connectors.
Thanks,
ANB
Hello @ANB,
Thank you for your assistance.
I've tried the second method you suggested, but unfortunately, it doesn't seem to work with the specific URI:
https://<env-name>.api.<region>.dynamics.com/api/data/v9.2/msdyn_dataflows
The problem lies in the "Send an HTTP request" (For Office 365) action, as it requires a Graph endpoint. Here's the error message I encountered:
URI path is not a valid Graph endpoint, path is neither absolute nor relative or resource/object is not supported for this connector. Resources: me,users Objects: messages,mailFolders,events,calendar,calendars,outlook,inferenceClassification. Uri:
https://************.api.*****.dynamics.com/api/data/v9.2/msdyn_dataflows
I think that utilizing the web API necessitates the "HTTP" action, which is a premium feature. This is making me increasingly uncertain about the possibility to list Dataflows without a premium license.
Thank you again for your help and if you have any further insights you can provide, it would be greatly appreciated.
Hi @MGuyot , You can use the web api for the same : [organization URI]/api/data/v9.2/msdyn_dataflows
To invoke this end point, you can use standard connectors like Send an HTTP request with Get method to collect all your dataflow definition and store to SP list and the use it further.
Personally I have never tried this but you can give a try.
-----------------------------------------------------------------------------------------------------------------------------
I hope this helps.
Please click Accept as solution ✅ if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs up.👍
Thanks,
ANB
Thank you @ANB !
I really appreciate your input, and I believe your solution could be effective.
However, I hadn't initially intended to utilize a Power Automate premium license, so obtaining rows from Dataverse won't be feasible for me.
Do you know of any alternative solutions that don't rely on a Power Automate premium license?
For the time being, I'm considering a workaround of hard-coding my list within a Compose action.
It may not be the most elegant or flexible approach, but it's more budget-friendly.
Once again, thank you for your assistance.
Hi @MGuyot , The Dataflow definitions are actually in the Dataverse Table 'Dataflow' which can be retrieved through Power Automate.
"msdyn_originaldataflowid" is the name of the column/attribute in a Dataverse List Rows action performed on the Dataflows table.
-----------------------------------------------------------------------------------------------------------------------------
I hope this helps.
Please click Accept as solution ✅ if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs up.👍
Thanks,
ANB
stampcoin
79
Michael E. Gernaey
70
Super User 2025 Season 1
David_MA
48
Super User 2025 Season 1