web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / html code generating b...
Power Apps
Unanswered

html code generating blank row in table

(0) ShareShare
ReportReport
Posted on by 90

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>&nbsp;</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>&nbsp;</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>&nbsp;</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>&nbsp;</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>&nbsp;</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>&nbsp;</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>&nbsp;</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>&nbsp;</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>&nbsp;</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

 

Vedant28_0-1710908039898.png

please advise 

Categories:
I have the same question (0)
  • Verified answer
    v-bofeng-msft Profile Picture
    on at

    Hi @Vedant28 , 

     

    Please replace 

    ClearCollect(case_allOpp,{});

    with

    Clear(case_allOpp);

    in step2.

     

    Best Regards,

    Bof

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 717 Most Valuable Professional

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 329 Super User 2025 Season 2

#3
Power Platform 1919 Profile Picture

Power Platform 1919 268

Last 30 days Overall leaderboard