cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
oappdev
Super User
Super User

Auto populate form fields into HtmlText control

Good day, Power Apps Community,

 

Hope someone could help me, l' m struck trying to accomplish the following scenario for my department.

* Already have the data store (Excel sheet) in OneDrive, later would move into a SQL Database.

 

Items Property: 

 

Filter(
    Table1,
    cmbCenter.Selected.Result = BOX32_FACILITYNAME,
    cmbEntity.Selected.Result = BOX33_BILLINGPROVIDERNAME,
    cmbRenderingProvider.Selected.Result = PROVIDER_NAME,
    cmbCPTAdminCode.Selected.Result = BOX24D_PROCEDURE
)

 

 

 

1. Once Filter. It will populate the filter data in the gallery. ( That is working )

  • Combo box control.
  • Gallery control.

Capture1.PNG

 

Want it to auto populate all patients that is under "Provider Name", So then it could be generate as a PDF.

  • Using Html text control - with some html code.
    • I have it working where it only bring in the first patient Information.

 

<tr>
<th>Provider Name</th>
<th>National Provider Identifier(NPI)</th>
<th>Date of Service MM/DD/YYYY(One date per roster)</th>

</tr>
<tr>
<td>" & DataCardValue1 & "</td>
<td>" & DataCardValue1 & "</td>
<td>" & DataCardValue1 & "</td>
</tr>

 

 

How can I loop in the data?

 

Capture2.PNG

 

 

Capture.PNG

 

Thank you in advance, much appreciated. Please, let me know if I explain myself clearly.

1 ACCEPTED SOLUTION

Accepted Solutions
RandyHayes
Super User
Super User

@oappdev 

You mention a Gallery and a Combobox, but yet you are mentioning in your Formula for the Html "DataCardValue1".  This implies a Form...

Are you trying to iterate over the values of a Form or a Gallery?

 

I am not sure of your connection because of the above statement, but here is some information that may help you get moving past where you are.

 

If you are trying to turn a Gallery into an Html Table, then this is what you need to do:

"<table>
    <tr>
        <th>Provider Name</th>
        <th>National Provider Identifier(NPI)</th>
        <th>Date of Service MM/DD/YYYY(One date per roster)</th>
    </tr>" &
Concat(yourGallery.AllItems, 
    "<tr>
       <td>" & someColumnOrControlPropertyInYourGallery & "</td>
       <td>" & someColumnOrControlPropertyInYourGallery & "</td>
       <td>" & someColumnOrControlPropertyInYourGallery & "</td>
     </tr>"
) &
"</table>"

I hope this is helpful for you.

_____________________________________________________________________________________
Digging it? - Click on the Thumbs Up below. Solved your problem? - Click on Accept as Solution below. Others seeking the same answers will be happy you did.
NOTE: My normal response times will be Mon to Fri from 1 PM to 10 PM UTC (and lots of other times too!)
Check out my PowerApps Videos too! And, follow me on Twitter @RandyHayes

Really want to show your appreciation? Buy Me A Cup Of Coffee!

View solution in original post

1 REPLY 1
RandyHayes
Super User
Super User

@oappdev 

You mention a Gallery and a Combobox, but yet you are mentioning in your Formula for the Html "DataCardValue1".  This implies a Form...

Are you trying to iterate over the values of a Form or a Gallery?

 

I am not sure of your connection because of the above statement, but here is some information that may help you get moving past where you are.

 

If you are trying to turn a Gallery into an Html Table, then this is what you need to do:

"<table>
    <tr>
        <th>Provider Name</th>
        <th>National Provider Identifier(NPI)</th>
        <th>Date of Service MM/DD/YYYY(One date per roster)</th>
    </tr>" &
Concat(yourGallery.AllItems, 
    "<tr>
       <td>" & someColumnOrControlPropertyInYourGallery & "</td>
       <td>" & someColumnOrControlPropertyInYourGallery & "</td>
       <td>" & someColumnOrControlPropertyInYourGallery & "</td>
     </tr>"
) &
"</table>"

I hope this is helpful for you.

_____________________________________________________________________________________
Digging it? - Click on the Thumbs Up below. Solved your problem? - Click on Accept as Solution below. Others seeking the same answers will be happy you did.
NOTE: My normal response times will be Mon to Fri from 1 PM to 10 PM UTC (and lots of other times too!)
Check out my PowerApps Videos too! And, follow me on Twitter @RandyHayes

Really want to show your appreciation? Buy Me A Cup Of Coffee!

Helpful resources

Announcements
Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Top Solution Authors
Top Kudoed Authors
Users online (1,239)