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 Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

New Ideas Forum MPA.jpg

A new place to submit your Ideas for Power Automate

Announcing a new way to share your feedback with the Power Automate Team.

MPA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

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

MPA Licensing.jpg

Ask your licensing questions at the Power Automate AMA!

Join Priya Kodukula and the licensing team, super users and MVPs to find answers to your questions on Power Automate licensing.

Users online (3,711)