cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
mtxe32
Level: Powered On

Using Collection Content in a Flow.

Can you put the contents of a PowerApps Collection in the body of an email when you create a Flow?

or

Can you use the PowerApps Collection contents for the file content when you want to use a Flow to create a file in SharePoint?

 

If either of these is possible, then how would you do it?

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
hpkeong
Level 10

Re: Using Collection Content in a Flow.

Hi

I have created Shopping Apps for my son using
- Collection
- Concatenate
- Comcast
- SaveData and LoadData
And with a click of submit button, email with embeded html body.

Please visit:
Useful Features of PowerApps (12) Email and concat.

Please see the link in Useful Features of PowerApps (12) - Email & Concat

https://powerusers.microsoft.com/t5/PowerApps-Forum/Useful-Features-of-PowerApps-12-Email-amp-Concat...



Hope this helps.

hpkeong

View solution in original post

7 REPLIES 7
Preston
Level: Power Up

Re: Using Collection Content in a Flow.

I to would like to know how to do this. 

PowerApps Staff rgruian
PowerApps Staff

Re: Using Collection Content in a Flow.

 

A collection can be "written into" an existing SP list, which the flow could subsequently access.

 

    Collect(MySPList, MyLocalCollection)

 

The two schemas have to be compatible (they do not have to match exactly, but there can't be any type conflicts).

 

I hope this helps.

 

Radu Gruian [MSFT] ** PowerApps Staff
mtxe32
Level: Powered On

Re: Using Collection Content in a Flow.

I don't think the SPList would work for us because the info they're sending requires approval, and it would be inefficient to have to approve one line at a time. 

 

Let me explain exactly what I want to happen. Then you might be able to steer me in the direction for the simplest solution

 

I have an app that acts as a means to place an order. Users enter info into serveral textinput boxes and press a button that adds the info as a collection entry. They are usually going to have serveral entries in the collection. They can then look at a gallery to view all the entries they put in the collection. When they hit a "submit" button i want all the info in the collection to be sent via email or in a file that is saved in a SharePoint library. I don't have to use a collection. I just want my users to be able to create an order with multiple items and have that info be sent via email and/or a file on sharepoint. What is the BEST way to do this via PowerApps?

PowerApps Staff rgruian
PowerApps Staff

Re: Using Collection Content in a Flow.

I see. This process is described in quite a bit of detail in some of the earlier posts. See this for example:

https://powerusers.microsoft.com/t5/PowerApps-Forum/Send-information-by-Email/m-p/3371#M1702

 

Here's what you need to do:

1. Connect your Submit button to a flow that e.g. sends an email

2. On submit, aggregate/assemble the body of your email based on the local data.

3. After aggregating, pass that value to the Flow

 

For (2), you can make use of the Concat function to accomplish this. It will iterate over your local collection and allow you to aggregate the rows into a text value, which will ultimately become the email body in this case.

https://powerapps.microsoft.com/en-us/tutorials/function-concatenate/

 

I hope this helps.

 

Radu Gruian [MSFT] ** PowerApps Staff
Highlighted
hpkeong
Level 10

Re: Using Collection Content in a Flow.

Hi

I have created Shopping Apps for my son using
- Collection
- Concatenate
- Comcast
- SaveData and LoadData
And with a click of submit button, email with embeded html body.

Please visit:
Useful Features of PowerApps (12) Email and concat.

Please see the link in Useful Features of PowerApps (12) - Email & Concat

https://powerusers.microsoft.com/t5/PowerApps-Forum/Useful-Features-of-PowerApps-12-Email-amp-Concat...



Hope this helps.

hpkeong

View solution in original post

mtxe32
Level: Powered On

Re: Using Collection Content in a Flow.

I actually found your post yesterday before you replied to this post. Thank you for posting you solution. I am implementing this now and it is working.

hpkeong
Level 10

Re: Using Collection Content in a Flow.

Hi

 

Glad to hear that it really works for you.

I have posted, and hope to keep posting to share, whatever useful features, for sharing over here, and hope you can view other useful features (some maybe referering to very old PowerApps edition but good for reference).

 

In case you found something incorrect or not uptodate or wrongly defined or somewhere to improve, please help to amend and improve.

 

Thanks and have a nice day.

hpkeong

Helpful resources

Announcements
thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Power Platform World Tour

Find out where you can attend!

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

Top Kudoed Authors (Last 30 Days)
Users online (5,977)