Unanswered

Populating HTML in PowerApps from template in SharePoint list

(0) Share

Report

Posted on by BellatrixUAM

Hello all,

I'm trying to create an app where users can see announcements. The announcements are sent to us in HTML format, so I created a list in SharePoint with Subject and Body columns. The Body column is formatted as Enhanced Rich Text, so I pasted the HTML code in here.

In PowerApps, I created Gallery1 that shows the Subject and Created date for the announcement, and Gallery2 with an HTML Text box with Gallery1.Selected.Body in the Text Property.

The idea is for PowerApps to "read" the code on Gallery2 depending on what announcement you select in Gallery1, and therefore, to display the announcement as you may see it in Outlook, for example. But right now, is just displaying the HTML text in the SharePoint list, and is not reading the code.

HTML code in Body column in SharePoint list:

<img src="https://xxxxx.xxxx-xxxx.com/:i:/r/sites/XXXXxxxxxxx/communications/Shared%20Documents/Images%20for%20Templates/Test1/UAM%20logo.png?csf=1&web=1&e=GewLUc" alt="" width="288" height="160" />
 
Congratulations! This is a test.
 
Announcements are sent in HTML format by our design company and therefore, the code should be read by PowerApps from a SharePoint list as its main source.
 
Thank you and good luck!

SharePoint List:

How it looks in PowerApps right now:

How it should look Gallery2 in PowerApps:

Thank you so much for all your help!

Categories:

Building Power Apps

I have the same question (0)

All responses (12)

Answers (0)

Sort by

WarrenBelz 156,417 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @BellatrixUAM ,

You need single quotes for HTML code

"<img src='https://xxxxx.xxxx-xxxx.com/:i:/r/sites/XXXXxxxxxxx/communications/Shared%20Documents/Images%20for%2...' alt='' width='288' height='160' />   Congratulations! This is a test.   Announcements are sent in HTML format by our design company and therefore, the code should be read by PowerApps from a SharePoint list as its main source.   Thank you and good luck!"

I do not have your image, but the rest works fine.

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Was this reply helpful? Yes No
BellatrixUAM 19 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @WarrenBelz
I added the single quotes to the HTML code in the Body column of the SharePoint List and still is not working.

This is how is being displayed in Power Apps:

Was this reply helpful? Yes No
WarrenBelz 156,417 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @BellatrixUAM ,

Can you please post that code in Text - I can still see a heap of double quotes in there.

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Was this reply helpful? Yes No
BellatrixUAM 19 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @WarrenBelz

The code I used and added in the Body column of SharePoint list is:

'Congratulations! This is a test.
 
Announcements are sent in HTML format by our design company and therefore, the code should be read by PowerApps from a SharePoint list as its main source.
 
Thank you and good luck!'

I took the picture off because I do not want to over complicate this.
This is how it looks in SharePoint:

And this is how it looks in PowerApps:
Thank you!

Was this reply helpful? Yes No
WarrenBelz 156,417 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @BellatrixUAM ,

You need the double quotes enclosing it to signify it is text and single inside

"Congratulations! This is a test.   Announcements are sent in HTML format by our design company and therefore, the code should be read by PowerApps from a SharePoint list as its main source.   Thank you and good luck!"

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Was this reply helpful? Yes No
BellatrixUAM 19 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @WarrenBelz
I'm sorry but I'm not get it. I tried with double quotes first by putting them in the code in the sharepoint column, still it was not read in the HTML in PowerApps. Then, you told me it should be single quotes, so I changed it and put them in the code in the SharePoint list, still as per my previous screenshots, PowerApps is not recognizing it.
So now... should I put double quotes again? Should I put them in the SharePoint list column directly like "Congratulations! This is a test.
 ..."
Or should I put the double quotes directly in PowerApps like "&Gallery2.Selected.Body&"
I appreciate your clarification.

Was this reply helpful? Yes No
WarrenBelz 156,417 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
@BellatrixUAM ,

Can you please look at the code I posted both times. The whole code needs to be enclosed in double quotes (at the start and end only) as it is a text string. Howeveranywhere double quotes would normally be used inside the HTML code (around the Color in this case)

Thank you and good luck!

needs to be single quotes.

You also had a number of others in your original post

 <img src='https://xxxxx.xxxxxxxx.com/:i:/r/sites/XXXXxxxxxxx/communications/Shared%20Documents/Images%20for%2...' alt='' width='288' height='160' />  

If you simply paste the code I provided in the first one, it should work for you.

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Was this reply helpful? Yes No
BellatrixUAM 19 on at

Like
a
(0)

Report
Copy link

Link copied!

Hello @WarrenBelz
I did that, and still is not working:

I changed the text code to:
"Congratulations! This is a test.
 
Announcements are sent in HTML format by our design company and therefore, the code should be read by PowerApps from a SharePoint list as its main source.
 
Thank you and good luck!"
🤔

Was this reply helpful? Yes No
WarrenBelz 156,417 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @BellatrixUAM ,

I assume you are putting this is a HTML Text box - please see below

Here is is below in HTML in the post itself

Congratulations! This is a test

Announcements are sent in HTML format by our design company and therefore, the code should be read by PowerApps from a SharePoint list as its main source

Thank you and good luck!

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Was this reply helpful? Yes No
BellatrixUAM 19 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @WarrenBelz
Yes, is a HTML text box inside a gallery in PowerApps:

The column in SharePoint (from where the code should be taken) is in enhanced rich text format:

Thank you.

Was this reply helpful? Yes No