Hye guys, Im little confuse and need your help. So, I new in Coding also PowerApp, sometimes I explore myself, sometimes I also blank cannot thinking cause im not in programming background. Maybe this problem will easy to you guys..
So I have 2 problems to solve
Problem 1:
In my app gallery, I need to use date but in format "dd/mm/yyyy". I'm using Label to show the date and use this code in text property by this code = ThisItem.'Req-Date'
This code fine for me but it display "mm/dd/yyyy". How can I change to "dd/mm/yyyy"?
ThisItem.'Req-Date'
Problem 2:
My code perfectly working with my gallery, but when I'm using sort function in my gallery.. it sort using Title. So how can I sort based on date (format: dd/mm/yyyy)?
Note: For search function, I thinks its ok just for user search by Title, for sort function, I need this app sort based on date.
SortByColumns(
Filter(
[@'Requestor Details'],
//(varUserEmail.Mail in 'OE-AssignTo'.Email),
StartsWith(
Title,
TextSearchBox1_2.Text
),
StatusDropdown1_2.Selected.Result ="All" Or 'OE-Status'.Value = StatusDropdown1_2.Selected.Result
),
"Title",
If(
SortDescending1,
Descending,
Ascending
)
)
Hope you guys help me. Thanks!