Answered

Data Field Changing value on navigating screen

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hello Expert,

In my App i have one drop down field name EmployePersonnelNumber , This filed picks data from SQL and then save in Share point list. but for the numbers stating with 0 , it discards all the zero and saves only the remaining number for example if personnel Number is coming from SQL in dropdown as 0003 , it will become 3 on the next screen.

i tried changing the datacard value format from text to number and number to text but no effect. please advise i ll be very grateful.

Please find the screen shot below. the data type of SQL column is "single Text of Line"

Screen 1. when choosing the number by dropdown.

Screen 1. navigating to the next screen

Categories:

Building Power Apps

I have the same question (0)

All responses (19)

Answers (1)

Sort by

Verified answer

C-Papa 1,836 on at

Like
a
(1)

Report
Copy link

Link copied!

Hi, where the value is 3, try changing the default property to

Text([YourNumber],"0000") where [YourNumber] is the same as the current default, most likely Parent.Default

Was this reply helpful? Yes No
RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!

@Anonymous

What is the column type in your SharePoint list? It will need to also be single line of text as your SQL is.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hii @RandyHayes , It is single line of text.

Was this reply helpful? Yes No
RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!

@Anonymous

What is your Default property (assuming this is a Dropdown - DefaultSelectedItems property if a combobox), and the Items property?

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hello @C-Papa , I believe this will append the "0000" text always before the personnelNumber. so in this case if next personnel number will be 0195 it will make it 0000195. which will be wrong value for the record.
correct me if i am wrong

Was this reply helpful? Yes No
C-Papa 1,836 on at

Like
a
(1)

Report
Copy link

Link copied!

It will not do what you have suggested, give it a try

example below:

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
@RandyHayes , this is a drop down.
Please see below.
1. Default property of dropdown is "1"
2.Item property of drop down is
Distinct( Filter( BG_EmpnameTimesheet, NAME=Dropdown3.Selected.Result ),PERSONNELNUMBER).Result
Default property of whole datacard is : ThisItem.EmployePersonnelNumber

Was this reply helpful? Yes No
RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!

@Anonymous

Your Default should be : Parent.Default in order to see the value stored in your SharePoint record when editing.

However, with the formula you have on the Items property - are you actually getting 0195 (for example) or 195?

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!

Hey @C-Papa , This is working good for me. Thank you so much for the help.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

@RandyHayes , on the form where its fetching data(master form screen) from Share point it is Parent.default only.
in drop down i am getting 0195, only when it goes to master form it becomes 195.

Was this reply helpful? Yes No