Share
Reportpre: 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
All responses (
Answers (
320
