Power Platform Community Forum Thread Details

Due to some limitations by the company I am doing an internship at. I am trying to create a flow and I just cant make it work. At the moment I have an excel table that contains email addresses in one column, and in the other one just "YES" or "NO". The second column I can manually change it from "YES" to "NO" and I use it to keep track of who has access for submitting a form or not.

I have another flow that whenever users complete a tutorial. Their email address is stored in the excel with a "YES" (that one works perfectly)

I wanted to create a flow that when any user submits a form. It looks up the excel and checks if that email address has a "YES" or a "NO" next to it.

If its a "YES" then It sends me an Email with the answers of the form (The sending an email part was easy and works all the time)

However I would like that whenever someone who is not listed on the excel file, or someone who I have changed them to "NO"; these individuals would get an email saying that they should complete the tutorial to gain access.

Id appreciate any insight or if you fine people know any better way to tackle this issue, I would love to read your insights! Have a nice day all! Its also my first time using Power Automate:)

Categories:

Building flows