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 Platform Community / Forums / Power Automate / How to Filter Response...
Power Automate
Unanswered

How to Filter Response from Forms

(0) ShareShare
ReportReport
Posted on by 8

Hello Friends, I have a list of names and emails, and I have a FORM, when this FORM is summited a flow starts to create a task in PLANNER (this flow is already running) the only trouble is because when the flow try to assign any person to the task, the flow reject this (the reason is because the name in the flow isn't equal to the credentials in the PLANNER, so what I need to do is, set in a "CONDITION" or in "VARIABLE" the email for the person, the name of the person will be available after the response look:
In the table bellow we have John 1, and I know John 1 email is "john1@gmail.com", how in the flow can I create a condition or a loop to test all these names and find the email.. "IF ( Email Response =  " Nome " , " Email " )" in the excel I can use Index or VLOOOKUP to do this, but i need to do this inside the flow action.

Nome	Email
John 1	john1@gmail.com
John 2	john2@gmail.com
John 3	john3@gmail.com
John 4	john4@gmail.com
John 5	john5@gmail.com
John 6	john6@gmail.com
John 7	john7@gmail.com
John 8	john8@gmail.com
John 9	john9@gmail.com

 

Categories:
I have the same question (0)
  • Sutherland Profile Picture
    Microsoft Employee on at

    Hi Ludsons,

    Where your data table stores? If all these table records stored in sharepoint where you could utilize Sharepoint get rows function to get all items and use apply to each function with condition to validate whether input email equals to any email value.

    In addition, u could also set 'flag' to mark it true when you find corresponded item and add 'flag' equals 'False' expression in condition as well. Hope above contents help. Thanks. 

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Congratulations to the March Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Vish WR Profile Picture

Vish WR 873

#2
Valantis Profile Picture

Valantis 813

#3
Haque Profile Picture

Haque 526

Last 30 days Overall leaderboard