web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Add & Update Excel Dat...
Power Automate
Answered

Add & Update Excel Data to SharePoint List

(0) ShareShare
ReportReport
Posted on by 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. 

 

 

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:
I have the same question (0)
  • Verified answer
    wskinnermctc Profile Picture
    6,519 Moderator on at

    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 SettingsSharePoint Column SettingsPower Automate Filter ColumnPower 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,

  • pat104 Profile Picture
    95 on at

    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. 

    Screenshot 2023-01-31 at 08.49.18.png

    Screenshot 2023-01-31 at 08.50.48.png

    Screenshot 2023-01-31 at 09.05.36.png

     

  • Verified answer
    wskinnermctc Profile Picture
    6,519 Moderator on at

    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.

     

     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Congratulations to the April Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Vish WR Profile Picture

Vish WR 784

#2
Valantis Profile Picture

Valantis 581

#3
Haque Profile Picture

Haque 545

Last 30 days Overall leaderboard