Unanswered

Add & Update Excel Data to SharePoint List

(0) Share

Report

Posted on by pat104

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.

Screenshot 2023-01-30 at 10.20.02.png

Screenshot 2023-01-30 at 10.38.49.png

Screenshot 2023-01-30 at 10.21.41.png

Categories:

Using flows

I have the same question (0)

All responses (3)

Answers (2)

Verified answer

wskinnermctc 6,519 Moderator on at

Like (0)

Report

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 SettingsPower 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,

Was this reply helpful? Yes No
pat104 95 on at

Like (0)

Report

Hi @wskinnermctc

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.

Was this reply helpful? Yes No
Verified answer

wskinnermctc 6,519 Moderator on at

Like (0)

Report

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.

Was this reply helpful? Yes No