cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Legal11
Level: Power Up

Having e-mails sent from a powerapp be stored automatically

Hello, I have a question in regards to a registration powerapp that I am making for my office. Basically, a client who comes into our office can sign in via this powerapp, they can fill in information such as their name and e-mail, and then they sign a waiver. All of their identifying information, including name, phone number, etc, is sent to an outlook e-mail account via the send email command, and the signature for the waiver is also sent as a picture both to the client and to us. Now, my problem lies in that I would like to have all of those e-mails with the information and signatures be stored automatically, like in an archive. I am already aware that outlook can be set up to archive e-mails, but if possible I would like some sort of instantaneous archival, and perhaps in an online cloud storage, like google or microsoft cloud. I am also familiar with flow and sharepoint and how they can be used to accomplish a similar function to the one I am describing, but if possible I would like to avoid using them in order to keep this powerapp clean and isolated from any complex connections. Any solutions or general information are greatly appreciated.

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: Having e-mails sent from a powerapp be stored automatically

Hi @Legal11,

 

First of all, I don't think that you could store the whole emails to Google or Microsoft cloud storage like OneDrive. But before you send the email, maybe all the user input informations are stored separately like in textinput controls, right? If so, you could use a Patch function, or, you could just use a Form control to hold all these textinput controls and connect the Form to an Excel table stored in OneDrive. In this way, you could use the button to both send an email, and submit a record to Excel table. 

 

 

Here are my steps to achieve this:

1. Create an Excel table like below and upload this Excel table to OneDrive. Notice that you must include the "[image]" in column header to make it work as picture in PowerApps.

1.PNG

2. Create the auto-generated app using this table of OneDrive connection.

3. On EditScreen1, select the EditForm, select the image icon and choose Add notes.

Capture.PNG

 

4. Set the OnSelect property of the submit check button to:

Office365.SendEmail(DataCardValue7.Text, DataCardValue6.Text, DataCardValue5.Text, {Attachments:Table({Name:Concatenate(DataCardValue6.Text,".png"), ContentBytes:Pen1.Image, '@odata.type':""})});SubmitForm(EditForm1)

This button will send the email and at the same time submit the form information to excel table.

 

Notice:

1. DataCardValue7 is for input of send the email to, DataCardValue6 is for subject, DataCardValue5 is email body. I just used the subject to be the name of the signature picture name. 

2. After you submit the record from PowerApps, there will be a folder called "ExcelFileName_Images" automantically created in OneDrive. It will store all the signatures you created from PowerApps.

 

I just tested with this, and it works for me:

Capture.PNGCapture.PNG

 

Regards,

Mona

 

Community Support Team _ Mona Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

1 REPLY 1
Community Support Team
Community Support Team

Re: Having e-mails sent from a powerapp be stored automatically

Hi @Legal11,

 

First of all, I don't think that you could store the whole emails to Google or Microsoft cloud storage like OneDrive. But before you send the email, maybe all the user input informations are stored separately like in textinput controls, right? If so, you could use a Patch function, or, you could just use a Form control to hold all these textinput controls and connect the Form to an Excel table stored in OneDrive. In this way, you could use the button to both send an email, and submit a record to Excel table. 

 

 

Here are my steps to achieve this:

1. Create an Excel table like below and upload this Excel table to OneDrive. Notice that you must include the "[image]" in column header to make it work as picture in PowerApps.

1.PNG

2. Create the auto-generated app using this table of OneDrive connection.

3. On EditScreen1, select the EditForm, select the image icon and choose Add notes.

Capture.PNG

 

4. Set the OnSelect property of the submit check button to:

Office365.SendEmail(DataCardValue7.Text, DataCardValue6.Text, DataCardValue5.Text, {Attachments:Table({Name:Concatenate(DataCardValue6.Text,".png"), ContentBytes:Pen1.Image, '@odata.type':""})});SubmitForm(EditForm1)

This button will send the email and at the same time submit the form information to excel table.

 

Notice:

1. DataCardValue7 is for input of send the email to, DataCardValue6 is for subject, DataCardValue5 is email body. I just used the subject to be the name of the signature picture name. 

2. After you submit the record from PowerApps, there will be a folder called "ExcelFileName_Images" automantically created in OneDrive. It will store all the signatures you created from PowerApps.

 

I just tested with this, and it works for me:

Capture.PNGCapture.PNG

 

Regards,

Mona

 

Community Support Team _ Mona Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

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,078)