web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id : qD1GcWBDJ3g74L4wgfMV2Z
Power Apps - Building Power Apps
Unanswered

Enable using both HTML & functions from sharepoint multiline text

Like (0) ShareShare
ReportReport
Posted on 29 Nov 2023 19:56:06 by 26

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

 

Impugno_1-1701287668841.png

 

Categories:
  • Impugno Profile Picture
    26 on 29 Nov 2023 at 21:21:37
    Re: Enable using both HTML & functions from sharepoint multiline text

    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.

  • mmbr1606 Profile Picture
    13,494 Super User 2025 Season 2 on 29 Nov 2023 at 20:25:07
    Re: Enable using both HTML & functions from sharepoint multiline text

    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

  • Impugno Profile Picture
    26 on 29 Nov 2023 at 20:18:54
    Re: Enable using both HTML & functions from sharepoint multiline text

    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.

  • mmbr1606 Profile Picture
    13,494 Super User 2025 Season 2 on 29 Nov 2023 at 20:12:08
    Re: Enable using both HTML & functions from sharepoint multiline text

    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

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Telen Wang – Community Spotlight

We are honored to recognize Telen Wang as our August 2025 Community…

Announcing our 2025 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for…

Congratulations to the July Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 637 Most Valuable Professional

#2
stampcoin Profile Picture

stampcoin 570 Super User 2025 Season 2

#3
Power Apps 1919 Profile Picture

Power Apps 1919 473

Loading complete