Trying to add a new row to an existing spreadsheet when a new email comes in

(0) Share

Report

Posted on by PG3 Microsoft Employee

Hi there,

A simple one I suppose, but I can't get it to work. I'm not very experienced in Power Automate and it may show.

I'm using:

"When a new email arrives" > Condition (subject does not contain RE:) > if YES

"Get Tables" (I pick an existing spreadsheet in Sharepoint)

"Apply to each" is shown below

It fails with:

Action 'Apply_to_each' failed

Error Details

The execution of template action 'Apply_to_each' failed: the result of the evaluation of 'foreach' expression '@{outputs('Get_tables')?['body/value']}@{triggerOutputs()?['body/receivedDateTime']}@{triggerOutputs()?['body/from']}@{triggerOutputs()?['body/subject']}' is of type 'String'. The result must be a valid array.

All responses (1)

Answers (0)

Pstork1 65,906 Most Valuable Professional on at

Like (0)

Report

Re: Trying to add a new row to an existing spreadsheet when a new email comes in

If you are using the Apply to Each loop to go through each of the tables retrieved in the Get Tables action then you only need to use the Value property in the Loop. The other values will be used in the Add row as you have them.