Answered

List all PowerApp dataflows

(0) Share

Report

Posted on by MGuyot

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!

Categories:

Building flows

I have the same question (0)

All responses (5)

Answers (1)

Verified answer

ANB 7,223 Super User 2025 Season 2 on at

Like (0)

Report

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

1 people found this reply helpful.

Was this reply helpful? Yes No
MGuyot 32 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
ANB 7,223 Super User 2025 Season 2 on at

Like (0)

Report

Hi @MGuyot , You can use the web api for the same : [organization URI]/api/data/v9.2/msdyn_dataflows
Check this: https://learn.microsoft.com/en-us/power-apps/developer/data-platform/webapi/reference/msdyn_dataflow?view=dataverse-latest

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

Was this reply helpful? Yes No
MGuyot 32 on at

Like (0)

Report
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.

Was this reply helpful? Yes No
ANB 7,223 Super User 2025 Season 2 on at

Like (0)

Report

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

1 people found this reply helpful.

Was this reply helpful? Yes No