Power Platform Community Forum Thread Details

pre: sorry for my english 😁

I had a problem that using json in utf-8, certain characters were not accepted. Since there is no "ready" solution, I tried to find one that was effective and maintainable over time.

in this case I used a table in dataverse (which I then load into collection) where in the column (origin) I put the character that I have to replace and in the destination column its corresponding

This is the formula i used :

Concat(Split(testo_ck.Text;"") As tb_tmp;If(Find(tb_tmp.Result;Concat(coll_sost;Origine;""))>0;LookUp(coll_sost;Origine=tb_tmp.Result).destinazione;tb_tmp.Result);""))

testo_ck.Text : is the text_label containg the original value to be converted

coll_sost: is the collection of the "translating" table

Origine: name of the colum containing the original value (to be sobstutited)

destinazione: name of the column containig the destination value

hope could be useful for someone

Categories:

General Questions

Mobile App

Using Apps Using Formulas