Handle percentage field

(0) Share

Report

Posted on by esjimenezp

485

Hi Community,

I have the next issue, in SharePoint exist a fields with the Percentage type

Then in Power Apps the field is pointed to the percentage from SharePoint, I use the next formula to see it at the correct number from the source

Text(Value(varStatusReport.Milestone1Percentage)*100,"#%")

and the field looks good (at this point)

but, when I tried to update or create a new record, the field change, look

Any ideas how this happened?

This is the code I used in the Patch

Milestone1Percentage: Value(txt_Milestone1Percentage.Text),

thank for all the support.

Kind regards 👋

Categories:

Building Power Apps

I have the same question (0)

All responses (8)

Answers (1)

Sort by

SBax 1,348 on at

Like (0)

Report
Copy link

Link copied!

How are you creating/updating the value?

Is this with a patch formula? If so, can you share the formula you are using?

Was this reply helpful? Yes No
esjimenezp 485 on at

Like (0)

Report
Copy link

Link copied!
sure, the Patch for update the fields are the next one
Set( varStatusReport, Patch( 'Project Inventory', varStatusReport, { Milestone1Percentage: Value(txt_Milestone1Percentage.Text) } ) );

Was this reply helpful? Yes No
SBax 1,348 on at

Like (0)

Report
Copy link

Link copied!

Try using:

Value(txt_Milestone1Percentage.Text) / 100 to revert back to the correct number

Was this reply helpful? Yes No
esjimenezp 485 on at

Like (0)

Report
Copy link

Link copied!

Now, it changes to a decimal numbers in Power Apps
and SharePoint changed to this one
I need that in power apps the end user can typed as a whole number instead a decimal.

Kind regards 👋

Was this reply helpful? Yes No
SBax 1,348 on at

Like (1)

Report
Copy link

Link copied!

Have a look at this blog

I'm away from my desk, but fairly confident that it's a formatting issue

Was this reply helpful? Yes No
Verified answer

esjimenezp 485 on at

Like (0)

Report
Copy link

Link copied!
Hi @SBax
I use the next code into the Default property of the number field

varStatusReport.Milestone1Percentage * 100

then into the Patch code I use the next one

Milestone1Percentage: Value(txt_Milestone1Percentage.Text / 100),
Thanks for all the support.

Kind regards 👋

Was this reply helpful? Yes No
SBax 1,348 on at

Like (1)

Report
Copy link

Link copied!

Hi @esjimenezp

This was what I was suggesting earlier today

Glad you got this working

Was this reply helpful? Yes No
esjimenezp 485 on at

Like (0)

Report
Copy link

Link copied!

thanks @SBax I really appreciate your help 👋

Was this reply helpful? Yes No