Auto populate form fields into HtmlText control

[oappdev]

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.

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?

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

[RandyHayes · Accepted solution]

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