Unanswered

Excel "for a selected row" not properly sending to SharePoint list

(0) Share

Report

Posted on by pbrown

I have a basic Excel sheet, and I am trying to send selected rows to a SharePoint list. This works when I do it, but, all columns except for one column will send to SharePoint List. I have made multiple changes to the flow, but everytime every column except the same column will not go to SharePoint List. Screenshots of the flow are below. The name of the column that will not send is "Please share the content you're hoping to have added, edited, or removed.". Any help would be greatly appreciated!

Here is what appears in my SharePoint list:

The column that says "If there are any..." is supposed to be blank, as the Excel is linked to a Form and that question from the MS Form is optional and the user left it blank. If I select other dynamic content to go in the "Please share.." field it works, but when I select the dynamic content for this actual column, it does not.

Also, when I pull up the Excel dynamic content, I get more than one option for content if editing the flow from Excel, and there repeat Dynamic content that says "formatted" at the end. The below is how it looks in Excel:

Here is how the same screen looks in Power Automate.

Thank you for any help that anyone is able to provide!

Categories:

Building flows

I have the same question (0)

All responses (7)

Answers (0)

Caspar_Rubin 831 on at

Like (0)

Report

Hey,

what kind of column is "Please share the content you're hoping to have added, edited, or removed" exactly?

Could it be that it's a normal Text Field with max 255 characters and the dynamic value is longer than 255 characters?

cheers

Was this reply helpful? Yes No
pbrown 18 on at

Like (0)

Report

Thank you for the reply. The column type is "multiple lines of text". See the snippet below for my settings on that column. Also, the dynamic content tag is nowhere near 255 characters and the data in that cell in Excel are not 255 characters either.

Was this reply helpful? Yes No
Caspar_Rubin 831 on at

Like (0)

Report

Hey,

could you share a screenshot of the flow after it ran when you put a "Compose" action below "For a selected row" action and as value you put in the dynamic value "Please share the content you're hoping to have added, edited, or removed"?

After the flow ran and you open the compose action. Is there content inside?

cheers

Was this reply helpful? Yes No
pbrown 18 on at

Like (0)

Report

Thank you for the reply! I added "Compose" and the flow ran successfully, but the information did not transfer over for "Please share the content you're hoping to have added, edited, or removed". See below for the screenshot of the flow with Compose added.

For the dynamic content of "Please share the content you're hoping to have added, edited, or removed" in the Compose action, there are two choices for this content. One says "formatted" at the end so I tried both and neither transfer the information.

Was this reply helpful? Yes No
GizzelleAkin 22 on at

Like (0)

Report

I had a similar issue and found it had to do with the formatting of the data in the excel document…an extra space or return would make it very temperamental.
Might be worth investigating?

Was this reply helpful? Yes No
pbrown 18 on at

Like (0)

Report

Thank you for the reply! I checked the formatting, and it matches the other cells. No extra spaces or anything.

Was this reply helpful? Yes No
pbrown 18 on at

Like (0)

Report

@v-xiaochen-msft are you able to possibly assist with this one?

Was this reply helpful? Yes No