Share
Report
109I 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!!
All responses (
Answers (
