cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
New Member

Help with power apps format

Hello,

 

I have a power apps form linked to a SharePoint list which automatically populates data into the list when entered and one of the fields is '%'.

 

When entering a value in the power apps it is multiplying the number by 100. 

Eg: When I enter 25. It populates the %column in the list as 2500%.

 

But, when I enter 0.25. It populates the list as 25%.

 

There is no issue with the column format in the list. When I directly enter a number in the list it is taking the number as is. The issue is with the Power app.

 

Currently, I have the data card formatted as 'Number'.  Is there any other format?

 

I would like the Power app to take the number as is and not multiply it by 100.

 

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Advocate I
Advocate I

Re: Help with power apps format

You can just make two fields in your powerapp:

 

Field 1: This is where they enter the percent such as 25

Field 2: This is the actual data field that is saved to the list. You can mark this as hidden so they only see the Field 1. You make the default property: Value(Field1.Text)/100

This will save to the sharepoint list as 25%.

View solution in original post

1 REPLY 1
Highlighted
Advocate I
Advocate I

Re: Help with power apps format

You can just make two fields in your powerapp:

 

Field 1: This is where they enter the percent such as 25

Field 2: This is the actual data field that is saved to the list. You can mark this as hidden so they only see the Field 1. You make the default property: Value(Field1.Text)/100

This will save to the sharepoint list as 25%.

View solution in original post

Helpful resources

Announcements
August 2020 Community Challenge: Can You Solve These?

August 2020 Community Challenge: Can You Solve These?

We're excited to announce our first cross-community 'Can You Solve These?' challenge!

secondImage

Return to Workplace

Reopen responsibly, monitor intelligently, and protect continuously with solutions for a safer work environment.

secondImage

Super Users Coming in August

We are excited for the next Super User season.

secondImage

Community User Group Member Badges

FIll out a quick form to claim your community user group member badge today!

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors
Users online (7,349)