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

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Trying to us “Get Item...
Power Automate
Answered

Trying to us “Get Items” to check if an ID exists in a SharePoint List

(0) ShareShare
ReportReport
Posted on by 116

My Flow adds MS Form data submitted by a student to a SP List.  I use a second flow to add MS Form data submitted by the Instructor to the same List.  I’ve created a “check” using the List ID to make sure the instructor data is added to the correct student (using the List ID and a student PIN).  That check works well.  However, if the instructor enters an ID that doesn’t exit, the flow fails.

 

I’ve tried to use Get Items and a Condition action to compare the submitted ID to the IDs in the List, but I can’t get the check to work (planned for the check to send an email asking them to resubmit the form with the correct ID and having the flow terminate).

 

Here is what I tried.  The main problem seems to be that when I compare the “outputs” the formats for the IDs are not the same.

Outputs.png

 

 

 

 

 

 

 

Here is the section of the flow that is running the "Check."

ID Check Issue.png

Categories:
I have the same question (0)
  • Verified answer
    Pstork1 Profile Picture
    68,717 Most Valuable Professional on at

    Instead of using the Data Select, just check the length() of the output from the Get Items. If Length() is 0 then it didn't find the ID.  If its 1 or higher it did.

  • Alex_CCI Profile Picture
    116 on at

    Do I use the Compose action for that?

  • Alex_CCI Profile Picture
    116 on at

    Thanks. Your solution worked.  I've added the following to do the check.

    Solution- Length.PNG

  • Pstork1 Profile Picture
    68,717 Most Valuable Professional on at

    You can just put the formula from your Compose in the left side of the condition.  You don't actually need the compose.  But it will make troubleshooting easier

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

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 525 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 324 Moderator

#3
abm abm Profile Picture

abm abm 232 Most Valuable Professional

Last 30 days Overall leaderboard