Skip to main content

Notifications

Power Automate - General Discussion
Unanswered

Convert Dataverse records to JSON file

(0) ShareShare
ReportReport
Posted on by 18

Hello team,

I have a requirement to extract data to JSON when record is created in Dataverse. User can also manually trigger the flow. The target db can only accept JSON file format. I need to be able to generate JSON file from the Dataverse using Power Automate or any other recommended platform. 

I want to extract specific field such as FirstName, LastName, DateofBirth etc,

I will appreciate your help on this how to go about this? 

  • Hammed Profile Picture
    Hammed 18 on at
    Re: Convert Dataverse records to JSON file

    Got this thank you but i don't need the second compose. The format is created properly in SharePoint. I am getting the content in txt file.

     

    But i need the JSON to contains multiple records. For example if they are 10 records the JSON should generate for this 10 records etc. I will appreciate your help on this.

  • Chriddle Profile Picture
    Chriddle 7,371 on at
    Re: Convert Dataverse records to JSON file

    It would look like this:

    Chriddle_0-1710145228881.png

     

    1. Create an object with all the required properties
    2. Use the string() function to create a JSON string that can be sent to the database
    string(outputs('Compose'))

     

  • Hammed Profile Picture
    Hammed 18 on at
    Re: Convert Dataverse records to JSON file

    @Chriddle do you have the steps or screenshot? that will be helpful. i will appreciate that. thank you.

  • Chriddle Profile Picture
    Chriddle 7,371 on at
    Re: Convert Dataverse records to JSON file

    You can use the function string() to convert an array or object into JSON

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,580

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,909

Leaderboard