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
Ignite 2022

WHAT’S NEXT AT MICROSOFT IGNITE 2022

Explore the latest innovations, learn from product experts and partners, level up your skillset, and create connections from around the world.

Power Apps Africa Challenge 2022

Power Apps Africa Challenge

Your chance to join an engaging competition of Power Platform enthusiasts.

Top Kudoed Authors
Users online (1,679)