Answered

Sending Detail Screen to User Email

(0) Share

Report

Posted on by crjwarre

I have a Detail screen that is populated by conditional fields (controlled by the value of a "format" field). My end goal is to have the app send just the fields and data present in the detail screen to person using the app's email address. (My user group is also small enough that this can be hard coded for individual buttons if needed). I am struggling with a good way to just get this data on screen, and not end up parsing through the SharePoint table it is stored in or end up with a bunch of irrelevant fields. Thank you for your help!

Categories:

Building Power Apps

I have the same question (0)

All responses (7)

Answers (1)

Sort by

Verified answer

mdevaney 29,991 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

@crjwarre

I would accomplish this by using the OutlookOffice365 connector. By placing code to send an email in the OnSuccess property of your form and using the LASTSUBMIT property to access the data we can send an email with info to the user.

What columns do your have? What should the email look like? This info would benefit my explanation.

---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."

Was this reply helpful? Yes No
crjwarre 62 on at

Like
a
(0)

Report
Copy link

Link copied!

I have a list of 52 columns starting with a Lot # (required), and then each column becomes visible based on the format selected. Ideally this would look like a table without all of the blank fields present. This is attempting to replace an InfoPath what would send an "Update" to the user logged into SharePoint.

Was this reply helpful? Yes No
crjwarre 62 on at

Like
a
(0)

Report
Copy link

Link copied!

Ideally it would look something like this detail view screen

Was this reply helpful? Yes No
mdevaney 29,991 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!
@crjwarre

Excellent screenshot. This provides the perfect information to share some sample code.

Put this code in the OnSuccess property of your Form. This will show how to display the 1st 3 fields on data in your form. Continue the same pattern to add more.

Set(newRecord, Form1.LastSubmit); Office365Outlook( User().Email, "Subject Line", " Lot #: "& newRecord.'Lot #'&" Client #: "& newRecord.'Client #'&" Fill Line: "& newRecord.'Fill Line' );

My example shows how to display text fields but you will have to make slight modifications to the pattern for Choices, Dates, People, etc.

---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."

Was this reply helpful? Yes No
crjwarre 62 on at

Like
a
(1)

Report
Copy link

Link copied!

Thank you so much! I will have to try it when I get back into work next!!

Was this reply helpful? Yes No
crjwarre 62 on at

Like
a
(0)

Report
Copy link

Link copied!

Is there a way to get it to hide unfilled fields without coding an entire show hide for each filed based on the Visible statement? and what modifications would be needed for the choice fields? Thank you so much! It is working now.

Was this reply helpful? Yes No
crjwarre 62 on at

Like
a
(0)

Report
Copy link

Link copied!

I'm also struggling to get it to appear on multiple different lines rather than a blob of text

Was this reply helpful? Yes No