Power Platform Community Forum Thread Details

Hi Randy,

I hope you had a nice weekend. I have some buttons and labels on my Logistics Screen that aren't refreshing in real time. I think the issue is with the OnSuccess formula. The form used to show the last submit immediately before I introduced the On Hold email portion. Everything seems to be working as intended otherwise, it is just that I have to navigate to the home screen and then back to the record in order to see that latest changes. Since my formula isn't displaying any errors, is it an "order of operations" issue? I've tried several different formula sequences without success. On hitch might be the email If statement. It says what to do if the status is "On Hold", but it doesn't say what to do otherwise. Would that be what is throwing things off? If so, what do I do to fix it?

Thanks again for all your help, Teresa

UpdateIf('Domestic Shipping Requests', ID=Self.LastSubmit.ID && frmLogistics.LastSubmit.Status.Value="Shipped",{Clicks: Self.LastSubmit.Clicks + 1});
If(frmLogistics.LastSubmit.Status.Value= "On Hold",
Office365Outlook.SendEmailV2(
 varRecord.'Requestor Email',
 "CSO Shipping Request " & valReqNumber.Text & " has been placed on hold - please contact Logistics",
 "<p>Hello,</p>
<p>More information is needed before we can ship your items to "& valCompanyLS.Text &".</p><p>Please contact us at your earliest convenience.</p><p><b>Contact Information:</b><br>Email: <a href=mailto:cso-team@domain.com>cso-team@domain.com</a><br>Dept phone number: (503) XXX-XXXX</p><p>Our hours of operation are 7:00am-3:30pm. Please note that 2:00pm is the drop-off deadline for same day shipments.</p>
<p><a href='https://apps.powerapps.com/play/12345?tenantId=12345&hidenavbar=true&ProjectID="& varRecord.ID &"'>CLICK HERE</a> to view and/or edit your shipping request.</p><p>Thank you,<br>Logistics Team</p>"
, {Bcc:varUser.Email,Importance:"High"}));
Set(
 varTracking,
 false
);
UpdateContext({EditLogForm: false});
Set(
 varRecord,
 frmLogistics.LastSubmit
);
ViewForm(frmLogistics);
Set(
 varPlaySpinner,
 false
)

Categories:

Building Power Apps