Skip to main content

Notifications

Power Automate - Using Connectors
Answered

Dataverse connector - List rows iterating through "Model Driven App" hidden table spits unformatted JSON

(0) ShareShare
ReportReport
Posted on by

I have a simple use case to extract the list of model driven apps name in a current environment.

There is a backend table which is not usually visible when using make.powerautomate.com interface named as "Model-driven Apps"

This table is only visible when the Dataverse connector - List rows are used.

 

GirishUppal_0-1706827125293.png

GirishUppal_1-1706827241703.png

 

GirishUppal_2-1706827277857.png

 

 

When I run this flow, it runs successfully. However, the output JSON is not well formatted when spitted out by this action and thereby I cannot parse the output JSON. Any idea why is this happening?

 

Note: I am running this flow on a Developer Environment

 

 

  • Verified answer
    Girish Uppal Profile Picture
    Girish Uppal on at
    Re: Dataverse connector - List rows iterating through "Model Driven App" hidden table spits unformatted JSON

    Apparently it was an issue with 'JSON viewer' extension from Microsoft Edge extensions.

  • Girish Uppal Profile Picture
    Girish Uppal on at
    Re: Dataverse connector - List rows iterating through "Model Driven App" hidden table spits unformatted JSON

    Thanks Wearsky for the comments. The compose actions doesn't render the correct JSON as the incoming input for that action is not well formed. Please find the supporting screenshot. 

     

    GirishUppal_0-1707007293036.png

    GirishUppal_1-1707007308993.png

     

  • Re: Dataverse connector - List rows iterating through "Model Driven App" hidden table spits unformatted JSON

    Hi @GirishUppal ,

     

    Does it return the correct json format after putting the output into compose?

    vxiaochenmsft_0-1706837141895.png

     

    Best Regards,

    Wearsky

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

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,508

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,839

Leaderboard

Featured topics