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

Check if item exists in sharepoint list

Im trying to use a flow that will check if a student exists in a sharepoint list, using their email to search in the sharepoint list.

For example, i want to get the items of the list, and check if "TestEmail@Email.com" exists in the list, which if it does not, i can automatically add it.

 

The issue i am having is all of the previous answers i can find involve editing a condition in advanced mode, which i do not have access to.

 condition.PNG

 

And with all my tests, i cannot get the condition to do what i want and give me a correct evaluation of if the email 'TestEmail@Email.com' exists in the student list

 

my current flow layout is as follows 

flow.PNG

2 REPLIES 2
Highlighted
Dual Super User III
Dual Super User III

I would try adding a query filter to the settings of the Get Items action.  Then check to see if any records are returned.  If not then the student isn't in the list.



-------------------------------------------------------------------------
If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.
Highlighted
Community Support
Community Support

 

Hi @SDonaghy ,

 

What is stored in the Student Email Item?

How did you save the student's information in the List? Is the person field or the string field directly used to store the email?

Please tell us about these details so that we could provide a proper workaround for you.

 

Best Regards,

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

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Power Platform ISV Studio

Power Platform ISV Studio

ISV Studio is designed to become the go-to Power Platform destination for ISV’s to monitor & manage published applications.

Users online (16,292)