I have a multi-language canvas app which combines text & functions into the same multi-line text from sharepoint. How do I escape the HTML text to allow the function to process in a HTML Text control? If I use the string in the control it works fine. Thanks!
"<H2>Hello "&User().FullName&" ,</H2>You have the below trade to cash controls to review and confirm. The due date to have the controls submitted for review is "&DueDate_pck.SelectedDate &".</br></br> If you have any questions please contact your local Internal Control group."
That does not work either. We need the character which escapes HTML within the HTML Control. it should be CHAR(34) but i could not get that to work either.
lets try another option
"<h2>Hello " & User().FullName & ",</h2>You have the below trade to cash controls to review and confirm. The due date to have the controls submitted for review is " & Text(DueDate_pck.SelectedDate, "dd/mm/yyyy") & ".<br><br> If you have any questions please contact your local Internal Control group."
Let me know if my answer helped solving your issue.
If it did please accept as solution and give it a thumbs up so we can help others in the community.
Greetings
Thank you but that did not make a difference.
It looks like you added spaces around the ampersands but if there was another change I missed it. I did copy and paste your solution in though in case it was something i missed.
hello @Impugno
try the following please
"<H2>Hello " & User().FullName & ",</H2>You have the below trade to cash controls to review and confirm. The due date to have the controls submitted for review is " & Text(DueDate_pck.SelectedDate, "dd/mm/yyyy") & ".</br></br> If you have any questions please contact your local Internal Control group."
Let me know if my answer helped solving your issue.
If it did please accept as solution and give it a thumbs up so we can help others in the community.
Greetings
WarrenBelz
637
Most Valuable Professional
stampcoin
570
Super User 2025 Season 2
Power Apps 1919
473