Hello,
I need some more eyes on this issue. I can't find what is wrong.
Scenario:
- The app I'm working on sends an HTML email to the User, the User's manager, and a single person when a form is submitted.
- Submitted forms are written to a Sharepoint List.
- From there, a Flow kicks off that converts the Sharepoint record to a PDF.
- BOTH the Sharepoint record AND the PDF are created, but the HTML IS NOT BEING GENERATED in some cases only.
Code:
- OnStart of first screen, create a variable for the User's Manager's email.
/*============================================================
Set variables for users manager.
============================================================*/
Set(varUserManager, Office365Users.Manager(User().Email).Mail)
- "Submit" button OnSelect, create a Collection of all completed form fields, then submit form.
- NOTE: Below is redacted. 3/4 of the fields are dropdown.Update and text.Update.
- I have no idea why and they cannot be changed to .Selected.Value nor .Text. Only .Update is accepted.
/*=====================================================
Create a collection of all the completed form fields.
=====================================================*/
ClearCollect(colEntireForm,
{
this: textbox1.Selected,
that: textbox2.Selected.Value
}
);
/*=====================================================
Submit the completed form
=====================================================*/
SubmitForm(form_TIEvalResults)- OnSuccess of the Form, send an HTML of results to User, Users Manager, and a single individual
/*==============================================================
Email the user and the users manager a completed form in HTML format using the htmlResults template.
*/==============================================================
'Outlook.com'.SendEmail(
Office365Users.MyProfile().Mail & ";" &
varUserManager & ";" &
"Some.One@MyCompany.com",
"Completed Form",
email_htmlResults.HtmlText,
{IsHtml: true}
);
/*==============================================================
Take user to Success screen.
*/==============================================================
Navigate(
screen_success,
ScreenTransition.None
)"<h3>Form Results</h3>" &
"<b>Results:</b>" &
"<a href='" & evalPDFLink_input.Text & "'>Link to PDF Version</a>" &
"<br> <br>" &
"<table width='100%' border='1' cellpadding='5' style='border:1px solid black; border-collapse:collapse; text-align:left'>" &
"<col width='400'>" &
"<tr style='background-color:#efefef'>
<th>Step</th> <th>Answer</th>
</tr>
<tr>" &
Concat(colEntireForm,
"<td>" & "Date: " & " </td>
<td>" & Text(evaluationDate_datePicker.SelectedDate,"[$-en-US]mm/dd/yyyy") & " </td>
<tr>" &
"<td>" & "this" & " </td>
<td>" & textBox1.Text & " </td>
<tr>" &
"<td>" & "that" & " </td>
<td>" & textBox2.Selected.Value & " </td>
"</tr>
<tr>") &
"</Table>"
Additional observations:
- I had a similar issue with this app a long time ago that went "unsolved mystery".
- The code comment just above SubmitForm(), WAS the old school format ("Take user to success screen";). I've updated to my preferred comment block (shown above).
Any ideas on how I can debug this?
Thank you!
TAGGING HELP 🙂 : @KickingApps, @timl, @wyotim, @v-monli-msft
