Hello,
I have this PowerApps app that is a user form and it gets data from another sharepoint list (which I use as database).
Once the user inserts the code, the LookUp function auto fill all the other fields, It works well for most of the records.
Some of the fields are about chemistry and the text is formatted with tables and greek symbols. I use RichText data cards and also the records on the sharepoint list database uses RichText as well. But this records returns without the sigma symbols and tables.
Example:
Record on my SharePoint list db:
Tabela 2 - Íons m/z identificados por espectrometria de massas na amostra X.
Ionização | Fórmula | m/z Experimental |
[M].+ | C8H10.+ | 106 |
[M – CH3].+ | C7H7.+ | 91 |
[M – C2H5].+ | C6H5.+ | 77 |
[M – C3H5].+ | C5H5.+ | 65 |
[M – C4H7].+ | C4H3.+ | 51 |
[M – C5H7].+ | C3H3.+ | 39 |
Output to PowerApps using LookUp function:
This way the user can't understand or edit the text as it should. Also sigma and other greek symbols won't appear...
Has anybody struggled with this before and knows any solution? I looked for other functions and solutions, but couldn't find anything.
Thanks a lot!

Report
All responses (
Answers (