Power Platform Community Forum Thread Details

Hi ,

My use case - using Dataverse am reading values in power automate desktop of that particular table ,there are mutiple rows in it but for reference I have attached single row data.

I want to loop through name , value data ........but I guess we cant loop through custom object variable .....can we convert it into datatable or any other method because I want to loop through name and value column .......Note - I cant use excel.

Categories:

Power Automate Desktop

Hi @NA-03061633-0,

In Power Automate Desktop (PAD), when you retrieve multiple rows from a Dataverse table, the output is typically a custom object or JSON array, which cannot be directly looped over like a DataTable.

To loop through multiple rows (name, value) from Dataverse in PAD - let's follow these steps:

Parse the JSON response: The Dataverse connector usually returns data as JSON. Use the "Parse JSON" action or Set Variable with expressions to convert the JSON string into a list/array variable.
Convert JSON array to a PAD List or DataTable: You can loop through the JSON array by using a For Each loop on the array elements. Each element will be a JSON object representing a row with fields like name and value.
Extract fields inside the loop: Inside the loop, access each row’s properties (e.g., CurrentItem["name"], CurrentItem["value"]). You can then process or store these values as needed.
Optional: Build a DataTable: If you want to work with a DataTable, initialize an empty DataTable with columns name and value. In the loop, add each row’s data to the DataTable using the Add DataRow action. This lets you manipulate or export the data easily later.

I am sure some clues I tried to give. If these clues help to resolve the issue brought you by here, please don't forget to check the box Does this answer your question? At the same time, I am pretty sure you have liked the response!