Unanswered

Add a row into a table in Excel

(0) Share

Report

Posted on by joel914823

557

I'm trying to pull items from a SharePoint list to a Excel file. I have a column that is a Choice column - so when I'm dropping the field into the Add a row into excel step - I use the "Value" of the item. However, when it goes to create the row in the excel table, then it creates a duplicate row for each record. Is there a way to just have the value of it come in and leave the record in one row?

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (0)

Srini007 3,327 Super User 2025 Season 2 on at

Like (1)

Report

Hi,

As the action is in For each, you need to use CurrentItem instead of the value coming from the sharepoint.

Eg: Items(For_each)?['ColumnName']?['Value]

Check as above and also its. better to show what value you are passing?

If I have answered your question, please mark it as the suggested answer. If you like my response, please give it a Like.

Regards,
Srini

Was this reply helpful? Yes No
mmbr1606 14,605 Super User 2025 Season 2 on at

Like (2)

Report

hey

i just did kind of the same but with two sharepoint lists, i had a multi select choice in one list and a multiselct choice in the other list and i wanted to copy over the values.

can u try using this video guide and see if that works for excel too:

Copy items between SharePoint lists that contain multi-value choice columns using Power Automate - YouTube

let me know if it helped, if it did please mark as verified answer ;)

Was this reply helpful? Yes No