cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
hpkeong
Level 10

Useful Features of PowerApps (12) - Email & Concat

Hi

 

I wish to share my complete Email + Concatenare + Collection + ClearCollect + SaveData / LoadData, esp. Concat functions & HTML5 (partial support).

 

Email & Concat functions are not clearly described in LEARN.

 

Hence, with numerous trial, information from forums (Project Siena and PowerApps, with respect),  attach a sample apps screenshot: This apps is written for my Son for Online Shopping from his clients.

 

Key Function:

- Use Concat to collect Records (from Gallery -> Collection) and organized with HTML

- Use & to create proper spacing, <br> for line break, <b>, <u>,..for fonts formating, Html5 (table, ul, ol and many other formating table,.. though not all are supported, such as border).

- Show the actual results in Email.

 

Hopefully, more improvment can be made on this and also hope that it helps those wish to use proper Concat for sending email (regardless of the number of records inside the gallery/collection as it will append into email automatically).

 

Happy reading and beautiful Sunday.

 

mail.jpg

hpkeong
1 ACCEPTED SOLUTION

Accepted Solutions
bsmith_itgroove
Level: Powered On

Re: Useful Features of PowerApps (12) - Email & Concat

Hey this is great hpkeong, thanks! My variation on the submit checkmark was: Concatenate("This is a hidden HTML field:","<br><br>","<b>DataCardValue10</b>",DataCardValue10.Text).  On my first test I'm getting the HTML markup appearing in my email body, but it's not a big deal I've probably just got some syntax wrong.  The good news is I'm automatically getting a concatenation of the plain text I put in plus the values from other fields in the PowerApp, in a way that's very transparent to the end user in the PowerApp.  

 

All the best,

Bruce  

 

P.S. Lots of room for improvement on this from the PowerApps / Flow team(s), but at least I can keep putting one foot in front of the other!

View solution in original post

7 REPLIES 7
bsmith_itgroove
Level: Powered On

Re: Useful Features of PowerApps (12) - Email & Concat

Hey this is great hpkeong, thanks! My variation on the submit checkmark was: Concatenate("This is a hidden HTML field:","<br><br>","<b>DataCardValue10</b>",DataCardValue10.Text).  On my first test I'm getting the HTML markup appearing in my email body, but it's not a big deal I've probably just got some syntax wrong.  The good news is I'm automatically getting a concatenation of the plain text I put in plus the values from other fields in the PowerApp, in a way that's very transparent to the end user in the PowerApp.  

 

All the best,

Bruce  

 

P.S. Lots of room for improvement on this from the PowerApps / Flow team(s), but at least I can keep putting one foot in front of the other!

View solution in original post

EdHacker
Level: Powered On

Re: Useful Features of PowerApps (12) - Email & Concat

Access to Nested Galleries.

 

<table> & Concat(Gallery1.Allitems,"<tr><td>" & Head1 & "</td></tr></table>

 

creates a HTML table with one row for each item in Galley1 with a column containing the text of card Head1.

 

I need to nest a gallery in each row of Gallery1 (like your example).

 

My problem is what is the syntax to access the nested gallery. For example:  To build a nested table from Gallery2 SubTitle card.

 

<table> & Concat(Gallery1.Allitems,"<tr><td>" & Head1 & "</td> <td> <table>" &  Concat(Gallery2.AllItems, "<tr><td> " & SubTitle & "</td></tr> )  &" </table> </td></tr></table>

 

It seem that there must be an array of Gallery2's somewhere.   One possible syntax would be something like:

 

Concat(ThisItem.Gallery2.AllItems,)....

 

or

 

Concat(Gallery2(ThisItem).AllItems,...)

 

Any ideas?

 

Thanks

livingstonep
Level 8

Re: Useful Features of PowerApps (12) - Email & Concat

hi the link is gone, can you please give us the link again to your library of functions


@hpkeong wrote:

Hi

 

I wish to share my complete Email + Concatenare + Collection + ClearCollect + SaveData / LoadData, esp. Concat functions & HTML5 (partial support).

 

Email & Concat functions are not clearly described in LEARN.

 

Hence, with numerous trial, information from forums (Project Siena and PowerApps, with respect),  attach a sample apps screenshot: This apps is written for my Son for Online Shopping from his clients.

 

Key Function:

- Use Concat to collect Records (from Gallery -> Collection) and organized with HTML

- Use & to create proper spacing, <br> for line break, <b>, <u>,..for fonts formating, Html5 (table, ul, ol and many other formating table,.. though not all are supported, such as border).

- Show the actual results in Email.

 

Hopefully, more improvment can be made on this and also hope that it helps those wish to use proper Concat for sending email (regardless of the number of records inside the gallery/collection as it will append into email automatically).

 

Happy reading and beautiful Sunday.

 

mail.jpg


 

Highlighted
PK_Hong
Level 8

Re: Useful Features of PowerApps (12) - Email & Concat

Hi

 

I dont embed anylink.

If you want, private message me and i will email to you.

 

Thnks

danisman
Level: Power Up

Re: Useful Features of PowerApps (12) - Email & Concat

Link for me too .. thanks for your help!

Misa
Level 8

Re: Useful Features of PowerApps (12) - Email & Concat

@PK_Hong Hi can you send me the link as well?  Thank you

PK_Hong
Level 8

Re: Useful Features of PowerApps (12) - Email & Concat

Hi @Misa 

 

I am sorry I have removed this apps and no more formula left.
Anyway please refer to the screenshot and retype. It workds.

 

Thanks

Helpful resources

Announcements
New Ranks and Rank Icons in April

'New Ranks and Rank Icons in April

Read the announcement for more information!

Better Together’ Contest Finalists Announced!

'Better Together’ Contest Finalists Announced!

Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.

thirdimage

Power Apps Community User Group Member Badge

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

sixthImage

Join THE global Microsoft Power Platform event series

Attend for two days of expert-led learning and innovation on topics like AI and Analytics, powered by Dynamic Communities

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

thirdimage

Community Summit North America

Innovate, Collaborate, Grow - The top training and networking event across the globe for Microsoft Business Applications

Top Solution Authors
Top Kudoed Authors
Users online (10,845)