Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Power Automate - General Discussion
Unanswered

Excel to SharePoint List not passing data?

(0) ShareShare
ReportReport
Posted on by 224

Hello,

 

I have a Table in Excel stored in OneDrive and I'm trying to update a SharePoint list with info from the rows.

 

I'm lost as I'm trying to update a single line of text with a string and the flow appears to work, but the SharePoint list for the PIC and SIC columns aren't populating correctly?

 

I tried using multi line, but no luck.... All my other rows of information are updating correctly?

 

What am I missing?

 

 

as733y_0-1712951752979.png

 

as733y_1-1712951777024.png

 

 

 

Categories:
  • creativeopinion Profile Picture
    10,450 Super User 2025 Season 1 on at
    Re: Excel to SharePoint List not passing data?

    @as733y Could have been because you switched to the Classic Designer? I would recommend sticking with the Classic Designer for now. The new designer is still buggy. Glad you've got it working!

     

  • as733y Profile Picture
    224 on at
    Re: Excel to SharePoint List not passing data?

    @creativeopinion 

     

    I'm not sure what I did, but it's working now!

  • as733y Profile Picture
    224 on at
    Re: Excel to SharePoint List not passing data?

    @creativeopinion 

     

    It pulls from a table, but no, just text in a "General" column.

     

    as733y_1-1713199324755.png

     

  • creativeopinion Profile Picture
    10,450 Super User 2025 Season 1 on at
    Re: Excel to SharePoint List not passing data?

    @as733y How do those values look in Excel? Is it a calculated cell? 

  • as733y Profile Picture
    224 on at
    Re: Excel to SharePoint List not passing data?

    @creativeopinion 

     

    I'm expecting the names circled in the screenshot displayed in SP as string values. 

     

    As you mentioned, it appears like the flow is working correctly (at least capturing the correct info), however the values are blank in SP.

     

    Screenshot of what shows in SP and my Columns.

     

    as733y_1-1713197629911.png

     

    as733y_2-1713197647027.png

     

  • creativeopinion Profile Picture
    10,450 Super User 2025 Season 1 on at
    Re: Excel to SharePoint List not passing data?

    @as733y Can you clarify what you are expecting SP to display? From this screenshot it looks like there are values—what does it look like in SharePoint?

    creativeopinion_0-1713196735976.png

     

  • as733y Profile Picture
    224 on at
    Re: Excel to SharePoint List not passing data?

    Hi @LLinx ,

     

    Yes, just those two columns (PIC & SIC) are not working, which is why I'm confused.

     

    I have other Single Line of text columns that work just fine.

  • LLinx Profile Picture
    99 on at
    Re: Excel to SharePoint List not passing data?

    Hi @as733y 

     

    It would be good to know if the issue is only with those 2 columns. Are those 2 columns the only columns that do not get updated based on the excel? What happens if you change an other column in the excel and run the flow again? Does that change the item in the list?

  • as733y Profile Picture
    224 on at
    Re: Excel to SharePoint List not passing data?

    hi @v-qiaqi-msft 

     

    Just a string to Single line of text column in SP.

     

    Below screenshot shows flow ran successfully, however the SP column doesn't display the info?

     

    as733y_1-1713187292715.png

     

  • as733y Profile Picture
    224 on at
    Re: Excel to SharePoint List not passing data?

    @creativeopinion 

     

    Requested screenshot below. Let me take a look at your YT video and see if that helps. Thank you for your time!

     

    as733y_0-1713187009474.png

     

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

Paul Stork – Community Spotlight

We are honored to recognize Paul Stork as our July 2025 Community…

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 497 Super User 2025 Season 1

#2
David_MA Profile Picture

David_MA 436 Super User 2025 Season 1

#3
Riyaz_riz11 Profile Picture

Riyaz_riz11 244 Super User 2025 Season 1