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

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / powerautomate list row...
Power Automate
Unanswered

powerautomate list rows present in a table

(0) ShareShare
ReportReport
Posted on by 347

I have a powerautomate that I ran maybe a month ago to pull in excel using 'list rows present in a table' and update or add to a sharepoint list.  Worked fine several times.  Yesterday I could get 1 spreadsheet to load and not a 2nd one.  I've compared.. both have a table1 in them.  I see no differences.  I get an error 400 Target session is invalid.  I've looked at this over and over and tried rebuilding the excel over and over.  I need a second set of eyes.  I'm attaching a working excel , a non working excel, the command in powerautomate and the error.  Any help would be appreciated.  Back in July I had several of these powerautomates to fix lists and never never had this issue.  All I did in past was select the area and set the table and move to a document folder on sharepoint.. and power automate would work.  I don't know if something has changed?

I have the same question (0)
  • Kaif_Siddique Profile Picture
    2,108 Super User 2024 Season 1 on at

    Hi @dmclaughlin ,

     

    Could you check your excel data. This occurs when trying to insert the wrong excel data to SharePoint column (for example trying to insert text to number column etc.). May be you can try to add a row to SharePoint to see the issue.

     

    Let me know if this works.

     

    Regards

    Kaif

  • dmclaughlin Profile Picture
    347 on at

    But the error occurs in seconds on the 'list rows present in table' command?  I would think if issue writing data to the sharepoint list it would occur on that command.

  • VJR Profile Picture
    7,635 on at

    Hi @dmclaughlin, is your issue related to Cloud Flows, in which case I will move it to the Cloud flows forum (this is Desktop flows)? Let me know.

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

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 522 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 364 Moderator

#3
abm abm Profile Picture

abm abm 243 Most Valuable Professional

Last 30 days Overall leaderboard