Dealing with SQL Time data - new way yet?

(0) Share

Report

Posted on by BrianHFASPS

718

My apps that I built in 2018-2019 rely upon an Azure SQL DB. I track the time of events in that DB but then want to display / sort based on normal way to view time. Way back then I found More Regular Expressions for Canvas apps - Microsoft Power Platform Blog that said a better way is coming. Was there ever "a better way"? This is how the time is stored in the DB.

First(ForAll(MatchAll(Text(ThisItem.MorningSigninTime),"PT(?:(?<hours>\d+)H)?(?:(?<minutes>\d+)M)?(?:(?<seconds>\d+)S)?"),Time(Value(hours),Value(minutes),Value(seconds)))).Value

That is a sample of the code. If I attempt to sort by it then it isn't delegatable.

Categories:

Building Power Apps

I have the same question (0)