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
Microsoft Ignite

Microsoft Ignite

Join digitally, March 2–4, 2021 to explore new tech that's ready to implement. Experience the keynote in mixed reality through AltspaceVR!

New Super Users

Meet the Power Automate Super Users!

Many congratulations to the Season 1 2021 Flownaut Crew!

New Badges

New Solution Badges!

Check out our new profile badges recognizing authored solutions!

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!

Users online (52,855)