You’re offline. This is a read only version of the page.
34
Hi Folks,
Wondering if this Flow is possible as a proof of concept?
We want users to submit an MS Form, then a flow will check whether the user is present on a database (Excel Sheet of SP List) by looking up their email.
If they are present on the DB, they receive an email with one set of instructions. If they're not on the DB they receive a separate set of instructions.
I'm okay with all parts of the flow, except looking up the DB to check.
Any help appreciated, thanks, Jason.
Thanks @v-LilyW-msft, yes, this works well. I have accepted it as a solution. Thanks again for your help. Jason.
Hi @jasonmurphy
Has your problem been solved?
If my solution helps, then please consider Accept it as the solution to help the other members find it more quickly.
Best Regards!
Hi @v-LilyW-msft, thanks so much for this detailed explanation and example. Greatly appreciated. I will give this a go and report back. Have a great weekend, Jason.
Hi @jasonmurphy
Thank you for posting.
According to your description, you want to check whether the user is present on a database when an From is submitted.
I set up a simple Flow with the data is stored in excel.
I use Filter Query to filter the row that meet the condition. If there is no row that meet the condition, indicates the user does not exist on DB, otherwise,the user exists on the DB
You can refer to as below：
Expression:empty(outputs('List_rows_present_in_a_table')?['body/value'])
This is my database in Excel
After Test2 submit a form, Test2 will receive an email as below:
Hope the content above may help you.
Best Regards
Lily
#1
Michael E. Gernaey
566
Super User 2025 Season 1
#2
David_MA
516
Super User 2025 Season 1
#3
stampcoin
492
Share
Report
All responses (
Answers (
