Unanswered

Covert Percentage to decimal

(0) Share

Report

Posted on by techno Microsoft Employee

Hi,

I am building a Power App with a form connected to SQL database. I have field in which user enters number as a percentage(like 50 or 50%). I want PowerApps to convert number to decimal(0.5) and then store in SQL Database. Can anyone please guide me how should I do this.

Thanks in advance!

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (0)

Sort by

Edwin-Abdalian 641 on at

Like
a
(1)

Report
Copy link

Link copied!

Let's say your form has a datacard called Number_DataCard1, and this datacard has a txtbox inside it called DataCardValue1.

First make sure that DataCardValue1's Format property is set to Number.
Then Select Number_DataCard1, and set its Update property to DataCardValue1/100 (you need to unlock the advanced properties of this control to be able to edit it)
Whatever is set in the Update property, is the value that will be patched to your data source.

--------------------------------------------------------------------
If this post helps, please choose Accept As Solution to help the other members, and give my post a Thumbs Up.

Was this reply helpful? Yes No
v-siky-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @techno ,

Do you want to convert 50/50% (you enter) to 0.5 in SQL table? What is the type of that column?
If you want to enter 50 or 50%, I think it should divide two situation to judge. So please put the following formula to Update property of DataCard(Unlock it first ).
If(EndsWith(DataCardValue1.Text,"%"),Value(DataCardValue1.Text),DataCardValue1.Text/100)
Whether you type 50 or 50%, they all be saved at 0.5.
Hope this helps.
Best regards,
Sik

Was this reply helpful? Yes No
techno Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

@v-siky-msft Thanks. I used Format(Text.Number) to convert text to Number. In SQL Table, the type of column is number.

Was this reply helpful? Yes No
techno Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
And now, I want to bring the values from the table in a Gallery after filtering and I want to show the value 0.5 from SQl table as agin 50/50%.

Currently, I am using
Filter('[dbo].[Sell-InTarget]',Area=varArea,Subsidiary=varSubsidiary,FiscalYearQuarter=varFYQ)
under 'Items'.

How should I do that?

Was this reply helpful? Yes No
techno Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks @Edwin-Abdalian. This was helpful. But, I want to let the user enter 50 or 50%.

Was this reply helpful? Yes No