Solved: HTML text box, data from SharePoint and variables

Hi,

This one is driving me around the twist and hoping there is something simple I have missed.

I have a global variable I am using in PowerApps (Var1) with a text value of “apple”.

If I put the following directly into an HTML text box in PowerApps "Test " & Var1 & " then testing again.", I get …. Test apple then testing again.

All great – the variable is replaced with the text.

However if I put "Test " & Var1 & " then testing again." and put it in to a SharePoint Multiple lines of text column and draw it into the same HTML text box I get …… "Test " & Var1 & " then testing again."

I have tried

Varying the text in the SharePoint column
- "Test " & Var1 & " then testing again."
- Test " & Var1 & " then testing again.
- Test & Var1 & then testing again. – which was never going to work
Varying the format of the SharePoint Multiple lines of text column
- Plain text
- Rich text
- Enhanced rich text
I have tried different ways of getting the information in from SharePoint into PowerApps
- Lookup
- Collection
- Create another variable
- Coming in the Rich text editor
- Coming in as plain text

Would anyone have an idea or a work around of how to bring the text in from SharePoint (where the variable name is included in the text) and, still make it dynamic so that the variable value is replaced with the variable’s text value (like it would be if it was typed directly into an HTML text box).

The reason I am using a Global variable is that it is used many times throughout the app.

Thanks in advance.

Categories:

General Questions