
Announcements
hi expert
i am trying to generate a html table in power apps which will list all the items form the sharepoint.
Step 1 created a collection
this collection add specific column from the sharepoint list
ClearCollect(OppCOl,ShowColumns(Opportunity,"caseid","opportunityID","opportunitydescription","frmrecommendation","actionplanownerlob","businessactionplan","lobexecutive","datetargetclose"));
Step 2.
Add the collection to the local variable and patch the value to the custom collection of required table.
UpdateContext({selectedCase_Opp:SortByColumns(Filter(OppCOl,caseid=VarE.casepovidevent),"opportunityID")});
ClearCollect(case_allOpp,{});
ForAll (selectedCase_Opp,
Collect(case_allOpp,{
opportunityID:selectedCase_Opp[@opportunityID],
referenceid: selectedCase_Opp[@caseid],
opportunitydescription: selectedCase_Opp[@opportunitydescription],
frmrecommendation: selectedCase_Opp[@frmrecommendation],
actionplanownerlob:selectedCase_Opp[@actionplanownerlob],
impact:Impact.Text,
complexity:Comp.Text,
businessactionplan:selectedCase_Opp[@businessactionplan],
lobexecutive:selectedCase_Opp[@lobexecutive],
datetargetclose: selectedCase_Opp[@datetargetclose],
isCurrent:If(selectedCase_Opp[@caseid]=VarE.casepovid,"Yes","No")
}))
Stepm 3:
call that custom collection in html table
<table class=MsoNormalTable border=0 cellspacing=0 cellpadding=0 width=1171
style='margin-left:.25pt;border-collapse:collapse;mso-table-layout-alt:fixed;
mso-yfti-tbllook:1184;mso-padding-alt:0cm 0cm 0cm 0cm'>
<thead>
<tr style='mso-yfti-irow:0;mso-yfti-firstrow:yes;height:17.4pt'>
<td width=103 valign=top style='width:77.35pt;border:solid windowtext 1.0pt;
border-bottom:none;mso-border-top-alt:solid windowtext .5pt;mso-border-left-alt:
solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt;padding:
0cm 0cm 0cm 0cm;height:17.4pt'>
<p class=MsoNormal align=center style='text-align:center;line-height:105%'><b><span
lang=EN-US style='font-size:8.0pt;line-height:105%;mso-bidi-font-family:
Calibri;mso-bidi-theme-font:minor-latin;color:black'><o:p> </o:p></span></b></p>
</td>
<td width=123 valign=top style='width:92.1pt;border-top:solid windowtext 1.0pt;
border-left:none;border-bottom:none;border-right:solid windowtext 1.0pt;
mso-border-left-alt:solid windowtext .5pt;mso-border-top-alt:solid windowtext .5pt;
mso-border-left-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt;
padding:0cm 0cm 0cm 0cm;height:17.4pt'>
<p class=MsoNormal align=center style='text-align:center;line-height:105%'><b><span
lang=EN-US style='font-size:8.0pt;line-height:105%;mso-bidi-font-family:
Calibri;mso-bidi-theme-font:minor-latin;color:black'><o:p> </o:p></span></b></p>
</td>
<td width=132 rowspan=3 valign=top style='width:99.25pt;border:solid windowtext 1.0pt;
border-left:none;mso-border-left-alt:solid windowtext .5pt;mso-border-alt:
solid windowtext .5pt;padding:0cm 0cm 0cm 0cm;height:17.4pt'>
<p class=MsoNormal><b><span lang=EN-US style='font-size:8.0pt;line-height:
106%;mso-bidi-font-family:Calibri;mso-bidi-theme-font:minor-latin;
color:black'><o:p> </o:p></span></b></p>
<p class=MsoNormal><b><span lang=EN-US style='font-size:8.0pt;line-height:
106%;mso-bidi-font-family:Calibri;mso-bidi-theme-font:minor-latin;
color:black'><o:p> </o:p></span></b></p>
<p class=MsoNormal align=center style='text-align:center'><b><span
lang=EN-US style='font-size:8.0pt;line-height:106%;mso-bidi-font-family:
Calibri;mso-bidi-theme-font:minor-latin;color:black'>Complexity<o:p></o:p></span></b></p>
</td>
<td width=66 rowspan=3 valign=top style='width:49.6pt;border:solid windowtext 1.0pt;
border-left:none;mso-border-left-alt:solid windowtext .5pt;mso-border-alt:
solid windowtext .5pt;padding:0cm 0cm 0cm 0cm;height:17.4pt'>
<p class=MsoNormal align=center style='text-align:center;line-height:105%'><b><span
lang=EN-US style='font-size:8.0pt;line-height:105%;mso-bidi-font-family:
Calibri;mso-bidi-theme-font:minor-latin;color:black'><o:p> </o:p></span></b></p>
<p class=MsoNormal align=center style='text-align:center;line-height:105%'><b><span
lang=EN-US style='font-size:8.0pt;line-height:105%;mso-bidi-font-family:
Calibri;mso-bidi-theme-font:minor-latin;color:black'><o:p> </o:p></span></b></p>
<p class=MsoNormal align=center style='text-align:center;line-height:105%'><b><span
lang=EN-US style='font-size:8.0pt;line-height:105%;mso-bidi-font-family:
Calibri;mso-bidi-theme-font:minor-latin;color:black'>Opportunity #</span></b><b><span
lang=EN-US style='font-size:10.0pt;line-height:105%;font-family:'Arial',sans-serif;
color:black'><o:p></o:p></span></b></p>
</td>
<td width=161 rowspan=3 style='width:120.5pt;border-top:solid windowtext 1.0pt;
border-left:none;border-bottom:none;border-right:solid windowtext 1.0pt;
mso-border-left-alt:solid windowtext .5pt;padding:0cm 5.4pt 0cm 5.4pt;
height:17.4pt'>
<p class=MsoNormal align=center style='text-align:center;line-height:105%'><b><span
lang=EN-US style='font-size:8.0pt;line-height:105%;mso-bidi-font-family:
Calibri;mso-bidi-theme-font:minor-latin;color:black'>Root Cause/Opportunity <o:p></o:p></span></b></p>
</td>
<td width=236 rowspan=3 style='width:177.2pt;border-top:solid windowtext 1.0pt;
border-left:none;border-bottom:none;border-right:solid windowtext 1.0pt;
padding:0cm 5.4pt 0cm 5.4pt;height:17.4pt'>
<p class=MsoNormal align=center style='text-align:center;line-height:105%'><b><span
lang=EN-US style='font-size:8.0pt;line-height:105%;mso-bidi-font-family:
Calibri;mso-bidi-theme-font:minor-latin;color:black'>Potential
Recommendations<o:p></o:p></span></b></p>
</td>
<td width=350 colspan=3 style='width:262.2pt;border:solid windowtext 1.0pt;
border-left:none;padding:0cm 5.4pt 0cm 5.4pt;height:17.4pt'>
<p class=MsoNormal align=center style='text-align:center;line-height:105%'><b><span
lang=EN-US style='font-size:8.0pt;line-height:105%;mso-bidi-font-family:
Calibri;mso-bidi-theme-font:minor-latin;color:black'>Business Response<o:p></o:p></span></b></p>
</td>
</tr>
<tr style='mso-yfti-irow:1;height:39.45pt'>
<td width=103 rowspan=2 valign=top style='width:77.35pt;border:solid windowtext 1.0pt;
border-top:none;mso-border-left-alt:solid windowtext .5pt;mso-border-bottom-alt:
solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt;padding:
0cm 0cm 0cm 0cm;height:39.45pt'>
<p class=MsoNormal align=center style='text-align:center'><b><span
lang=EN-US style='font-size:8.0pt;line-height:106%;mso-bidi-font-family:
Calibri;mso-bidi-theme-font:minor-latin;color:black'><o:p> </o:p></span></b></p>
<p class=MsoNormal align=center style='text-align:center'><b><span
lang=EN-US style='font-size:8.0pt;line-height:106%;mso-bidi-font-family:
Calibri;mso-bidi-theme-font:minor-latin;color:black'>Business Line<o:p></o:p></span></b></p>
</td>
<td width=123 valign=top style='width:92.1pt;border:none;border-right:solid windowtext 1.0pt;
mso-border-left-alt:solid windowtext .5pt;mso-border-left-alt:solid windowtext .5pt;
mso-border-right-alt:solid windowtext .5pt;padding:0cm 0cm 0cm 0cm;
height:39.45pt'>
<p class=MsoNormal align=center style='text-align:center'><b><span
lang=EN-US style='font-size:8.0pt;line-height:106%;mso-bidi-font-family:
Calibri;mso-bidi-theme-font:minor-latin;color:black'><o:p> </o:p></span></b></p>
<p class=MsoNormal align=center style='text-align:center'><b><span
lang=EN-US style='font-size:8.0pt;line-height:106%;mso-bidi-font-family:
Calibri;mso-bidi-theme-font:minor-latin;color:black'>Impact<o:p></o:p></span></b></p>
</td>
<td width=123 rowspan=2 style='width:92.1pt;border-top:none;border-left:
none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt;
padding:0cm 5.4pt 0cm 5.4pt;height:39.45pt'>
<p class=MsoNormal align=center style='text-align:center;line-height:105%'><b><span
lang=EN-US style='font-size:8.0pt;line-height:105%;mso-bidi-font-family:
Calibri;mso-bidi-theme-font:minor-latin;color:black'>Action <o:p></o:p></span></b></p>
</td>
<td width=142 rowspan=2 style='width:106.35pt;border-top:none;border-left:
none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
mso-border-top-alt:solid windowtext .5pt;mso-border-left-alt:solid windowtext .5pt;
mso-border-alt:solid windowtext .5pt;padding:0cm 5.4pt 0cm 5.4pt;height:
39.45pt'>
<p class=MsoNormal align=center style='text-align:center;line-height:105%'><b><span
lang=EN-US style='font-size:8.0pt;line-height:105%;mso-bidi-font-family:
Calibri;mso-bidi-theme-font:minor-latin;color:black'>Owner <o:p></o:p></span></b></p>
</td>
<td width=85 rowspan=2 style='width:63.75pt;border-top:none;border-left:
none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
mso-border-left-alt:solid windowtext .5pt;mso-border-left-alt:solid windowtext .5pt;
mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext 1.0pt;
padding:0cm 5.4pt 0cm 5.4pt;height:39.45pt'>
<p class=MsoNormal align=center style='text-align:center;line-height:105%'><b><span
lang=EN-US style='font-size:8.0pt;line-height:105%;mso-bidi-font-family:
Calibri;mso-bidi-theme-font:minor-latin;color:black'>Resolution Date<o:p></o:p></span></b></p>
</td>
</tr>
<tr style='mso-yfti-irow:2;height:21.05pt'>
<td width=123 valign=top style='width:92.1pt;border-top:none;border-left:
none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
mso-border-left-alt:solid windowtext .5pt;mso-border-left-alt:solid windowtext .5pt;
mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt;
padding:0cm 0cm 0cm 0cm;height:21.05pt'>
<p class=MsoNormal><b><span lang=EN-US style='font-size:8.0pt;line-height:
106%;mso-bidi-font-family:Calibri;mso-bidi-theme-font:minor-latin;
color:black'><o:p> </o:p></span></b></p>
</td>
</tr>"&
Concat(case_allOpp,If(isCurrent="Yes","
<tr style='mso-yfti-irow:3;mso-yfti-lastrow:yes;height:17.4pt'>
<td width=103 valign=top style='width:77.35pt;border:solid windowtext 1.0pt;
border-top:none;mso-border-top-alt:solid windowtext .5pt;mso-border-alt:
solid windowtext .5pt;padding:0cm 0cm 0cm 0cm;height:17.4pt'>
<p class=MsoNormal><span lang=EN-US style='font-size:8.0pt;line-height:106%;
mso-bidi-font-family:Calibri;mso-bidi-theme-font:minor-latin;color:black'>"&actionplanownerlob&"</span><o:p></o:p></span></p>
</td>
<td width=123 valign=top style='width:92.1pt;border-top:none;border-left:
none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
mso-border-top-alt:solid windowtext .5pt;mso-border-left-alt:solid windowtext .5pt;
mso-border-alt:solid windowtext .5pt;padding:0cm 0cm 0cm 0cm;height:17.4pt'>
<p class=MsoNormal><span lang=EN-US style='font-size:8.0pt;line-height:106%;
mso-bidi-font-family:Calibri;mso-bidi-theme-font:minor-latin;color:black'>"&impact&"<o:p></o:p></span></p>
</td>
<td width=132 valign=top style='width:99.25pt;border-top:none;border-left:
none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
mso-border-top-alt:solid windowtext .5pt;mso-border-left-alt:solid windowtext .5pt;
mso-border-alt:solid windowtext .5pt;padding:0cm 0cm 0cm 0cm;height:17.4pt'>
<p class=MsoNormal><span lang=EN-US style='font-size:8.0pt;line-height:106%;
mso-bidi-font-family:Calibri;mso-bidi-theme-font:minor-latin;color:black'>"&complexity&"<o:p></o:p></span></p>
</td>
<td width=66 valign=top style='width:49.6pt;border-top:none;border-left:
none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
mso-border-top-alt:solid windowtext .5pt;mso-border-left-alt:solid windowtext .5pt;
mso-border-alt:solid windowtext .5pt;padding:0cm 0cm 0cm 0cm;height:17.4pt'>
<p class=MsoNormal><span class=SpellE><span lang=EN-US style='font-size:
10.0pt;line-height:106%;font-family:'Arial',sans-serif;color:black'>"&opportunityID&"<o:p></o:p></span></p>
</td>
<td width=161 style='width:120.5pt;border:solid windowtext 1.0pt;border-left:
none;mso-border-left-alt:solid windowtext .5pt;padding:0cm 0cm 0cm 0cm;
height:17.4pt'>
<p class=MsoNormal><span class=SpellE><span lang=EN-US style='font-size:
8.0pt;line-height:106%;mso-bidi-font-family:Calibri;mso-bidi-theme-font:
minor-latin;color:black'>"&opportunitydescription&"<o:p></o:p></span></p>
</td>
<td width=236 style='width:177.2pt;border:solid windowtext 1.0pt;border-left:
none;padding:0cm 0cm 0cm 0cm;height:17.4pt'>
<p class=MsoNormal><span lang=EN-US style='font-size:8.0pt;line-height:106%;
mso-bidi-font-family:Calibri;mso-bidi-theme-font:minor-latin;color:black'>"&frmrecommendation&"<o:p></o:p></span></p>
</td>
<td width=123 style='width:92.1pt;border-top:none;border-left:none;
border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
mso-border-top-alt:solid windowtext .5pt;padding:0cm 5.4pt 0cm 5.4pt;
height:17.4pt'>
<p class=MsoNormal align=center style='text-align:center;line-height:105%'><span
lang=EN-US style='font-size:8.0pt;line-height:105%;mso-bidi-font-family:
Calibri;mso-bidi-theme-font:minor-latin;color:black'>"&businessactionplan&"<o:p></o:p></span></p>
</td>
<td width=142 style='width:106.35pt;border-top:none;border-left:none;
border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
mso-border-top-alt:solid windowtext .5pt;padding:0cm 5.4pt 0cm 5.4pt;
height:17.4pt'>
<p class=MsoNormal align=center style='text-align:center;line-height:105%'><span
lang=EN-US style='font-size:8.0pt;line-height:105%;mso-bidi-font-family:
Calibri;mso-bidi-theme-font:minor-latin;color:black'>"&lobexecutive&"<o:p></o:p></span></p>
</td>
<td width=85 style='width:63.75pt;border-top:none;border-left:none;
border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
mso-border-top-alt:solid windowtext .5pt;padding:0cm 5.4pt 0cm 5.4pt;
height:17.4pt'>
<p class=MsoNormal align=center style='text-align:center;line-height:105%'><span
lang=EN-US style='font-size:8.0pt;line-height:105%;mso-bidi-font-family:
Calibri;mso-bidi-theme-font:minor-latin;color:black'>"&datetargetclose&"<o:p></o:p></span></p>
</td>
</tr>",
"<tr style='mso-yfti-irow:3;mso-yfti-lastrow:yes;height:17.4pt'>
<td width=103 valign=top style='width:77.35pt;border:solid windowtext 1.0pt;
border-top:none;mso-border-top-alt:solid windowtext .5pt;mso-border-alt:
solid windowtext .5pt;padding:0cm 0cm 0cm 0cm;height:17.4pt'>
<p class=MsoNormal><span lang=EN-US style='font-size:8.0pt;line-height:106%;
mso-bidi-font-family:Calibri;mso-bidi-theme-font:minor-latin;color:black'>"&actionplanownerlob&"</span><o:p></o:p></span></p>
</td>
<td width=123 valign=top style='width:92.1pt;border-top:none;border-left:
none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
mso-border-top-alt:solid windowtext .5pt;mso-border-left-alt:solid windowtext .5pt;
mso-border-alt:solid windowtext .5pt;padding:0cm 0cm 0cm 0cm;height:17.4pt'>
<p class=MsoNormal><span lang=EN-US style='font-size:8.0pt;line-height:106%;
mso-bidi-font-family:Calibri;mso-bidi-theme-font:minor-latin;color:black'>"&impact&"<o:p></o:p></span></p>
</td>
<td width=132 valign=top style='width:99.25pt;border-top:none;border-left:
none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
mso-border-top-alt:solid windowtext .5pt;mso-border-left-alt:solid windowtext .5pt;
mso-border-alt:solid windowtext .5pt;padding:0cm 0cm 0cm 0cm;height:17.4pt'>
<p class=MsoNormal><span lang=EN-US style='font-size:8.0pt;line-height:106%;
mso-bidi-font-family:Calibri;mso-bidi-theme-font:minor-latin;color:black'>"&complexity&"<o:p></o:p></span></p>
</td>
<td width=66 valign=top style='width:49.6pt;border-top:none;border-left:
none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
mso-border-top-alt:solid windowtext .5pt;mso-border-left-alt:solid windowtext .5pt;
mso-border-alt:solid windowtext .5pt;padding:0cm 0cm 0cm 0cm;height:17.4pt'>
<p class=MsoNormal><span class=SpellE><span lang=EN-US style='font-size:
10.0pt;line-height:106%;font-family:'Arial',sans-serif;color:black'>"&opportunityID&"<o:p></o:p></span></p>
</td>
<td width=161 style='width:120.5pt;border:solid windowtext 1.0pt;border-left:
none;mso-border-left-alt:solid windowtext .5pt;padding:0cm 0cm 0cm 0cm;
height:17.4pt'>
<p class=MsoNormal><span class=SpellE><span lang=EN-US style='font-size:
8.0pt;line-height:106%;mso-bidi-font-family:Calibri;mso-bidi-theme-font:
minor-latin;color:black'>"&opportunitydescription&"<o:p></o:p></span></p>
</td>
<td width=236 style='width:177.2pt;border:solid windowtext 1.0pt;border-left:
none;padding:0cm 0cm 0cm 0cm;height:17.4pt'>
<p class=MsoNormal><span lang=EN-US style='font-size:8.0pt;line-height:106%;
mso-bidi-font-family:Calibri;mso-bidi-theme-font:minor-latin;color:black'>"&frmrecommendation&"<o:p></o:p></span></p>
</td>
<td width=123 style='width:92.1pt;border-top:none;border-left:none;
border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
mso-border-top-alt:solid windowtext .5pt;padding:0cm 5.4pt 0cm 5.4pt;
height:17.4pt'>
<p class=MsoNormal align=center style='text-align:center;line-height:105%'><span
lang=EN-US style='font-size:8.0pt;line-height:105%;mso-bidi-font-family:
Calibri;mso-bidi-theme-font:minor-latin;color:black'>"&businessactionplan&"<o:p></o:p></span></p>
</td>
<td width=142 style='width:106.35pt;border-top:none;border-left:none;
border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
mso-border-top-alt:solid windowtext .5pt;padding:0cm 5.4pt 0cm 5.4pt;
height:17.4pt'>
<p class=MsoNormal align=center style='text-align:center;line-height:105%'><span
lang=EN-US style='font-size:8.0pt;line-height:105%;mso-bidi-font-family:
Calibri;mso-bidi-theme-font:minor-latin;color:black'>"&lobexecutive&"<o:p></o:p></span></p>
</td>
<td width=85 style='width:63.75pt;border-top:none;border-left:none;
border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;
mso-border-top-alt:solid windowtext .5pt;padding:0cm 5.4pt 0cm 5.4pt;
height:17.4pt'>
<p class=MsoNormal align=center style='text-align:center;line-height:105%'><span
lang=EN-US style='font-size:8.0pt;line-height:105%;mso-bidi-font-family:
Calibri;mso-bidi-theme-font:minor-latin;color:black'>"&datetargetclose&"<o:p></o:p></span></p>
</td>
</tr>"))&"
</thead>
</table>
issue:
i am able to generate the table but the blank row is popping up
please advise
Hi @Vedant28 ,
Please replace
ClearCollect(case_allOpp,{});
with
Clear(case_allOpp);
in step2.
Best Regards,
Bof