Answered

Formula help

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hello Everyone ,

I am having sharepoint as datasource and wanna convert the chemical formula into subscript form like C02 should be seen as CO and downside 2 number whether it is another like H2O then 2 should go down side. WHat should I use to show in PowerApps.

Regards,

Sagar Shah

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Sort by

Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

@Anonymous
Inspired by this post I was able to build a workaround.

In a SharePoint List I added a Single-line of Text column called 'Sub_Super_script'. Then,
- in ID 1, for this new column, I added the text H2O
- in ID 2, for this new column, I added the text CO2

Then in PowerApps a created a Gallery, added a label for ID (ThisItem.ID) and a HTML Text label (ThisItem.Sub_Super_script) and this is how it displayed (Note: SP List on the left, and Gallery on the right)

Not perfect but maybe a solution for you?

Was this reply helpful? Yes No
Verified answer

v-xida-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @Anonymous ,

Could you please share a bit more about the data structure of your SP List?

Do you want to convert the chemical formula from your SP List Column into subscript form?

I have made a test on my side, I think the Html Text control could achieve your needs. I assume that you want to list your SP List in a Gallery and you connect the Gallery to your SP List already, please add a HTML Text control inside your Gallery to display the chemical info. Set the HtmlText property of the HTML Text control to following:

Subtitute( ThisItem.ChemicalColumn, First(MatchAll(ThisItem.ChemicalColumn, "(?<IndexNumber>\d+)")).FullMatch, "" & First(MatchAll(ThisItem.ChemicalColumn, "(?<IndexNumber>\d+)")).FullMatch & "" )

Please consider take a try with above solution, check if the issue is solved.

Best regards,

Was this reply helpful? Yes No