Power Platform Community Forum Thread Details

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.

Categories:

Building Power Apps

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.

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.

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: