cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Resident Rockstar
Resident Rockstar

Create collection from an html table

I have an apparently good quality html table.  I need to make this into a collection.  I see many ways to go the other way, but not this way.  Can do?

8 REPLIES 8
Highlighted
Super User
Super User

Re: Create collection from an html table

@martinav 

Can you please provide a sample of the HTML table?

Highlighted
Resolver II
Resolver II

Re: Create collection from an html table

Hi @martinav 

Hope my wild guess of your doubts helps.

Sharing of what might be something the way you want.

 

sample html

 

"<b>" & report_title & "</b> <br>" &
"<b> Report Date: </b>" & Text(Today(), "[$-en-US]dd,mmm yyyy") & "<br>" &
"<b> Reported by: </b>" & "QA Dept." & "<p>" &
"<table border=1 width=100%><th colspan=4>" &
"<h4>Monthly Report (Criteria) for " & dd_month_2.Selected.Value & ", " & dd_year_3.Selected.Value & "</h4></th>" &
"<tr>
<th>"&"Criteria"&"</th>
<th>"&"Description"&"</th>
<th>"&"Total Checked"&"</th>
<th>"&"Passed (%)"&"</th>
</tr>"&

Concat(Gallery_month_report_5.AllItems,
"<tr>
<td>" & report_criteria &" </td>
<td>" & report_desc &" </td>
<td>" & report_total_check &" </td>
<td>" & report_pass_rate &" </td>
</tr>")

 

Have a nice day.

Highlighted
Resident Rockstar
Resident Rockstar

Re: Create collection from an html table

Hi @PK_Hong , @mdevaney ,

 

I was hoping to do something like this.  I know its too simple, but it is what I would like to happen.  To have a data collection from the table.:

 

Collect(DataCollection, htmltable.htmltext)

 

However, that does not work, to no surprise.  This is what my HTML table looks like:

 

<table style='font-family:Arial,Helvetica,sans-serif;border-collapse:collapse;width:100%;'>
<tr><th style='padding:4px;padding-top:6px;padding-bottom:6px;text-align:left;background-color:black;color:white;width:171px'>DRAWING #</th>
<th style='padding:4px;padding-top:6px;padding-bottom:6px;text-align:left;background-color:black;color:white;width:599px'>DESCRIPTION</th>
<th style='padding:4px;padding-top:6px;padding-bottom:6px;text-align:left;background-color:black;color:white;width:575px'>NOTES</th>
<th style='padding:4px;padding-top:6px;padding-bottom:6px;text-align:left;background-color:black;color:white;width:150px'>LAST UPDATED</th>
<th style='padding:4px;padding-top:6px;padding-bottom:6px;text-align:left;background-color:black;color:white;width:213px'>LAST UPDATED BY</th>
</tr>

<tr><td style='border:1px solid #ddd; padding: 4px;'>201013</td>
<td style='border:1px solid #ddd; padding: 4px;'>JS75S PRV  Dwg. 72784-2-1</td>
<td style='border:1px solid #ddd; padding: 4px;'> </td>
<td style='border:1px solid #ddd; padding: 4px;'>1/10/2017 2:54:30 PM</td>
<td style='border:1px solid #ddd; padding: 4px;'>smith@company.com</td>
</tr>

<tr><td style='border:1px solid #ddd; padding: 4px;'>201015</td>
<td style='border:1px solid #ddd; padding: 4px;'>JS75S316 General Arrg.</td>
<td style='border:1px solid #ddd; padding: 4px;'> </td>
<td style='border:1px solid #ddd; padding: 4px;'>1/10/2017 2:54:30 PM</td>
<td style='border:1px solid #ddd; padding: 4px;'>smith@company.com</td>
</tr>

<tr><td style='border:1px solid #ddd; padding: 4px;'>201017</td>
<td style='border:1px solid #ddd; padding: 4px;'>JS75S316 General Arrg. w/Flue</td>
<td style='border:1px solid #ddd; padding: 4px;'> </td>
<td style='border:1px solid #ddd; padding: 4px;'>1/10/2017 2:54:30 PM</td>
<td style='border:1px solid #ddd; padding: 4px;'>smith@company.com</td>
</tr>

 

Highlighted
Resolver II
Resolver II

Re: Create collection from an html table

Hi @martinav 

PowerApps supports basic HTML BUT not CSS.

In this case, you need to write using programming language, not powerapps.

 

PA is for people like me, a non-programmer.

 

Have a nice day.

Highlighted
New Member

Re: Create collection from an html table

Anybody got a solution for this. I'm trying to build a collection from a simple HTML table. As I'm having multiple data against a list item, I thought of storing the details as a HTML table. Is there any better approach to achieve this . I don't want to use a child list. 

Highlighted
Resident Rockstar
Resident Rockstar

Re: Create collection from an html table

@dreamweaver9962 ,

 

There is a way to do this in flow.  I'm working on the solution.  I'm really close.  Its a soluiton for getting data from Smartsheet.  It may not work for your situation.

Regular Visitor

Re: Create collection from an html table

Hello Martinav,

 

did you already find a solution. I struggle with the same issue 😞

Highlighted
Resident Rockstar
Resident Rockstar

Re: Create collection from an html table

@ConstantinSeide ,

 

With an html table in general?   Or Smartsheet?

Helpful resources

Announcements
August 2020 Community Challenge: Can You Solve These?

August 2020 Community Challenge: Can You Solve These?

We're excited to announce our first cross-community 'Can You Solve These?' challenge!

secondImage

Return to Workplace

Reopen responsibly, monitor intelligently, and protect continuously with solutions for a safer work environment.

secondImage

Super Users Coming in August

We are excited for the next Super User season.

secondImage

Community User Group Member Badges

FIll out a quick form to claim your community user group member badge today!

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors
Users online (8,002)