cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Legal11
New Member

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
v-monli-msft
Community Support
Community Support

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
v-monli-msft
Community Support
Community Support

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
PA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

secondImage

Demo Extravaganza Winner Announcement

Please join us on Wednesday, July 21st at 8a PDT. We will be announcing the Winners of the Demo Extravaganza!

V3_PVA CAmpaign Carousel.png

Community Challenge - Giveaways!

Participate in the Power Virtual Agents Community Challenge

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 (4,490)