Lookup dataset > flow condition based on result

(0) Share

Report

Posted on by jasonmurphy

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.

Categories:

Building flows

I have the same question (0)

All responses (5)

Answers (1)

Verified answer

v-LilyW-msft on at

Like (0)

Report

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

Was this reply helpful? Yes No
jasonmurphy 34 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
v-LilyW-msft on at

Like (0)

Report

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!

Was this reply helpful? Yes No
jasonmurphy 34 on at

Like (0)

Report

Thanks @v-LilyW-msft, yes, this works well. I have accepted it as a solution. Thanks again for your help. Jason.

Was this reply helpful? Yes No
jasonmurphy 34 on at

Like (0)

Report

Hi @v-LilyW-msft,
I have now got this working. Thanks!

Thanks, Jason.

Was this reply helpful? Yes No