itemRecord.'Event:FY' gives me 21.0000000 in my label. This is correct, except how do I format it so that I do not get the decimal place and trailing zero's. I have checked that decimal places is set to zero in the original SP list and the list using the lookup comes across as integer. I have tried Text(itemRecord.'Event:FY'.Value, "##"), but I am assuming it does not like the colon or quotes.
Solved! Go to Solution.
Based on the issue that you mentioned, do you want to remove decimals?
Could you please tell me that if this 'Event:FY' is a Lookup column?
Generally, the number in the Lookup column will have decimals by default.
Please set the Text property of the Label as below:
Hope it could help.
I must be missing something so let me give more details. When I just throw a label on the screen and do something like... Value(itemRecord.'Event:FY'.Value) ... I get an integer like "21", which is what I want.
Currently I have my field on a datacard on a form like...
The main card "dcEventFY" has [DataField: "Event_x003a_FY"] [Default: ThisItem.'Event:FY'] [Update: dcEventFYValue].
If I try using (Value(itemRecord.'BSCSRFAMAEvent:FY'.Value)), or even substituting "ThisItem" for "itemRecord", into DefaultSelectedItems it still expects a Table.
I am obviously missing something in syntax and reference understanding in regards to datacards and/or table, records, value in regards to lookup fields.
Check out new user group experience and if you are a leader please create your group
Did you miss the call?? Check out the Power Apps Community Call here!
See the latest Power Apps innovations, updates, and demos from the Microsoft Business Applications Launch Event.
ISV Studio is the go-to Power Platform destination for ISV’s to monitor & manage applications post-AppSource publish.