Skip to main content

Notifications

Community site session details

Community site session details

Session Id : dmGbabmbzSeARpbVpMe8ql
Power Automate - Building Flows
Answered

List all PowerApp dataflows

Like (0) ShareShare
ReportReport
Posted on 13 Oct 2023 13:49:41 by 32

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!

  • ANB Profile Picture
    7,081 Super User 2025 Season 1 on 16 Oct 2023 at 09:17:49
    Re: List all PowerApp dataflows

    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

  • MGuyot Profile Picture
    32 on 16 Oct 2023 at 08:21:05
    Re: List all PowerApp dataflows

    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.

  • ANB Profile Picture
    7,081 Super User 2025 Season 1 on 13 Oct 2023 at 16:37:02
    Re: List all PowerApp dataflows

    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.

    ANB_0-1697214939463.png

    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


  • MGuyot Profile Picture
    32 on 13 Oct 2023 at 16:10:57
    Re: List all PowerApp dataflows

    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.

  • Verified answer
    ANB Profile Picture
    7,081 Super User 2025 Season 1 on 13 Oct 2023 at 15:25:43
    Re: List all PowerApp dataflows

    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


Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Understanding Microsoft Agents - Introductory Session

Confused about how agents work across the Microsoft ecosystem? Register today!

Warren Belz – Community Spotlight

We are honored to recognize Warren Belz as our May 2025 Community…

Congratulations to the April Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard > Power Automate - Building Flows

#1
stampcoin Profile Picture

stampcoin 79

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 70 Super User 2025 Season 1

#3
David_MA Profile Picture

David_MA 48 Super User 2025 Season 1

Overall leaderboard