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.
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
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.
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.
Check out the on demand sessions that are available now!
ISV Studio is designed to become the go-to Power Platform destination for ISV’s to monitor & manage published applications.