cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
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
Highlighted
Community Champion
Community Champion

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

Re: Using Collection Content in a Flow.

I to would like to know how to do this. 

Highlighted
Power Apps
Power Apps

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

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?

Highlighted
Power Apps
Power Apps

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

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

Highlighted
Frequent Visitor

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.

Highlighted
Community Champion
Community Champion

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
secondImage

New Return to Workplace

Reopen responsibly, monitor intelligently, and protect continuously with solutions for a safer work environment.

Experience what’s next for Power Apps

Join us for an in-depth look at the new Power Apps features and capabilities at the free Microsoft Business Applications Launch Event.

Check this Out

Helpful information

Featuring samples like Return to the Workplace and Emergency Response Applications

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors
Users online (9,318)