Power Platform Community Forum Thread Details

Hello World...

I have been stuck on this for quite some time now, and really need some guidance or solutions.

So I have a Power Apps app which is accessible to everyone in the organisation. This collects data and then upon a button press, should be initiating a flow to send an email with said data from a specific mailbox. Through all my googling and experimenting, I have come across a number of potential solutions, however they all have their drawbacks that have prevented me from following through to a successful solution. I am not an admin, and therefore do not have access to a lot of things, and don't want to be bothering them to make changes to things if it is not guaranteed to work. Below is what I have tried already.

1 - Calling the flow directly from Power Apps does not work unless the user submitting the data has send on behalf permissions for the mailbox this email is to be sent from. This is far from ideal, as we do not want to grant everyone access to the mailbox.

2 - It tried changing this to make the email send from the user submitting the request, but this also had some issues, where it didn't trigger the flow. But again is not ideal nor what we are trying to do, as we would like this solution to look professional and automated, whereas if it comes from the user itself, there would be no way for us to verify if the email we receive is as a result of the app being used or a previously used email being re-purposed, meaning we have no control over the data validation.

3 - Using a SharePoint List to store the data, and then have a flow trigger upon adding a new entry to the list. This worked for people in my direct team, given they have access to modify on the SharePoint the list is stored, however for people outside our team this does not work, as they only have view access to the SharePoint. If I can get all users set up to be able to add lines to this specific list, but not modify anything else they cannot already then this solution would be feasible, but as I do not have admin rights I cannot see all solutions available to see if this is possible.

4 - Using run-only access for the specific power automate flow and setting the O365 connection to use my specific profile. This works but I do not want to send an invite to everyone in the organisation by adding them to this list, which I cannot find a way around. Some google searches were indicating to grant run-only access to this flow for all users who have access to a SharePoint site, which would work, but I cannot find a way to do this.

Categories:

Building Power Apps