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,436 Super User 2025 Season 2 on at

Like (0)

Report

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

@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,436 Super User 2025 Season 2 on at

Like (0)

Report
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

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