cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
PowerUser_One
Frequent Visitor

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

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 

 

PowerUser_One_0-1626883507980.png

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.

PowerUser_One_1-1626883778905.png

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 ? 

 

 

2 ACCEPTED SOLUTIONS

Accepted Solutions
Paulie78
Super User
Super User

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.

View solution in original post

Paulie78
Super User
Super User

item()['baseamount']

View solution in original post

3 REPLIES 3
Paulie78
Super User
Super User

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.

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

PowerUser_One_2-1626889166484.png

 

 

 

PowerUser_One_0-1626888999583.png

 

Paulie78
Super User
Super User

item()['baseamount']

Helpful resources

Announcements
Power Automate News & Announcements

Power Automate News & Announcements

Keep up to date with current events and community announcements in the Power Automate community.

Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Users online (3,688)