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
Highlighted
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
107 Views
0 Kudos
Reply
1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
RandyHayes
Super User III
Super User III

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

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

View solution in original post

Message 11 of 49
56 Views
Reply
48 REPLIES 48
Highlighted
mdevaney
Super User III
Super User III

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

‎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
102 Views
Reply
Highlighted
thunter
Post Prodigy
Post Prodigy

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

‎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
94 Views
0 Kudos
Reply
Highlighted
mdevaney
Super User III
Super User III

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

‎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
84 Views
Reply
Highlighted
thunter
Post Prodigy
Post Prodigy

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

‎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
82 Views
0 Kudos
Reply
Highlighted
mdevaney
Super User III
Super User III

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

‎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
80 Views
Reply
Highlighted
carfup
Helper II
Helper II

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

‎09-18-2020 06:38 AM

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

Message 7 of 49
78 Views
Reply
Highlighted
mdevaney
Super User III
Super User III

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

‎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
67 Views
Reply
Highlighted
thunter
Post Prodigy
Post Prodigy

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

‎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
61 Views
0 Kudos
Reply
Highlighted
carfup
Helper II
Helper II

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

‎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
26 Views
0 Kudos
Reply

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Find your favorite faces from the community presenting at the Power Platform Community Conference!

Watch Now

Experience what’s next for Power Apps

See the latest Power Apps innovations, updates, and demos from the Microsoft Business Applications Launch Event.

Power Platform ISV Studio

Power Platform ISV Studio

ISV Studio is designed to become the go-to Power Platform destination for ISV’s to monitor & manage published applications.

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

View All
Top Solution Authors
View All
Top Kudoed Authors
View All
Users online (5,767)