cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
MindfulMike
Helper II
Helper II

Formatting percentage not working on Form Edit Mode after amount is changed. Help!

 

I have an app with a Profit Margin field. 

 

The On Change is below and formats correctly when someone is submitting a new form:

 

Set(

varMargin,DataCardValueMargin.Text*1.00&"%")

 

Now, there is a gallery of past submissions at the start of the app. If someone wanted to look at or change a submission they click on the gallery item and it turns the form to Edit mode and pre-populates the app with the info. 

 

The Default value for my Margin Field is below and also works. This makes sure that the gallery item comes in as a %.

 

If(
'MarginForm'.Mode = FormMode.Edit,
(Text(Parent.Default)*100.00&"%"),
varMargin
)

 

My issue starts here. If a person brings in a previous submission it comes in as a % but when they go to change it, it does not automatically switch to %. How do I manipulate my formula to make that happen?

 

Being that this app is connected to so many other processes and flows I'd like to avoid changing the set up of my fields on the app and SP and only focus on solutions using formulas. Are there any formulas I can use in the Update or Reset properties? 

 

Sorry, this is a repost, haven't figured it out since my previous post about this. Thanks in advanced!! 

MindfulMike_0-1654096683185.png

 

0 REPLIES 0

Helpful resources

Announcements
Power Platform Call June 2022 768x460.png

Power Platform Community Call

Join us for the next call on August 17, 2022 at 8am PDT.

Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

Users online (1,489)