Skip to main content

Notifications

Announcements

Welcome to the Power Platform Communities
Announcing Mentions and Quick Responses!
Give Back to the Community this Month
Join us in the Community for an AMA: December 12th Register Today
News and Announcements icon
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 7,541 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
    FLMike Profile Picture
    FLMike 29,361 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
Announcing Mentions and Quick Responses!
Give Back to the Community this Month
Join us in the Community for an AMA: December 12th Register Today

Quick Links

November 2024 Newsletter…

November 2024 Community Newsletter…

Community Update Oct 28…

Power Platform Community Update…

Tuesday Tip #7 Community Profile Tips…

Welcome to a brand new series, Tuesday Tips…

more Community News

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 143,297

#2
RandyHayes Profile Picture

RandyHayes 76,308

#3
Pstork1 Profile Picture

Pstork1 63,890

Leaderboard

Featured topics

Start and wait for an approval action

Product updates

Microsoft Power Platform Community release plans