cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Snazzybec
Frequent Visitor

sing flow to check if a form submission exists in list, if not create, if so update

Hi

 

I am a failrly new user of flow and have been enjoying the experience.

 

I am now wishing to get a bit more advanced with my flow. 

 

I have a form where flow inputs the submission into a sharepoint list.  I wish to use the condition to check of the get items output is 0, if so create new, if not update

 

I have tried using the below condition

 

length(body('Get_items')?['value']) - is equal to - 0 but this fails as the expression builder doesn't recognise it. 

 

Any assistance would be greatly appreciated

my current flow is attachedcurrent flowcurrent flow

Sam

 

 

 

2 ACCEPTED SOLUTIONS

Accepted Solutions
ChristianAbata
Super User
Super User

@Snazzybec  please create a compose action an inside add this string(length(body('Get_items')?['value'])) then use the output of compose to compare if is equals to 0.



Did I answer your question? Please consider to Mark
my post as a solution! to guide others :winking_face:

Proud to be a Flownaut!


If you want you can follow me at www.christianabata.com Quieres contenido en español? Síguenos en Power Automate LA

View solution in original post

thank you so much Christian, worked a treat

 

learnig fast

 

very much appreciate sharing the knowledge, hopefully I can pass it on

 

Sam

View solution in original post

2 REPLIES 2
ChristianAbata
Super User
Super User

@Snazzybec  please create a compose action an inside add this string(length(body('Get_items')?['value'])) then use the output of compose to compare if is equals to 0.



Did I answer your question? Please consider to Mark
my post as a solution! to guide others :winking_face:

Proud to be a Flownaut!


If you want you can follow me at www.christianabata.com Quieres contenido en español? Síguenos en Power Automate LA

thank you so much Christian, worked a treat

 

learnig fast

 

very much appreciate sharing the knowledge, hopefully I can pass it on

 

Sam

Helpful resources

Announcements
Power Automate News & Announcements

Power Automate News & Announcements

Keep up to date with current events and community announcements in the Power Automate community.

Community Calls Conversations

Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Users online (6,595)