web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps Formula help

Power Apps

Answered

Formula help

(0) Share

Report

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 Img

All responses (2)

Answers Img

Answers (1)

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 H<sub>2</sub>O
- in ID 2, for this new column, I added the text CO<sub>2</sub>

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, "<sub>" & First(MatchAll(ThisItem.ChemicalColumn, "(?<IndexNumber>\d+)")).FullMatch & "</sub>" )

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

Best regards,

Was this reply helpful? Yes No

Join the conversation