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 / Using power automate t...
Power Automate
Answered

Using power automate to pull in excel file and get a sharepoint list item and update

(0) ShareShare
ReportReport
Posted on by 347

I am doing a trigger power automate. I then do a step get present rows of table.  That seems fine because the next step I do get items to go to the sharepoint list.  I can see the fields in excel and in the filter query I can see the excel field and I select then type eq and then I type the name of the field in the list.  When I run it it errors and says the field I typed in the list doesn't exist. but it does.  what am i doing wrong?

 

Categories:
I have the same question (0)
  • MarconettiMarco Profile Picture
    3,812 Super User 2024 Season 1 on at

    Hello @dmclaughlin ,

    please share the flow steps in edit mode so that we could help you. Also please share your SP list and Excel file.

     

    BR,

    Marco

  • Verified answer
    v-bofeng-msft Profile Picture
    Microsoft Employee on at

    Hi @dmclaughlin ,

     

    Please add ' beside the keywords you want to search. For example:

     

    SearchField eq 'KeyWord'

     

    Best Regards,

    Bof

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!

Leaderboard > Power Automate

#1
David_MA Profile Picture

David_MA 250 Super User 2026 Season 1

#2
Expiscornovus Profile Picture

Expiscornovus 222 Most Valuable Professional

#3
Haque Profile Picture

Haque 174

Last 30 days Overall leaderboard