Insert value for HTML Text

(0) Share

Report

Posted on by firda59

372

Hi Everyone!

I have HTML text for table format, I use this formula for get items for my table:

<tbody>
"
&
Concat(Gallery2.AllItems, "<tr><td>" & Assembly & "</td><td>" & 'Joint No' & "</td><td>" & 'Welding Process' & "</td><td>" & WPS& "</td><td>" & 'Welder ID' & "</td><td>" & Flux & "</td><td>" & Rod & "</td><td>" & 'Inspection Date' & "</td><td>" & Text(Value('Type of Defect'.Value)) & "</td><td>" & 'Weld Size Actual' & "</td><td>" & 'Weld Size Req' & "</td><td>" & 'Inspection Method' & "</td><td>" & DetailInsp & "</td></tr>")
& 
"
</tbody>

But my column 'Type of Defect' are choice type. So it error when I just write like that. The error message is:

How to fix it? Thank you in advance.

Categories:

Building Power Apps

All responses (13)

Answers (1)

Sort by

WarrenBelz 156,545 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @firda59 ,

You just need

'Type of Defect'.Value

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

MVP (Business Applications) Visit my blog Practical Power Apps
firda59 372 on at

Like
a
(0)

Report
Copy link

Link copied!

Hello, @WarrenBelz

after I use that formula, I got this message:
Invalid argument type. Expecting one of the following: Text, Number, Decimal, Date, Time, DateTimeNoTimeZone, DateTime, Boolean, OptionSetValue, ViewValue, UntypedObject.
WarrenBelz 156,545 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

@firda59,

Can you please suply the full HTML text as that is the correct reference providing this is a single choice column.
firda59 372 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @WarrenBelz

<table>
<col width=15%>
<col width=8%>
<col width=7%>
<col width=7%>
<col width=7%>
<col width=9%>
<col width=9%>
<col width=9%>
<col width=8%>
<col width=7%>
<col width=7%>
<col width=7%>
<col width=9%>
<thead>
<tr>
<th style=text-align:center; rowspan=2; colspan=1;>
ASSEMBLY
</th>
<th style=text-align:center; rowspan=2; colspan=1;>
WELD NO.
</th>
<th style=text-align:center; rowspan=2; colspan=1;>
WELDING PROCESS
</th>
<th style=text-align:center; rowspan=2; colspan=1;>
WPS
</th>
<th style=text-align:center; rowspan=2; colspan=1;>
WELDER ID
</th>
<th style=text-align:center; rowspan=1; colspan=2;>
CONSUMABLE
SYMBOL/BATCH NO.
</th>
<th style=text-align:center; rowspan=2; colspan=1;>
DATE
</th>
<th style=text-align:center; rowspan=1; colspan=3;>
INSPECTION RESULT
</th>
<th style=text-align:center; rowspan=2; colspan=1;>
NDE
</th>
<th style=text-align:center; rowspan=2; colspan=1;>
REMARK
</th>
</tr>
<tr>
<th style=text-align:center;> FLUX / K-71TLF</th>
<th style=text-align:center;> ROD</th>
<th style=text-align:center;> DEFECT</th>
<th style=text-align:center;> WELD SIZE</th>
<th style=text-align:center;> WELD REQ.</th>
</tr>
</thead>
<tbody>
"
&
Concat(Gallery2.AllItems, "<tr><td>" & Assembly & "</td><td>" & 'Joint No' & "</td><td>" & 'Welding Process' & "</td><td>" & WPS& "</td><td>" & 'Welder ID' & "</td><td>" & Flux & "</td><td>" & Rod & "</td><td>" & 'Inspection Date' & "</td><td>" & 'Type of Defect'.Value & "</td><td>" & 'Weld Size Actual' & "</td><td>" & 'Weld Size Req' & "</td><td>" & 'Inspection Method' & "</td><td>" & DetailInsp & "</td></tr>")
&
"
</tbody>
</table>

here the HTML text
WarrenBelz 156,545 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

@firda59 ,

Based on what you have posted, if that is a single choice field, the code is correct. You can also use the control name it is contained in the gallery.
firda59 372 on at

Like
a
(0)

Report
Copy link

Link copied!

@WarrenBelz ,
but I still got this message,

Invalid argument type. Expecting one of the following: Text, Number, Decimal, Date, Time, DateTimeNoTimeZone, DateTime, Boolean, OptionSetValue, ViewValue, UntypedObject.

Do you know why this happen?
Ethan_009 4,840 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!

Hi @firda59 ,

Can you show us the data of your collection with respect to the value stored in that column?
I'm not sure why you are getting this since what @WarrenBelz is correct but still you are facing the error then let's see what's stored in your collection.

Also, as per your error,
Try to enable this and check again if it solved your problem

Hope this helps
firda59 372 on at

Like
a
(0)

Report
Copy link

Link copied!

@Ethan_R

Ok, this is my data collection:
Ethan_009 4,840 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @firda59 ,

This is multi-select optionset.
Can you send me screenshot of the collection containing data within the App itself?

If it is stored in table format then you can use
Concat('Type of Defect', "; ") //OR Concat('Type of Defect'.Value, "; ")

But if not then will have to observe the data stored in collection.
firda59 372 on at

Like
a
(0)

Report
Copy link

Link copied!

Hello @Ethan_R

the formula did not error again, but the value not appear.

This is my database:
and this is the result from that HTML: