Unanswered

Possibility to have a percentage formatting overlay on a Text control

(0) Share

Report

Posted on by Community Power Pla...

I know it sounds stupid, but please hear me out.

We have a situation where some SharePoint columns are prepopulated as percentages, but not every record in those columns is pre-populated.

I have built an app to pull the prepopulated fields in, and added further controls to permit the user populate additional column fields in the same record. Some of the prepopulated fields are mandatory, such that the user has to put some text in regardless if they have no data to begin with. The issue is these fields have been formatted as numbers with percentage overlays

Text( 

 Value(Parent.Default) * 100, 

 "#%" 

)

However, where no data exists in the same control, I have been asked if it is possible to have the option to be able to type some text (such as "Not applicable"). I know with text columns, numbers and text may be added, but then I would assume I would lose the percentage formatting.

Is it possible to have all three: text, numbers, and percentage formatting? If so, how would I format the control to offer both percentages and text?

Thanks in advance

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

WarrenBelz 153,034 Most Valuable Professional on at

Like (1)

Report
Hi @Anonymous ,

Maybe something like this

If( IsBlank(Parent.Default), "Not Applicable", Text( Value(Parent.Default) * 100, "#%" ) )

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

MVP (Business Applications) Visit my blog Practical Power Apps

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Hi @WarrenBelz,

Thanks again to your contribution.

Your guidance appears to work for a column that is Single line Text and NOT prepopulated.
However it does nothing to the column that is Single line Text and prepopulated. (i.e. to that column when I find a blank record, it is left blank.) I changed the column from number to single line text and back to number again, but it doesn't make any difference. (I do note that SharePoint puts out the warning about potential loss of data if the column formats are changed between text and number). While there appears to be no data loss, it knocks the decimal point for six.

I'm happy to draw a line under this as intractable. Just thought I would put this out to the community in case someone had found a solution. I also suspect that even if a solution is found, I'll most likely be asked if I can provide an option to have it prepopulated as a percentage and allow for free text as well 😉.

Was this reply helpful? Yes No
Verified answer

WarrenBelz 153,034 Most Valuable Professional on at

Like (0)

Report

Hi @Anonymous ,

Firstly this would need to be a Single Line of Text to work. I am not clear however what prepopulated means in your context.

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Hi @WarrenBelz

Thanks for your reply. So the situation is this. The controls I have attributed the code overlay at the top of this thread applied to SharePoint columns formatted as number (as percentages). Of course percentages fail to show in the controls, hence the code overlay. Questions were asked, after I set it up this way, if I could format it to accept text as an alternative. You have provided the answer and I have checked that it does seem to work on single line text (I must have had mine on multiline text).

My problem now is that when I switch the test column from text to number format, the data disappears from the column. SP does warn about the possibility of data loss, so I'm reluctant at this stage to change the relevant columns to single line text as it would set the project back a couple of days if data was lost. Something for me to consider looking forward however, thanks for the tip.

Was this reply helpful? Yes No