cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results forย 
Search instead forย 
Did you mean:ย 
Reply
thunter
Post Prodigy
Post Prodigy

The formula contains 'ParenClose' where 'Eof' is expected.

โ€Ž09-18-2020 05:16 AM

Not really sure why I am getting this error. I have tried removing parenthesis. Also, tried adding another parenthesis with semi colon. Nothing seems to work. Any ideas? Thank you.

eof1.png

 

With({data: NewIncidentForm.LastSubmit},

 // SEND NOTICE TO ALL SELECTED GROUPS
 ForAll(emaillist,
 Office365Outlook.SendEmailV2(
 EmailAddr,
 Coalesce(data.billto, data.name) & "- New Incident - " & data.incident_num,
 "<b>Incident Number: </b>" & data.incident_num & "<br>
 <b>Name: </b>" & data.name & "<br>
 <b>Incident Date: </b>" & data.inc_date & "<br>
 <b>Reported By: </b>" & data.reportedby & "<br>
 <b>Date Reported: </b>" & Today() & "<br>
 <b>Report Group: </b>" & Concat(RptGrpDropDown.SelectedItems, Text(RptGrp) & " ") & "<br>
 <b>Trip #: </b>" & data.trip & "<br>
 <b>Tractor: </b>" & data.tractor & "<br>
 <b>Trailer: </b>" & data.trailer & "<br>
 <b>Bill To: </b>" & data.billto & " - " & BillToName.Text & "<br>
 <b>Consignee: </b>" & data.consignee & " - " & ConsigneeName.Text & "<br>
 <b>Shipper: </b>" & data.shipper & " - " & ShipperName.Text & "<br>
 <b>Location of Incident: </b>" & data.location & "<br>
 <b>Description of Incident: </b>" & data.description & "<br>
 <b>At Fault: </b>" & data.fault & "<br>
 <b>Preventable: </b>" & data.prevent & "<br>
 <b>Status: </b>" & data.status
 );

 // SEND NOTICE TO INTERNAL STAFF
 Office365Outlook.SendEmailV2(
 "xxxx@xxxx.com; xxxx@xxxx.com",
 data.name & "- New Incident - " & data.incident_num,
 "<b>Incident Date: </b>" & data.inc_date & "<br>
 <b>Incident Number: </b>" & data.incident_num & "<br>
 <b>Name: </b>" & data.name & "<br>
 <b>Date Reported: </b>" & Today() & "<br>
 <b>Trip #: </b>" & data.trip & "<br>
 <b>Tractor: </b>" & data.tractor & "<br>
 <b>Trailer: </b>" & data.trailer & "<br>
 <b>Bill To: </b>" & data.billto & " - " & BillToName.Text & "<br>
 <b>Consignee: </b>" & data.consignee & " - " & ConsigneeName.Text & "<br>
 <b>Shipper: </b>" & data.shipper & " - " & ShipperName.Text & "<br>
 <b>Location of Incident: </b>" & data.location & "<br>
 <b>Description of Incident: </b>" & data.description & "<br>
 <b>At Fault: </b>" & data.fault & "<br>
 <b>Preventable: </b>" & data.prevent & "<br>
 <b>Status: </b>" & data.status &"<br>
 <b>Reported By: </b>" & data.reportedby & "<br>
 <b>Report Group: </b>" & Concat(RptGrpDropDown.SelectedItems, Text(RptGrp) & " ")
 );

Office365Outlook.SendEmailV2(
 User().Email,
 "Incident Submitted - " & data.incident_num,
 "<b>Your incident has been submitted successfully</b>"
);


Reset(cbCustomer);
 Reset(cbEmployID);
 Reset(cbOwnerOp);
 ResetForm(NewIncidentForm);
 Navigate(NewIncidentSuccess, ScreenTransition.Cover)

 

 

Message 1 of 49
547 Views
0 Kudos
1 ACCEPTED SOLUTION

Accepted Solutions
RandyHayes
Super User III
Super User III
In response to thunter

โ€Ž09-18-2020 07:46 AM

Hello again @thunter 

Funny...I still had this formula up on my screen from a month ago when we went through it.

I believe the correction below is what you want (and why you are not seeing the email to the exec - because the closing parens for the ForAll were put in the wrong place.

This should be the correct version.

With({data: NewIncidentForm.LastSubmit},

   // SEND EMAIL TO SELECTED GROUPS
   ForAll(emaillist,
     Office365Outlook.SendEmailV2(EmailAddr,
        Coalesce(data.billto, data.name) & "- New Incident - " & data.incident_num,
        "<b>Incident Number: </b>" & data.incident_num & "<br>
         <b>Name: </b>" & data.name & "<br>
         <b>Incident Date: </b>" & data.inc_date & "<br>
         <b>Reported By: </b>" & data.reportedby & "<br>
         <b>Date Reported: </b>" & Today() & "<br>
         <b>Report Group: </b>" & Concat(RptGrpDropDown.SelectedItems, Text(RptGrp) & " ") & " 
         <br>
         <b>Trip #: </b>" & data.trip & "<br>
         <b>Tractor: </b>" & data.tractor & "<br>
         <b>Trailer: </b>" & data.trailer & "<br>
         <b>Bill To: </b>" & data.billto & " - " & BillToName.Text & "<br>
         <b>Consignee: </b>" & data.consignee & " - " & ConsigneeName.Text & "<br>
         <b>Shipper: </b>" & data.shipper & " - " & ShipperName.Text & "<br>
         <b>Location of Incident: </b>" & data.location & "<br>
         <b>Description of Incident: </b>" & data.description & "<br>
         <b>At Fault: </b>" & data.fault & "<br>
         <b>Preventable: </b>" & data.prevent & "<br>
         <b>Status: </b>" & data.status
    )
  );

   // SEND EMAL TO EXECUTIVES
   Office365Outlook.SendEmailV2(
      "xx@xx.com; xx@xx.com",data.name & "- New Incident - " & data.incident_num,
      "<b>Incident Date: </b>" & data.inc_date & "<br>
       <b>Incident Number: </b>" & data.incident_num & "<br>
       <b>Name: </b>" & data.name & "<br>
       <b>Date Reported: </b>" & Today() & "<br>
       <b>Trip #: </b>" & data.trip & "<br>
       <b>Tractor: </b>" & data.tractor & "<br>
       <b>Trailer: </b>" & data.trailer & "<br>
       <b>Bill To: </b>" & data.billto & " - " & BillToName.Text & "<br>
       <b>Consignee: </b>" & data.consignee & " - " & ConsigneeName.Text & "<br>
       <b>Shipper: </b>" & data.shipper & " - " & ShipperName.Text & "<br>
       <b>Location of Incident: </b>" & data.location & "<br>
       <b>Description of Incident: </b>" & data.description & "<br>
       <b>At Fault: </b>" & data.fault & "<br>
       <b>Preventable: </b>" & data.prevent & "<br>
       <b>Status: </b>" & data.status &"<br>
       <b>Reported By: </b>" & data.reportedby & "<br>
       <b>Report Group: </b>" & Concat(RptGrpDropDown.SelectedItems, Text(RptGrp) & " ")
    );

    Office365Outlook.SendEmailV2(
      User().Email,
      "Incident Submitted - " & data.incident_num,
      "<b>Your incident has been submitted successfully</b>"
    )
);

 Reset(cbCustomer);
 Reset(cbEmployID);
 Reset(cbOwnerOp);
 ResetForm(NewIncidentForm);
 Navigate(NewIncidentSuccess, ScreenTransition.Cover)

 

This will at least send to the execs and the user.  The emaillist is the next thing to look at.

What I don't seem to have any more is where we were getting emaillist from?  I thought that was a dropdown or combobox or something.

Please clarify again.

_____________________________________________________________________________________
Digging it? - Click on the Thumbs Up. Solved your problem? - Click on Accept as Solution. Others seeking the same answers will be happy you did.
Check out my PowerApps Videos too!

View solution in original post

Message 11 of 49
414 Views
48 REPLIES 48
mdevaney
Super User III
Super User III

โ€Ž09-18-2020 05:50 AM

@thunter 

I think you just forgot to close your WITH statement, that's all.  Here's my idea:

With({data: NewIncidentForm.LastSubmit},

 // SEND NOTICE TO ALL SELECTED GROUPS
 ForAll(emaillist,
 Office365Outlook.SendEmailV2(
 EmailAddr,
 Coalesce(data.billto, data.name) & "- New Incident - " & data.incident_num,
 "<b>Incident Number: </b>" & data.incident_num & "<br>
 <b>Name: </b>" & data.name & "<br>
 <b>Incident Date: </b>" & data.inc_date & "<br>
 <b>Reported By: </b>" & data.reportedby & "<br>
 <b>Date Reported: </b>" & Today() & "<br>
 <b>Report Group: </b>" & Concat(RptGrpDropDown.SelectedItems, Text(RptGrp) & " ") & "<br>
 <b>Trip #: </b>" & data.trip & "<br>
 <b>Tractor: </b>" & data.tractor & "<br>
 <b>Trailer: </b>" & data.trailer & "<br>
 <b>Bill To: </b>" & data.billto & " - " & BillToName.Text & "<br>
 <b>Consignee: </b>" & data.consignee & " - " & ConsigneeName.Text & "<br>
 <b>Shipper: </b>" & data.shipper & " - " & ShipperName.Text & "<br>
 <b>Location of Incident: </b>" & data.location & "<br>
 <b>Description of Incident: </b>" & data.description & "<br>
 <b>At Fault: </b>" & data.fault & "<br>
 <b>Preventable: </b>" & data.prevent & "<br>
 <b>Status: </b>" & data.status
 );

 // SEND NOTICE TO INTERNAL STAFF
 Office365Outlook.SendEmailV2(
 "xxxx@xxxx.com; xxxx@xxxx.com",
 data.name & "- New Incident - " & data.incident_num,
 "<b>Incident Date: </b>" & data.inc_date & "<br>
 <b>Incident Number: </b>" & data.incident_num & "<br>
 <b>Name: </b>" & data.name & "<br>
 <b>Date Reported: </b>" & Today() & "<br>
 <b>Trip #: </b>" & data.trip & "<br>
 <b>Tractor: </b>" & data.tractor & "<br>
 <b>Trailer: </b>" & data.trailer & "<br>
 <b>Bill To: </b>" & data.billto & " - " & BillToName.Text & "<br>
 <b>Consignee: </b>" & data.consignee & " - " & ConsigneeName.Text & "<br>
 <b>Shipper: </b>" & data.shipper & " - " & ShipperName.Text & "<br>
 <b>Location of Incident: </b>" & data.location & "<br>
 <b>Description of Incident: </b>" & data.description & "<br>
 <b>At Fault: </b>" & data.fault & "<br>
 <b>Preventable: </b>" & data.prevent & "<br>
 <b>Status: </b>" & data.status &"<br>
 <b>Reported By: </b>" & data.reportedby & "<br>
 <b>Report Group: </b>" & Concat(RptGrpDropDown.SelectedItems, Text(RptGrp) & " ")
 );

Office365Outlook.SendEmailV2(
 User().Email,
 "Incident Submitted - " & data.incident_num,
 "<b>Your incident has been submitted successfully</b>"
);

) // I added this bracket

Reset(cbCustomer);
 Reset(cbEmployID);
 Reset(cbOwnerOp);
 ResetForm(NewIncidentForm);
 Navigate(NewIncidentSuccess, ScreenTransition.Cover)

 

---
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."

Message 2 of 49
388 Views
thunter
Post Prodigy
Post Prodigy
In response to mdevaney

โ€Ž09-18-2020 05:59 AM

@mdevaney 

 

Thanks for the quick reply! When I added your bracket, I still have the same error plus a new error. See below. Thank you.

123.png1234.png

Message 3 of 49
380 Views
0 Kudos
mdevaney
Super User III
Super User III
In response to thunter

โ€Ž09-18-2020 06:01 AM

@thunter 

Good lord, haha.  I forgot the semi-colon.

 

ith({data: NewIncidentForm.LastSubmit},

 // SEND NOTICE TO ALL SELECTED GROUPS
 ForAll(emaillist,
 Office365Outlook.SendEmailV2(
 EmailAddr,
 Coalesce(data.billto, data.name) & "- New Incident - " & data.incident_num,
 "<b>Incident Number: </b>" & data.incident_num & "<br>
 <b>Name: </b>" & data.name & "<br>
 <b>Incident Date: </b>" & data.inc_date & "<br>
 <b>Reported By: </b>" & data.reportedby & "<br>
 <b>Date Reported: </b>" & Today() & "<br>
 <b>Report Group: </b>" & Concat(RptGrpDropDown.SelectedItems, Text(RptGrp) & " ") & "<br>
 <b>Trip #: </b>" & data.trip & "<br>
 <b>Tractor: </b>" & data.tractor & "<br>
 <b>Trailer: </b>" & data.trailer & "<br>
 <b>Bill To: </b>" & data.billto & " - " & BillToName.Text & "<br>
 <b>Consignee: </b>" & data.consignee & " - " & ConsigneeName.Text & "<br>
 <b>Shipper: </b>" & data.shipper & " - " & ShipperName.Text & "<br>
 <b>Location of Incident: </b>" & data.location & "<br>
 <b>Description of Incident: </b>" & data.description & "<br>
 <b>At Fault: </b>" & data.fault & "<br>
 <b>Preventable: </b>" & data.prevent & "<br>
 <b>Status: </b>" & data.status
 );

 // SEND NOTICE TO INTERNAL STAFF
 Office365Outlook.SendEmailV2(
 "xxxx@xxxx.com; xxxx@xxxx.com",
 data.name & "- New Incident - " & data.incident_num,
 "<b>Incident Date: </b>" & data.inc_date & "<br>
 <b>Incident Number: </b>" & data.incident_num & "<br>
 <b>Name: </b>" & data.name & "<br>
 <b>Date Reported: </b>" & Today() & "<br>
 <b>Trip #: </b>" & data.trip & "<br>
 <b>Tractor: </b>" & data.tractor & "<br>
 <b>Trailer: </b>" & data.trailer & "<br>
 <b>Bill To: </b>" & data.billto & " - " & BillToName.Text & "<br>
 <b>Consignee: </b>" & data.consignee & " - " & ConsigneeName.Text & "<br>
 <b>Shipper: </b>" & data.shipper & " - " & ShipperName.Text & "<br>
 <b>Location of Incident: </b>" & data.location & "<br>
 <b>Description of Incident: </b>" & data.description & "<br>
 <b>At Fault: </b>" & data.fault & "<br>
 <b>Preventable: </b>" & data.prevent & "<br>
 <b>Status: </b>" & data.status &"<br>
 <b>Reported By: </b>" & data.reportedby & "<br>
 <b>Report Group: </b>" & Concat(RptGrpDropDown.SelectedItems, Text(RptGrp) & " ")
 );

Office365Outlook.SendEmailV2(
 User().Email,
 "Incident Submitted - " & data.incident_num,
 "<b>Your incident has been submitted successfully</b>"
)

); // I added this bracket and a colon

Reset(cbCustomer);
Reset(cbEmployID);
Reset(cbOwnerOp);
ResetForm(NewIncidentForm);
Navigate(NewIncidentSuccess, ScreenTransition.Cover);

 

---
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."

Message 4 of 49
370 Views
thunter
Post Prodigy
Post Prodigy
In response to mdevaney

โ€Ž09-18-2020 06:05 AM

@mdevaney 

 

Ha! That cleared up the first error, but I still have the original error. This is confusing me, as these formulas are usually pretty easy and work well, not sure what I did wrong.

12.png

Message 5 of 49
368 Views
0 Kudos
mdevaney
Super User III
Super User III
In response to thunter

โ€Ž09-18-2020 06:31 AM

@thunter 
Maybe two brackets are needed because there is also a FORALL loop I missed earlier

 

With({data: NewIncidentForm.LastSubmit},

 // SEND NOTICE TO ALL SELECTED GROUPS
 ForAll(emaillist,
 Office365Outlook.SendEmailV2(
 EmailAddr,
 Coalesce(data.billto, data.name) & "- New Incident - " & data.incident_num,
 "<b>Incident Number: </b>" & data.incident_num & "<br>
 <b>Name: </b>" & data.name & "<br>
 <b>Incident Date: </b>" & data.inc_date & "<br>
 <b>Reported By: </b>" & data.reportedby & "<br>
 <b>Date Reported: </b>" & Today() & "<br>
 <b>Report Group: </b>" & Concat(RptGrpDropDown.SelectedItems, Text(RptGrp) & " ") & "<br>
 <b>Trip #: </b>" & data.trip & "<br>
 <b>Tractor: </b>" & data.tractor & "<br>
 <b>Trailer: </b>" & data.trailer & "<br>
 <b>Bill To: </b>" & data.billto & " - " & BillToName.Text & "<br>
 <b>Consignee: </b>" & data.consignee & " - " & ConsigneeName.Text & "<br>
 <b>Shipper: </b>" & data.shipper & " - " & ShipperName.Text & "<br>
 <b>Location of Incident: </b>" & data.location & "<br>
 <b>Description of Incident: </b>" & data.description & "<br>
 <b>At Fault: </b>" & data.fault & "<br>
 <b>Preventable: </b>" & data.prevent & "<br>
 <b>Status: </b>" & data.status
 );

 // SEND NOTICE TO INTERNAL STAFF
 Office365Outlook.SendEmailV2(
 "xxxx@xxxx.com; xxxx@xxxx.com",
 data.name & "- New Incident - " & data.incident_num,
 "<b>Incident Date: </b>" & data.inc_date & "<br>
 <b>Incident Number: </b>" & data.incident_num & "<br>
 <b>Name: </b>" & data.name & "<br>
 <b>Date Reported: </b>" & Today() & "<br>
 <b>Trip #: </b>" & data.trip & "<br>
 <b>Tractor: </b>" & data.tractor & "<br>
 <b>Trailer: </b>" & data.trailer & "<br>
 <b>Bill To: </b>" & data.billto & " - " & BillToName.Text & "<br>
 <b>Consignee: </b>" & data.consignee & " - " & ConsigneeName.Text & "<br>
 <b>Shipper: </b>" & data.shipper & " - " & ShipperName.Text & "<br>
 <b>Location of Incident: </b>" & data.location & "<br>
 <b>Description of Incident: </b>" & data.description & "<br>
 <b>At Fault: </b>" & data.fault & "<br>
 <b>Preventable: </b>" & data.prevent & "<br>
 <b>Status: </b>" & data.status &"<br>
 <b>Reported By: </b>" & data.reportedby & "<br>
 <b>Report Group: </b>" & Concat(RptGrpDropDown.SelectedItems, Text(RptGrp) & " ")
 );

Office365Outlook.SendEmailV2(
 User().Email,
 "Incident Submitted - " & data.incident_num,
 "<b>Your incident has been submitted successfully</b>"
)

)); // I added two brackets and a colon

Reset(cbCustomer);
Reset(cbEmployID);
Reset(cbOwnerOp);
ResetForm(NewIncidentForm);
Navigate(NewIncidentSuccess, ScreenTransition.Cover);

 

---
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."

Message 6 of 49
366 Views
carfup
Helper II
Helper II

โ€Ž09-18-2020 06:38 AM

Hi,
You're missing two ")" to close the ForAll and With functions.
Clรฉment

Message 7 of 49
364 Views
mdevaney
Super User III
Super User III
In response to carfup

โ€Ž09-18-2020 06:40 AM

@carfup 

Yep, agreed.  I finally came to that conclusion above after I placed it in the code editor. Thanks for confirming ๐Ÿ™‚

Message 8 of 49
353 Views
thunter
Post Prodigy
Post Prodigy
In response to mdevaney

โ€Ž09-18-2020 06:43 AM

@mdevaney 

@carfup 

 

That extra bracket took care of all the errors. However, it is not emailing now. It seems that it is not collecting the email address for the emaillist, which I use in the formula to email multiple emails. Although not entirely sure because it doesn't email to the executives either which is the 2nd email formula.

 

With({data: NewIncidentForm.LastSubmit},

 // SEND EMAIL TO SELECTED GROUPS
 ForAll(emaillist,Office365Outlook.SendEmailV2(EmailAddr,
 Coalesce(data.billto, data.name) & "- New Incident - " & data.incident_num,
 "<b>Incident Number: </b>" & data.incident_num & "<br>
 <b>Name: </b>" & data.name & "<br>
 <b>Incident Date: </b>" & data.inc_date & "<br>
 <b>Reported By: </b>" & data.reportedby & "<br>
 <b>Date Reported: </b>" & Today() & "<br>
 <b>Report Group: </b>" & Concat(RptGrpDropDown.SelectedItems, Text(RptGrp) & " ") & "<br>
 <b>Trip #: </b>" & data.trip & "<br>
 <b>Tractor: </b>" & data.tractor & "<br>
 <b>Trailer: </b>" & data.trailer & "<br>
 <b>Bill To: </b>" & data.billto & " - " & BillToName.Text & "<br>
 <b>Consignee: </b>" & data.consignee & " - " & ConsigneeName.Text & "<br>
 <b>Shipper: </b>" & data.shipper & " - " & ShipperName.Text & "<br>
 <b>Location of Incident: </b>" & data.location & "<br>
 <b>Description of Incident: </b>" & data.description & "<br>
 <b>At Fault: </b>" & data.fault & "<br>
 <b>Preventable: </b>" & data.prevent & "<br>
 <b>Status: </b>" & data.status
 );

 // SEND EMAL TO EXECUTIVES
 Office365Outlook.SendEmailV2("xx@xx.com; xx@xx.com",data.name & "- New Incident - " & data.incident_num,
 "<b>Incident Date: </b>" & data.inc_date & "<br>
 <b>Incident Number: </b>" & data.incident_num & "<br>
 <b>Name: </b>" & data.name & "<br>
 <b>Date Reported: </b>" & Today() & "<br>
 <b>Trip #: </b>" & data.trip & "<br>
 <b>Tractor: </b>" & data.tractor & "<br>
 <b>Trailer: </b>" & data.trailer & "<br>
 <b>Bill To: </b>" & data.billto & " - " & BillToName.Text & "<br>
 <b>Consignee: </b>" & data.consignee & " - " & ConsigneeName.Text & "<br>
 <b>Shipper: </b>" & data.shipper & " - " & ShipperName.Text & "<br>
 <b>Location of Incident: </b>" & data.location & "<br>
 <b>Description of Incident: </b>" & data.description & "<br>
 <b>At Fault: </b>" & data.fault & "<br>
 <b>Preventable: </b>" & data.prevent & "<br>
 <b>Status: </b>" & data.status &"<br>
 <b>Reported By: </b>" & data.reportedby & "<br>
 <b>Report Group: </b>" & Concat(RptGrpDropDown.SelectedItems, Text(RptGrp) & " ")
 );

Office365Outlook.SendEmailV2(
 User().Email,
 "Incident Submitted - " & data.incident_num,
 "<b>Your incident has been submitted successfully</b>"
);

)); // I added this bracket

 Reset(cbCustomer);
 Reset(cbEmployID);
 Reset(cbOwnerOp);
 ResetForm(NewIncidentForm);
 Navigate(NewIncidentSuccess, ScreenTransition.Cover)

 

 

Message 9 of 49
347 Views
0 Kudos
carfup
Helper II
Helper II
In response to thunter

โ€Ž09-18-2020 06:52 AM

Correct me if i'm wrong, but i feel like your ForAll loop is only the emailing to groups ? 
If so the closing of that function is not at the correct place and should look like : 

 

With({data: NewIncidentForm.LastSubmit},

 // SEND EMAIL TO SELECTED GROUPS
 ForAll(emaillist,Office365Outlook.SendEmailV2(EmailAddr,
 Coalesce(data.billto, data.name) & "- New Incident - " & data.incident_num,
 "<b>Incident Number: </b>" & data.incident_num & "<br>
 <b>Name: </b>" & data.name & "<br>
 <b>Incident Date: </b>" & data.inc_date & "<br>
 <b>Reported By: </b>" & data.reportedby & "<br>
 <b>Date Reported: </b>" & Today() & "<br>
 <b>Report Group: </b>" & Concat(RptGrpDropDown.SelectedItems, Text(RptGrp) & " ") & "<br>
 <b>Trip #: </b>" & data.trip & "<br>
 <b>Tractor: </b>" & data.tractor & "<br>
 <b>Trailer: </b>" & data.trailer & "<br>
 <b>Bill To: </b>" & data.billto & " - " & BillToName.Text & "<br>
 <b>Consignee: </b>" & data.consignee & " - " & ConsigneeName.Text & "<br>
 <b>Shipper: </b>" & data.shipper & " - " & ShipperName.Text & "<br>
 <b>Location of Incident: </b>" & data.location & "<br>
 <b>Description of Incident: </b>" & data.description & "<br>
 <b>At Fault: </b>" & data.fault & "<br>
 <b>Preventable: </b>" & data.prevent & "<br>
 <b>Status: </b>" & data.status
 );
 );

 // SEND EMAL TO EXECUTIVES
 Office365Outlook.SendEmailV2("xx@xx.com; xx@xx.com",data.name & "- New Incident - " & data.incident_num,
 "<b>Incident Date: </b>" & data.inc_date & "<br>
 <b>Incident Number: </b>" & data.incident_num & "<br>
 <b>Name: </b>" & data.name & "<br>
 <b>Date Reported: </b>" & Today() & "<br>
 <b>Trip #: </b>" & data.trip & "<br>
 <b>Tractor: </b>" & data.tractor & "<br>
 <b>Trailer: </b>" & data.trailer & "<br>
 <b>Bill To: </b>" & data.billto & " - " & BillToName.Text & "<br>
 <b>Consignee: </b>" & data.consignee & " - " & ConsigneeName.Text & "<br>
 <b>Shipper: </b>" & data.shipper & " - " & ShipperName.Text & "<br>
 <b>Location of Incident: </b>" & data.location & "<br>
 <b>Description of Incident: </b>" & data.description & "<br>
 <b>At Fault: </b>" & data.fault & "<br>
 <b>Preventable: </b>" & data.prevent & "<br>
 <b>Status: </b>" & data.status &"<br>
 <b>Reported By: </b>" & data.reportedby & "<br>
 <b>Report Group: </b>" & Concat(RptGrpDropDown.SelectedItems, Text(RptGrp) & " ")
 );

Office365Outlook.SendEmailV2(
 User().Email,
 "Incident Submitted - " & data.incident_num,
 "<b>Your incident has been submitted successfully</b>"
);

); // I added this bracket

 Reset(cbCustomer);
 Reset(cbEmployID);
 Reset(cbOwnerOp);
 ResetForm(NewIncidentForm);
 Navigate(NewIncidentSuccess, ScreenTransition.Cover)

 

Message 10 of 49
313 Views
0 Kudos

Helpful resources

Announcements
New Badges

New Solution Badges!

Check out our new profile badges recognizing authored solutions!

New Power Super Users

Congratulations!

We are excited to announce the Power Apps Super Users!

Power Apps Community Call

Power Apps Community Call: February

Did you miss the call? Check out the Power Apps Community Call here.

Microsoft Ignite

Microsoft Ignite

Join digitally, March 2โ€“4, 2021 to explore new tech that's ready to implement. Experience the keynote in mixed reality through AltspaceVR!

View All
Top Solution Authors
View All
Top Kudoed Authors
View All
Users online (57,024)