How to set the number of decimals in a list box within a grouped gallery

[Anonymous]

I see I am suppoed to use the text funtion under the Items formula?

This is what I have in there now:

ThisItem.StaffData.Start_x0020_Time

StaffData is the GroupBy label

That GroupBy is below for reference:

GroupBy('Time Sheets',"First_x0020_and_x0020_Last_x0020","StaffData")

How do I either use Text or Round or whatever to reduce my number of decimals in the gallery?

Thanks for your help!

CptBeni

[dinusc]

You should be able to use "Text" function described here: https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/functions/function-text

If however your intent is just to limit the number of characters, "Left" should also work just fine: https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/functions/function-left-mid-right

When working with numbers (which does not look to be your case), you can also use "Round" functions: https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/functions/function-round 

[CarlosFigueira]

The Items property of the listbox can be a collection with multiple fields, so you can use the AddColumns function to add a new column that is formatted as you want. For example:

AddColumns(
    ThisItem.StaffData,
    "Formatted",
    Text(Start_x0200_Time, "0.00"))

And in the advanced properties for the list box control you can choose the new column to be displayed:

[Anonymous]

Well now, that is a great tip! unfourtunatly, I gave it a go and I can't make it work:

Thanks for helping!

[Anonymous]

I have tried this several times, perhaps my syntax is not correct?

[Anonymous]

I Tried the Left function. It works just fine. Why would the Text function not work at all?

[v-xida-msft]

Hi @Anonymous,

I agree with @CarlosFigueira's thought almost. I have made a test on my side and don't have the issue that you mentioned. The screenshot as below:

Within List box control, under the DATA part, the Value property should be specified to Formatted rather than Regular_x0020_Hours, the screenshot as below:

On your side, you could set the Items property of the List box control to following formula:

AddColumns(ThisItem.StaffData,"RegularHours",Text(Regular_x0020_Hours,"[$-en-US]#.00"))

then specify the Value property to RegularHours as below:

Best regards,

Kris