You’re offline. This is a read only version of the page.
18
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!
@v-xiaochen-msft are you able to possibly assist with this one?
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?
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.
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
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.
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
#1
Michael E. Gernaey
566
Super User 2025 Season 1
#2
David_MA
516
Super User 2025 Season 1
#3
stampcoin
492
Share
Report
All responses (
Answers (
