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
Process Advisor

Introducing Process Advisor

Check out the new Process Advisor community forum board!

MPA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

Users online (97,648)