cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Advocate II
Advocate II

Check if an item exists on a SharePoint list

Hi Folks,

 

I'm trying to create a flow that creates a list item in SP when a record in Dynamics meets a specific stage. The problem I am having is when it try to make the flow check if the item already exists it doesn't seem to work???

Wondering where I am going wrong as it keeps recreating the item?

Thanks 🙂

Flow.PNG

2 REPLIES 2
Highlighted
Community Support
Community Support

Re: Check if an item exists on a SharePoint list

Hi Blair,

 

I have seen a documentation about Workflow Definition Language, please check this link for more details:
https://docs.microsoft.com/en-us/rest/api/logic/definition-language

From this documentation, we know that we can use Empty function to return true if object, array or string is empty.
According to this, I created a flow to send an email when a column is empty. I configured the Condition in Advanced mode, please see below for more details:

1.png

 

Please try it on your side to see if it works for you.

 

Best regards,
Mabel Mao

Community Support Team _ Mabel Mao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Highlighted
Advocate II
Advocate II

Re: Check if an item exists on a SharePoint list

@v-yamao-msft

 

Hi Mabel,

 

I would need it to check if a 10 digit number already exists within the list?

I've tried using equals, but it doesn't seem to work?

 

Thanks!

Helpful resources

Announcements
firstImage

Now Live: Power Virtual Agents Community!

We are excited to announce the launch of Power Virtual Agents Community. Check it out now!

firstImage

New & Improved Power Automate Community Cookbook

We've updated and improved the layout and uploading format of the Power Automate Cookbook!

thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

Top Solution Authors
Users online (7,465)