Skip to main content

Notifications

Power Automate - Building Flows
Unanswered

Excel Verification

Posted on by
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:)
 

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

November 2024 Newsletter…

November 2024 Community Newsletter…

Community Update Oct 28…

Power Platform Community Update…

Tuesday Tip #7 Community Profile Tips…

Welcome to a brand new series, Tuesday Tips…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 143,246

#2
RandyHayes Profile Picture

RandyHayes 76,308

#3
Pstork1 Profile Picture

Pstork1 63,884

Leaderboard