cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Beering
Frequent Visitor

Security Question befor starting a Power Automate Flow

Greetings to all members,

 

I'm faced with a challenge that I can't really get any further with. We are increasingly using the Power Automate visual in our Power BI reports. In this context, the following question arises for me: How can I make it so that a kind of security query is made before the flow is started by clicking on the button. It would be nice if a question of the following kind appeared before: "Do you really want to start the flow?". In my experience, the user occasionally starts the flow before he has made the selection, with the result that a large number of data records are then transferred to the flow. I would like to avoid that if possible.

 

A second question related to this. Is there any way to reliably determine the number of data records transferred? And this before the flow is started. That would be very helpful, because then I could inform the user in the security prompt that a large number of data records are about to be transferred to the flow, which may not be what the user want.

 

Anyone have an idea?

I'm grateful for every hint.

 

Thanks and best regards
Martin Beering

1 ACCEPTED SOLUTION
AlexanderPrime
Super User
Super User

Might be worth looking into the approval system in Power Automate. https://docs.microsoft.com/en-us/power-automate/get-started-approvals ("Start and Wait For Approval" looks like a good candidate) Possibly setting up the approval at the start of the flow and instructing the flow to send an email to the requestor so they can approve their own requests to signal that their request was intended. 

 

For your second question a bit more information about what the flow is doing is needed to answer that, can you describe what the flow is doing in a bit more detail? This may need to be defined in Power Automate and could possibly be added into the email "approval"

Please note - I am not affiliated with Microsoft, I'm just an end user like yourself.
Just a regular guy stuck doin' Data Science. (I wanted to work in Animation! :D)

If my post has helped you, please don't forget to thumbs up or click "Accept as solution" if it solved your problem!

View solution in original post

1 REPLY 1
AlexanderPrime
Super User
Super User

Might be worth looking into the approval system in Power Automate. https://docs.microsoft.com/en-us/power-automate/get-started-approvals ("Start and Wait For Approval" looks like a good candidate) Possibly setting up the approval at the start of the flow and instructing the flow to send an email to the requestor so they can approve their own requests to signal that their request was intended. 

 

For your second question a bit more information about what the flow is doing is needed to answer that, can you describe what the flow is doing in a bit more detail? This may need to be defined in Power Automate and could possibly be added into the email "approval"

Please note - I am not affiliated with Microsoft, I'm just an end user like yourself.
Just a regular guy stuck doin' Data Science. (I wanted to work in Animation! :D)

If my post has helped you, please don't forget to thumbs up or click "Accept as solution" if it solved your problem!

Helpful resources

Announcements
September Update

Check it Out!

Click here to learn more about the September 2022 updates!

Power BI Dev Camp Session 26

Check it Out!

Mark your calendars and join us on Thursday, September 29 at 11a PDT for a great session with Ted Pattison!

Top Solution Authors