
Hi,
I'm still struggling my first app and would appreciate some assistance,
I have the following button formula creating a new form:
If(IsBlank(DataCardValue3)|| IsBlank(DataCardValue7) || IsBlank(DataCardValue10) || IsBlank(DataCardValue5) || IsBlank(DataCardValue1) || IsBlank(DataCardValue8) || IsBlank(DataCardValue4) || IsBlank(DataCardValue14) || IsBlank(Dropdown5),UpdateContext({msg_visible:true}),SubmitForm([@NewTicketForm]) & Office365Outlook.SendEmailV2("xxx@hotmail.com","New ticket was created, ID: "& DataCardValue7,"Dear Manager, <br><br> A new ticket was assigned to your department, Please respond and update the ticket status within 48 hours, <br><br> Ticket ID: "& DataCardValue7 & "<br><br> Owner: "&Value13 & "<br><br> Chassis number: "& DataCardValue5 & "<br><br> Customer Name: "& DataCardValue3 & "<br><br> Contact Number: "& DataCardValue4 & "<br><br> Description:<br>"& DataCardValue1 & "<br><br> For more information, please contact CRM department.<br><br>",{Cc:"xxx@gmail.com"});UpdateContext({New:Patch(Tickets,LookUp(Tickets,ID=Text(Max(Tickets,ID))))}))
When submitting the form, the record is being added to the data normally but missing information being sent by email:
"Dear Manager,
A new ticket was assigned to your department, Please respond and update the ticket status within 48 hours,
Ticket ID: 98
Owner: Available
Chassis number: (Missing)
Customer Name: (Missing)
Contact Number: (Missing)
Description: (Missing)
For more information, please contact CRM department."
please note while testing before publishing I get all information correctly buy email, only these values are missing after publishing the app.
can anybody suggest something, I need to deliver the app in 2 days.
thank you