Look up

[ddow2788]

Here is my scenerio...

I have a SharePoint list that I have to hide from the public. So I created a form with the intention to look up the list item. For example. I want to look up is John Doe is in my share point list. So in my form I put a first name question and last name question. If John Doe is typed correctly in the form I want to send an email saying John Doe is in the data base. If typed incorrectly the email will say sorry. My flow keeps matching the form ID number with the list ID number. So if John Doe is ID number 5 in my list but the form ID is 3 it always comes back as sorry. Can anyone help?

[Agnius]

What exactly do you need help with?

[ddow2788]

I created a form as shown in screenshot 15. I want to use this form to look up a name in my person list. Right now I have my flow set up as follows. "when a new response is submitted>get response item>get item>my condition>if the equal the list name then email>if no then dont email"

You can look at screenshot 17 and 18 and see my set up. When I trigger the flow it succeeds but the condition keeps triggering no. I looked up the body information and it is matching my form ID number to the ID number on my Person List. So if it is the 20th time I ran the form it will match try and match with ID number 20 on the person list. I need it to find the First Name and Last Name on the person list using the form.

[Agnius · Accepted solution]

First of all, I do not really understand why there is an Apply to each loop in your flow. When the flow is triggered by a Forms response, there should only be a single response to process (the one that triggered the flow). Are you using some other actions between the trigger and the loop?

Then the obviously incorrect thing you're doing is that you are trying to get a SharePoint item using a Forms response Id. These do not match. The Id is a unique thing. The Forms response Id will give you the specific response. It has nothing to do with SharePoint items. What you need to do instead is use the Get items activity to get all items. You can use a filter query there to say something like {SharePointColumnName} eq '{FirstName}' where you would need to replace {SharePointColumnName} with an actual column name where you store the first name and {FirstName} with the dynamic content from the Forms response. You can do multiple filters like that (for last name, too) by separating them with an AND operator.

This will return an array (even if you filter it with the filter query, it will return an array of one item).

You can then use the empty() expression in your condition to check if the resulting array is empty or not. Since all you need to check is whether an exists, this will be enough. You can do a Condition action with empty(Outputs('Get items')) in the first operand and bool(1) as the second operand. This will be true if the array is empty (no items with the same name).

-------------------------------------------------------------------------
If I have answered your question, please mark it as the preferred solution.
If you like my response, please give it a Thumbs Up.

If you are interested in Power Automate, you might want to follow me on LinkedIn at https://www.linkedin.com/in/agnius-bartninkas/

[ddow2788]

I didn't explain myself very well. It is hard to do so in text. I appreciate the feedback. I was able to get where I needed to go on my flow.