web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Automate
Answered

Look up

(0) ShareShare
ReportReport
Posted on by 39

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?

I have the same question (0)
  • Agnius Bartninkas Profile Picture
    Most Valuable Professional on at

    What exactly do you need help with?

     

  • ddow2788 Profile Picture
    39 on at

    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.

    Screenshot (18).png
    Screenshot (15).png
    Screenshot (17).png
  • Verified answer
    Agnius Bartninkas Profile Picture
    Most Valuable Professional on at

    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 Profile Picture
    39 on at

    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.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Congratulations to the July Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
David_MA Profile Picture

David_MA 247 Super User 2026 Season 2

#2
11manish Profile Picture

11manish 164 Super User 2026 Season 2

#3
trice602 Profile Picture

trice602 138 Super User 2026 Season 2

Last 30 days Overall leaderboard