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
 WHAT’S NEXT AT MICROSOFT IGNITE 2022

WHAT’S NEXT AT MICROSOFT IGNITE 2022

Explore the latest innovations, learn from product experts and partners, level up your skillset, and create connections from around the world.

Register for a Free Workshop.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

Users online (1,551)