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)

Sort by

trice602 16,239 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

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 62 on at

Like (0)

Report
Copy link

Link copied!

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