PowersApps Flow Button to Send Email of Attachments from SharePoint List

[hallmant]

Hello,

I created a Flow in SharePoint (images attached) that when a List Item is selected it sends an email to the user with all the image attachments.  I then created an 3 Screen PowerApps App based on the same SharePoint List.  I am struggeling with creating a Flow Button from the application Detail Screen to essentially perform the same action as the Flow in Sharepoint.  

I have looked at a lot of tutorials showing Flow Buttons put information into SharePoint, but haven't found anything for what I am trying to accomplish.  Any suggestions?

Thanks,

Travis

[Jeff_Thorpe]

Have your tried creating the same fow you are using in SharePoint but instead of using the SharePoint "For a selected item" trigger use the PowerApps trigger. Then for the ID in the Get Item connector use the "Ask in PowerApps" expression.

In PowerApps you should be able to add a button to your Detailed screen that calls the Flow and passes the item id from Detailed screen to the Flow you are executing. 

[hallmant]

Hi Jeff,

So I did exactly as you said and was succesfull in that I could click on the button and get an email with ID information I requested, such as Variety.  The problem I have now is that when I go to add the AttachmentArray to the Send an Email step I do not get the variable "attachmentArray" as I do in my SharePoint flow.  Thus no attachements show up in my email.  Any thoughts on why that variable is not a choice in the dynamic content box?  

Thanks,

Travis

[Jeff_Thorpe]

The rest of the Flow is the same, so you are using Get Item and Get Attachments connectors in Flow and the ID being used is the ID being passed in by PowerApps?

[v-xida-msft · Accepted solution]

Hi @hallmant ,

Could you please share a bit more about your scenario?

Do you want to press the Button within the Detail screen of your app to send an email for the corresponding list item along with all images attachments?

Based on the needs that you mentioned, I think the "For a Selected Item" trigger could not achieve your needs. As an alternative solution, you could customize a new flow (create from blank), and use the "PowerApps" button trigger as the Trigger of the flow. Then within the flow, specify the parameters (e.g. List Item ID) that you want to pass from your app.

After that, within your flow, you could retrieve corresponding SP List Item details based on the passed List Item ID.

I have made a test on my side, please take a try with the following workaround:

Flow's configuration as below:

Within the "Append to array variable" action, Value field set to following:

{
  "Name": @{items('Apply_to_each')?['DisplayName']},
 "ContentBytes": @{body('Get_attachment_content')?['$content']}
}

ContentBytes property should be set to following formula:

body('Get_attachment_content')?['$content']

More details about using expressions within Flow actions, please check the following blog:

https://flow.microsoft.com/en-us/blog/use-expressions-in-actions/

PowerApps app's configuration as below:

Add a Button (called "Send Email") within your Detail Screen, set the OnSelect property to following:

'20190506_case2'.Run(BrowseGallery1.Selected.ID)

On your side, you should type:

'YourFlowName'.Run(BrowseGallery1.Selected.ID)

Please take a try with above solution, check if the issue is solved.

More details about string a flow from an app, please check the following article:

https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/using-logic-flows

Best regards,

[hallmant]

Kris that worked!  Thank you kindly for your help on that.  John and yourself were saviors.  Thanks for taking the time to help me on this.  It is much appreciated.  -Travis

[Sathya2]

In this flow, I am using "get items" action instead of get item, because I have the to fetch the attachment from multiple items with filter query. But I am unable to do the complete action.