You’re offline. This is a read only version of the page.
95
Good day,
May I please get advise with my flow. I have created a flow that is supposed to run automatically everyday and import data from an excel spreadsheet on OneDrive to a Sharepoint list. It give the below error. I need to import and update data in to the list everyday with the new data on spreadsheet.
Sure thing, can you screen shot and show all of your flow steps so I can see the full flow. It can be multiple pictures, but I want to see all of the steps you have. What you are showing now is a little confusing to me, and I want to make sure I am seeing it correctly.
Thank you for the advise it does help, I have applied your solutions as shown as on the screenshots below. The flow is running successfully but there is one issue where it doesn't seem to be sending the data to the respective list. Is there anything you could advice further on this? I need the flow to also look at the duplicates according to serial number and not add if its already on the list.
You need to use the "Internal Name" of the column. When you create a column in SharePoint, the display name you type may have spaces or special characters, but the Internal Name of the column is what SharePoint actually uses where special characters may be removed or changed with encoding.
Go to your list/library settings and look at the column to edit. If you look in the address bar you can see what the internal name of the column is. Use that internal name within Power Automate.
I made an example below where I made a SharePoint column names "Customer Name"; however, the internal name that was created was "CustomerName" that did not include the space.
If I used "Customer Name" in the filter, it will error since that isn't recognized as a column. When I use the internal name "CustomerName" in the filter, then the flow works correctly.
SharePoint Column Settings
Power Automate Filter Column
(Also in your condition expression the length() looks like it is misspelled as 'lenghth()' so you probably need to correct that as well.)
Let me know if this helps and solved your issue,
#1
WarrenBelz
146,645
Most Valuable Professional
#2
RandyHayes
76,287
Super User 2024 Season 1
#3
Pstork1
65,997
Most Valuable Professional
Share
Report
All responses (
Answers (
