For Each takes time to get the Json Data from the Get Records action

[PowerUser_One]

Hi,

For Each takes more times when constructing - json format data from the results of "List Rows" action. 

Requirement - On change of a record in D365 ,

Step 1- Get the records and its child values 

Step 2 - Save the results as file - abc.json 

IF i am updating the file as it is from the results of "List rows" it has so many unnecessary fields as below 

like transactioncurrencyid@odata.associationLink , navigationLink etc . how to filter these attributes.

If am using compose to create a json structure then that use for each which takes more than expected time. 

I have more than 2000 records to upload . 

----Which will be the best solution ? 

[Paulie78 · Accepted solution]

After your list rows action go straight into a select action. Use the against the Value array from your list rows action, pick the columns you want and name them as you would like.

Then use the output of the select to save to your .json file. The select should finish more or less straight away. You won't need any apply to each or compose actions.

[PowerUser_One]

How to access a item present in array - below gives me null

[Paulie78 · Accepted solution]

item()['baseamount']