Hi,
I have a SharePoint list with a rich-text column, say 'Acronym' and a column with a contact. In my PowerApp I have a text field in which I enter an acronym. The output in a label should be the contact name for the acronym that is looked up in the SharePoint list.
Example
Acronym in SharePoint (rich-text)
<div class="ExternalClass72348C84671546F7BCC878BB2A38DB7F"><div style="font-family:Calibri, Arial, Helvetica, sans-serif;font-size:11pt;color:rgb(0, 0, 0);"><a href="https://link.com" title="ABC123"><span style="color:black;"><span>ABC123</span></span></a><br></div></div>
Acronym in PowerApps
PlainText(Acronym) -> "ABC123"
TextInput in PowerApps
Label in PowerApps showing the name for the matching acronym
Name:
...nothing
So far I have:
First(LookUp(List; PlainText(Acronym) = TextInput.Text).Contact.DisplayName).DisplayName
PlainText(Acronym) gives me "ABC123" and TextInput.Text also. But the comparison PlainText(Acronym) = TextInput.Text returns false. Same with StartsWith()...
I also tried to compare the strings with IsMatch which doesn't work because of the two variables (you can only have a constant parameter as the second argument).
Even filtering the list and displaying it in a gallery component fails with this code:
Filter(List; PlainText(Acronym) = "ABC123")
Does this have anything to do with the PlainText()? Is it returning a different data type than Sting??
