Power Platform Community Forum Thread Details

Appending the results of "Select" data operation to an array

Hello,

I have an excel file with customer order data with rows exceeding 5000, so the list rows in a table operation needs to be run in a loop. Now I got the loop down, and I want to append each run into an array that will contain all data in all rows. This is the flow that deals with the appending:

Now the issue that I am having is that the filter array operation is not working at all and is returning blank arrays. It should be comparing the customer names of in the array that I created with all rows of the excel included to the customer column of another excel containing emails. However I did some tests and it seems that the callout to the email excel is returning the customer name correctly, but the customer name of the array is returning null. I can see in the JSON outputs that the data content is being writtent correctly, but I'm unsure if the step between "Select 2" and "Append to array" is correct. Below is the output of the JSON operation, I don't think there should be two "body".

{"body":[{"body":[{"Our Order Number":"393933","PO Number":"1231231","Line":"004","Quantity":"1","Amount":"$630.63","Promised Date":"2021-05-17","Current Scheduled Ship Date":"2022-01-15","Reason for Delay":"INVENTORY ERROR","Customer":"Happy Giffaee"},

Quick Links

Leaderboard > Power Automate