cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
ALute
New Member

Query failure while checking to create or update list item

Hi,

I'm using a HTTP Request to add items to a SharePoint list. This is working fine.

Now I changed my flow to check if a list item already exists (then update) or not (then create)

 

This is a part of the flow:

ALute_0-1602707088244.png

I use the filter query to check if the record already exist.

 

ALute_1-1602707199009.png

Both fields Kandidaat ID and UniqueID are strings.

 

After running the flow this error appears:

ALute_2-1602707283786.png

I tried everything, incl brackets or sequence. It does not work. What am I doing wrong. Here also a snip of the create item step (which works fine without the condition and query)

 

ALute_4-1602707607543.png

 

 

Question 2: is the syntax i'm using to check if the result of the get items step the right one?

 

ALute_3-1602707426650.png

Thank you very much for your help.

Regards, Alex

2 REPLIES 2
PrasadAthalye
Super User
Super User

@ALute - Can you put value of kandidate id in single quotes too? 'Kandidat ID' eq '123466' and then try?

 

Like and Mark this as a solution if it resolves your issue...

Please Like and Mark this as Answer if it resolves your Issue.

Power Automate Community

Hi, I changed the query (incl single quotes) to:

ALute_1-1602733404861.png

 

with this result, but still the same error message

ALute_0-1602733366958.png

 

Helpful resources

Announcements
MPA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

V3_PVA CAmpaign Carousel.png

Community Challenge - Giveaways!

Participate in the Power Virtual Agents Community Challenge

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

PowerPlatform 768x460.png

Microsoft Learn

Check out our new Discover Your Career Path blog post series and get all the details.

Top Solution Authors
Users online (1,142)