Answered

Error writing to html table

(0) Share

Report

Posted on by vidarv

I have a sharepointlist with a coloumn named QualitativeTarget. This is a choive coloumn.

I am trying to set up a html table

 </tr>" & Concat(Filter(
 AktivitetsPlan,Category="General support services"),
 "<tr>
 <td>" &Indicator& " </td>
 <td>" & GruppeNavn & " </td>
 <td>" & Activity & " </td> 
 <td>" & QuantitativeTargets & " </td>
 <td>" & QualitativeTargets & " </td>
 <td>" & QualitativeResults&" </td>
 <td>" & QuantitativeResults & " </td>
 <td>" & Explanation & " </td>
 
 </tr>"

I am getting the following error

Can someone please guide me to the right direction

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (1)

RajnishMahaseth 58 on at

Like (0)

Report

Can you check if the Sharepoint choice column "QualitativeTargets" is compatible with the HTML table. This could be causing the error but I'm not completely sure.

Was this reply helpful? Yes No
LaurensM 12,516 Moderator on at

Like (1)

Report

Hi @vidarv,

Is it a single-select choice column? In that case you can fetch the text value by appending the column name with .Value:

QualitativeTargets.Value

If this solves your question, would you be so kind as to accept it as a solution & give it a thumbs up.

Thanks!

Was this reply helpful? Yes No
vidarv on at

Like (0)

Report

Thank you for answering @LaurensM The choice coloumn is multiselct. Value is not a choice.
@RajnishMahaseth I am not sure what you mean about compatible with html table

Was this reply helpful? Yes No
Verified answer

LaurensM 12,516 Moderator on at

Like (2)

Report
@vidarv,

The column type will be of type table. Should you want to display them concatenated with a separator try:

Concat(QualitativeTargets, Value, ", ")

I hope this helps!

Was this reply helpful? Yes No
vidarv on at

Like (0)

Report

Thank you @LaurensM that worked. Sometimes I am blind 🙂

Was this reply helpful? Yes No