Unanswered

Convert Dataverse records to JSON file

(0) Share

Report

Posted on by Hammed

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?

Categories:

General topics

I have the same question (0)

All responses (4)

Answers (0)

Chriddle 8,623 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Hammed 26 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Chriddle 8,623 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!
It would look like this:

Create an object with all the required properties

Use the string() function to create a JSON string that can be sent to the database

string(outputs('Compose'))

Was this reply helpful? Yes No
Hammed 26 on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No