web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Automate For Each takes time to...

Power Automate

Answered

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

(0) Share

Report

Report

Posted on by PowerUser_One

6

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 ?

Categories:

I have the same question (0)

All responses Img

All responses (3)

Answers Img

Answers (2)

Verified answer

Paulie78 8,422 Moderator on at

Like (0)

Report

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.

Was this reply helpful? Yes No
PowerUser_One 6 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Verified answer

Paulie78 8,422 Moderator on at

Like (0)

Report
item()['baseamount']

Was this reply helpful? Yes No

Join the conversation