I'm pretty sure the answer is no, this isn't possible, but I am going to ask anyway.
I have a flow with the following connections:
- SharePoint
- Excel Online (Business)
- Office 365 Outlook
I need to share the flow with a number of users. Each and every one of those users has access to all the resources required to run the flow (with the caveat below), and I would prefer that they do so with their credentials rather than mine or those of a shared account.
Is there any way to configure the connections so that they use the credentials of the user running the flow? This is a security issue, for two reasons.
First, if a user is removed from the SharePoint site, the flow should fail for that user without the SharePoint site administrator having to know that the flow even exists.
Second, the flow, which is essentially a mail merge, has two modes, "draft" and "final". In draft mode, I want the emails to be sent from and to the user's own mailbox so that they can validate the content and format before the final emails go out. In final mode, I want the emails to be sent from a shared mailbox. I need separation between those that can send themselves draft emails (the marketing grunt whose job it is to compose and format the email text) and those that can send outside users final emails (the marketing overlord whose head will be served on platter if there is anything that upsets a user). The way things stand right now, everyone has the right to run the flow in final mode (putting the grunt at the same level as the overlord), but if I had user-specific connections, the flow would work in draft mode for everyone and in final mode only for those users who have access to the shared mailbox.
Please tell me this is possible.
