Excel dymanic content not available to update/ create items in sharepoint

[egornua1]

Hello All,

Hope you may be able to assist me.

I have a flow which is runinng well but in the final step i want to create or update an item on sharepoint list.

I cannot get the excel data from the dynamic content.

I have done this on a different flow where i didnt need to use a filter array and can see the excel content to map correctly but not in this case. Please see below.

Thank you for your time

[Pstork1 · Accepted solution]

After using a Filter Array you need to run the output through a Parse JSON to re-establish the column identities in the output using a JSON Schema.  Once you do that you will see the columns from the Filter Array output in the Dynamic content.

[egornua1]

@Pstork1 - thanks for the quick response. I am not sure on the schema part.

Do i copy that from the filter array body?  i am relatively new to PA.

Thank you

[Pstork1]

Yes, you can generate the schema using the output from the filter array.

[egornua1]

@Pstork1  - Thank you, yes i wasn't pasting in the correct place.

i then changed the apply to each to the parse body output and looks to be working.

Thanks again for the parse solution, much appreciated.

Happy holidays to you and your family

[egornua1]

@Pstork1 - one issue in testing is it adds an apply to each for the create item as per below.

Any way to avoid this as it gives an error for existing values

[Pstork1]

It adds the apply to each loop because the output of a filter array is always an array.  It may be an array of only one record, but its still an array.  If you are filtering down to just one record then you can avoid the loop by using the First() function to get the first record of the array.  But that normally means writing the JSON for that in the expressions tab manually.