cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
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
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
PP Bootcamp Carousel

Global Power Platform Bootcamp

Dive into the Power Platform stack with hands-on sessions and labs, virtually delivered to you by experts and community leaders.

secondImage

Power Platform Community Conference On Demand

Watch Nick Doelman's session from the 2020 Power Platform Community Conference on demand!

MPA Community Blog

Power Automate Community Blog

Check out the community blog page where you can find valuable learning material from community and product team members!

Top Solution Authors
Users online (6,598)