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

Announcements

Welcome to the Power Platform Communities
News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Adding Fields to HTML ...
Power Apps
Answered

Adding Fields to HTML Text in Power Apps

(0) ShareShare
ReportReport
Posted on by DP487 26

This is what I am trying to do in the link below:

https://zebrabi.com/writeback-comments-power-bi/#comment-85520

 

I am stuck on "Working in Power App Studio" section. I am trying to connect Excel fields from Power BI to Power App.

I have a within a Screen, I have a Gallery & html text within, attempting to pull a field (from Power BI that I placed into the Power App Visual before sending it to Power App online.) by using "ThisItem.Comments".

It is not recognizing "Comments". Only options are "IsSelected" after the period.

 

1. I have ensure that the ‘Items’ property of the gallery is populated with ‘PowerBIIntegration.Data’ (without the single quotes around it).

2. I have turned off the Explicit Column Selection.

3. I went to add data and selected power BI. 

 

I am not sure why it is still not pulling the fields from Power BI. I would like to pull fields from my dataflow in power BI as well as the excel for comments, if possible.

Categories:
Building Power Apps
I have the same question (0)
  • v-yueyun-msft Profile Picture
    v-yueyun-msft Microsoft Employee on at

    Hi , @DP487 

    According to your description, you are using the Power App visual in Power BI. And you have put the â€˜PowerBIIntegration.Data’  in the Gallery -items , but it have not recognizing "Comments" field in your side.

    You need to check :
    (1)If you have put the Comments field in the power app visual's fields.2

    vyueyunmsft_0-1709255424264.png

    (2) You need to check if your â€˜PowerBIIntegration.Data’  get the data from Power Apps in your Power Apps.

    You can try to move your mouse to this whole code in your Gallert -items:

    vyueyunmsft_2-1709255696574.png

    You need to check if the "Conmments" column exist here!

     

    If there is not data , you can try to re-go into the Power Apps from Power BI .

    In Power BI report edit mode --> click "..." ---> click "Edit" of the power app visual and wait for some minutes to open the Power Apps:

    vyueyunmsft_0-1709257408959.png

     

     

    Best Regards,

    Yueyun Zhang

     

     

     



  • DP487 Profile Picture
    DP487 26 on at

    In #2, what is the formula? Sort(PowerIntegration.Data.ID)? If so, that equation does not work

    Capture.PNG
  • v-yueyun-msft Profile Picture
    v-yueyun-msft Microsoft Employee on at

    Hi , @DP487 

    You can just use the PowerIntegration.Data formula.

     

    Best Regards,

    Yueyun Zhang

     

  • DP487 Profile Picture
    DP487 26 on at

    In the picture, that formula alone gives me an error.

    DP487_0-1709258918022.png

     

  • v-yueyun-msft Profile Picture
    v-yueyun-msft Microsoft Employee on at

    Hi , @DP487 

    Sorry , i copy wrong, please to use PowerIntegration.Data in your side.

     

    Best Regards,

    Yueyun Zhang

     

  • DP487 Profile Picture
    DP487 26 on at

    So it seems there is no data. 

    DP487_4-1709259416602.png

     

    Am I doing something wrong with sending the PBI data to the power app? I followed these instructions 

    DP487_3-1709259385700.png

     

     

     

  • v-yueyun-msft Profile Picture
    v-yueyun-msft Microsoft Employee on at

    Hi , @DP487 

    So you need to check you put the wrong field in your Power BI.

    In Power Bi , it has a context relationship , you need to check if you create the right relationship in your Powerbi first.

    vyueyunmsft_0-1709259586510.png

    You can try to move this field to a table to show if there it can get the data:

    vyueyunmsft_1-1709259643174.png

     

    If it can get the Table , you can try to re-create your Power App visual and your app in your side.

     

    Best Regards,

    Yueyun Zhang

  • DP487 Profile Picture
    DP487 26 on at

    It was because I was using the app instead of the published online version

  • Verified answer
    v-yueyun-msft Profile Picture
    v-yueyun-msft Microsoft Employee on at

    Hi , @DP487 

    I test it in my side , in Power Bi desktop i also get the empty table when i open the power app..

    vyueyunmsft_0-1709260325907.png

     

    This is the reason it will not  recognizing "Comments" in your side. Can you try to publish your report to service and create the Power App visual in Power BI Service to try it?

     

    If this reply can help you , you can click mark this reply as solution (Accept solution) which can help more people, thanks in advance! 

     

    Best Regards,

    Yueyun Zhang

     

  • DP487 Profile Picture
    DP487 26 on at

    New question: When I click "ALT" everything disappears during the "Selecting the fields for your comment form" process in the below link.

    https://zebrabi.com/writeback-comments-power-bi/#comment-85520

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

News and Announcements

Welcome to the Power Platform Communities

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Congratulations to the April Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
Vish WR Profile Picture

Vish WR 1,055

#2
Valantis Profile Picture

Valantis 666

#2
11manish Profile Picture

11manish 666

Last 30 days Overall leaderboard

Featured topics

Auto-Populate field Power Pages
Gallery Tabs - Show or Hide Tabs based on Field Value
How to patch multiple records at once
Enable Copilot for end users in model-driven apps
Question for everyone : How are you using Create Text GPT in AI Builder?
Community content - sample components, blogs etc. - Link to this page (http://aka.ms/PCFdemos)
Welcome to the Power Apps forum!

Product updates

Microsoft Power Platform Community release plans