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?
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.
It would look like this:
string(outputs('Compose'))
@Chriddle do you have the steps or screenshot? that will be helpful. i will appreciate that. thank you.
You can use the function string() to convert an array or object into JSON