Skip to main content

Notifications

Announcements

Welcome to the Power Platform Communities
News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate - Building Flows / Update Existing Item o...
Power Automate - Building Flows
Unanswered

Update Existing Item or Create Item in SharePoint List

(1) ShareShare
ReportReport
Posted on by JajatiDev 39
Hi,
The first two steps of the flow is to copy the attachment to a sharepoint folder evertime a new mail arrives.
 
after the file is saved to SharePoint, I have the "Get items" that looks up the sharepoint list "OO_Flow_Completion_Tracker" for the name in Filter query.
and when passed through a condition it will override the existing name in the list of create a new one if the name doesnt exist.
 
however, I get the below error while testing the query.
Please advise what am I doing wrong and how to fix it.
 
 
 
 
 
 
 
 
Categories:
Business Process Flows
  • David_MA Profile Picture
    David_MA 9,351 Super User 2025 Season 1 on at
    Update Existing Item or Create Item in SharePoint List
    In addition to what FLMike suggested, update your filter query to a valid expression. For example, Blackout_Open_Orders eq 'text to filter'. It seems odd, but maybe that is what the error message is trying to tell you, which is that the expression is not valid.
  • Suggested answer
    Michael E. Gernaey Profile Picture
    Michael E. Gernaey 33,251 Super User 2025 Season 1 on at
    Update Existing Item or Create Item in SharePoint List
    Hi
     
    Do this for me. Go to SharePoint. To that List.
     
    Click the Gear (top right) and go to List Settings
     
    Once that opens up, I want you to look for the field. Now let's say you dont see it, Problem solved. If you do see it, do one more step.
     
    Click on the field name in the list
    Once the details of that field open up, look at the URL in the browser. Verify how its spelled exactly (the url with END with the field name)
     
    If its not working its because its not the correct name (spelling etc). For instance does it really have _ in the name or are those spaces? which need
    the character code for.
     
    Or if you imported this list from Excel, it WONT say the original name, it will say Field23 or Field123123 
     
    Etc
     
    Go verify the Name and come back and let me know if that solves your issue. Or share a photo and verify that the Flow you are building is pointing to the correct list. (environment etc, as I dont know if you are using Enviornment variables or hard coding SharePoint url etc.
     
     

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

News and Announcements

Welcome to the Power Platform Communities

Quick Links

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 146,318 Most Valuable Professional

#2
RandyHayes Profile Picture

RandyHayes 76,287 Super User 2024 Season 1

#3
Pstork1 Profile Picture

Pstork1 65,111 Most Valuable Professional

Leaderboard

Featured topics

Start and wait for an approval action

Product updates

Microsoft Power Platform Community release plans