User not getting email thru ask in Powerapps function only I get when clicked on button

[Surajde]

Hi Team, 

Error Details:  

The specified object was not found in the store., The process failed to get the correct properties.

this is my flow and it asks input in Powerapps. Only I am getting the email with attachment but not any other user. if they click on button to export the CSV file they get error. 

My code is as per below: 

OnSelect property

Set(varLeavedata,AddColumns(Filter('Vacation Data',And(Or(Status.Value="Approved",Status.Value="Pending 2nd Manager Approval",Status.Value="Pending Manager Approval"),Or(Manager.Email=varCurrentUserEmail,'2nd_Manager'.Email=varCurrentUserEmail,SrMgm1.Email=varCurrentUserEmail,SrMgm2.Email=varCurrentUserEmail,SrMgm3.Email=varCurrentUserEmail))),"1stManager",Manager.DisplayName,"RequestedBy",Requestor.DisplayName,"SrManager",'2nd_Manager'.DisplayName,"ApprovalStatus",Status.Value,"FlowType",'Approval Flow'.Value,"AmdocsID",If(IsBlank('Employee ID'),"NA",'Employee ID')));

ClearCollect(myReport,ShowColumns(varLeavedata,"ID","AmdocsID","Title","RequestedBy","From","To","HolidayCount","1stManager","SrManager","ApprovalStatus","FlowType"));Notify("Downloading...",NotificationType.Information,3000);

ExportReport.Run(JSON(myReport,JSONFormat.IncludeBinaryData),varCurrentUserEmail);

Error Details:  

The specified object was not found in the store., The process failed to get the correct properties.

[iAm_ManCat]

Hi!

It looks like you are triggering the flow from within the app, which will make it run under the user's context, and as you are using a 'send on behalf'/'Send as' action, sending from the vacationmanagement mailbox, the other users will all need sending rights from that account if you wish to do it this way.

I would suggest instead writing to a SharePoint list from the app and then having the flow triggered 'when an item is created in ListName', then the connections and mailboxes you use will always be based on the creator of the flow rather than the individual user's context.

Cheers,

Sancho

[Surajde]

Hi Sancho, Thanks for writing. But can you simplify the solution? 

adding to my query - I'm willing that Whenever user clicks on Export to Excel button he should be able to get the report on his email in CSV format. at present you're right that only I'm getting it only email thru VactionManagement@XXXXX.com. 

However, there is another flow which is based on 'when an item is created' in sharepoint list email notification triggers to the requestor from same account. check below screenshot. Then why there is problem when triggered from app using button to email from this shared mailbox with attachment??

[iAm_ManCat · Accepted solution]

Hi,

So, its because you are sending on behalf of this shared mailbox from the app - it checks if that person currently using the app when the button is clicked has the rights to send from that mailbox. The account you are building the app/flows with may have access to send from this mailbox, but they do not.

This is how all flows triggered from an app work - they trigger under the user context

When its triggered from outside the app, they will use whatever account has been set for the action/connection in the flow

so to work from within the app, you need to use a flow action that doesn't send on behalf of another mailbox - just use the normal 'Send an Email V2' instead of 'send from a shared mailbox' - it will use their own email to send themself an email then if you keep all the other same To: and other values

[Surajde]

Understood. But that will stupid if one sends email himself 🙂 

Can we change the flow to send on email to download in local?