cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
oappdev
Advocate V
Advocate V

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 III
Super User III

@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. Solved your problem? - Click on Accept as Solution. Others seeking the same answers will be happy you did.
Check out my PowerApps Videos too!

View solution in original post

1 REPLY 1
RandyHayes
Super User III
Super User III

@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. Solved your problem? - Click on Accept as Solution. Others seeking the same answers will be happy you did.
Check out my PowerApps Videos too!

View solution in original post

Helpful resources

Announcements
PA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

Power Apps Community Call

Monthly Power Apps Community Call

Did you miss the call?? Check out the Power Apps Community Call here!

secondImage

Experience what’s next for Power Apps

See the latest Power Apps innovations, updates, and demos from the Microsoft Business Applications Launch Event.

Power Platform ISV STudio

Power Platform ISV Studio

ISV Studio is the go-to Power Platform destination for ISV’s to monitor & manage applications post-AppSource publish.

Top Solution Authors
Top Kudoed Authors
Users online (46,593)