Error in adding rows from excel table to list

(2) Share

Report

Posted on by Gilmour1

Hi community.

I have a flow adding rows to a list from an excel table and I keep receiving this error:

"The execution of template action 'For_each' failed: the result of the evaluation of 'foreach' expression '@outputs('List_rows_present_in_a_table')?['body']?['body/value']' is of type 'Null'. The result must be a valid array.

Here's my flow:

The flow action 'Create table' creates a table and assigns the following column headers: 'Project', 'Revision', 'Code' and 'QTY'.

Here's the formula I've used in the Create item action to reference, for instance, the Project: items('For_each')?['Project'].

Thank you for any help you can give!

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (0)

trice602 15,404 Super User 2025 Season 2 on at

Like (1)

Report

Hi,

The root cause here is your table in Excel is empty, there are no rows of data to create the item from (based on your flow example). I recommend you go back and look at the output of your List rows present in a table. Based on the error, it is blank.

------------------------------------------------

⭐ If this was helpful, please like and/or mark as a verified answer to help others find this too!

Always glad to help! 💯💯💯💯💯

Tom

Follow me on LinkedIn - Thomas Rice, PMP | LinkedIn

Was this reply helpful? Yes No
Gilmour1 60 on at

Like (0)

Report

Hi @trice602,

I made sure that my excel has no empty rows, and it doesn't (there is a header row, and is correctly filled out with column names). Still getting the error though! Any ideas?

Was this reply helpful? Yes No