cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
mtxe32
Frequent Visitor

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
hpkeong
Community Champion
Community Champion

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
New Member

I to would like to know how to do this. 

rgruian
Power Apps
Power Apps

 

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
Frequent Visitor

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?

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
hpkeong
Community Champion
Community Champion

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
Frequent Visitor

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
Community Champion
Community Champion

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
PA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Welcome Super Users.jpg

Super User Season 2

Congratulations, the new Super User Season 2 for 2021 has started!

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Top Solution Authors
Top Kudoed Authors
Users online (949)