I pull in a Time field from SQL and then run through the conversion to make it readable in my app with code like this:
"OutTime", First(ForAll(MatchAll(SignoutTime,"PT(?:(?<hours>\d+)H)?(?:(?<minutes>\d+)M)?(?:(?<seconds>\d+)S)?"), Time(Value(hours),Value(minutes),Value(seconds)))).Value,
This is inside an AddColumns function so it creates a new column named OutTime with a clean version of SignoutTime retrieved from SQL.
Then if I run
IsBlank(OutTime) it returns false
IsEmpty(OutTime) it returns false
IsBlank(SignoutTime) it returns true
If I create a label that displays OutTime it shows nothing and appears to be blank. I don't understand what is happening? Can anyone help me understand?
Solved! Go to Solution.
Thanks but that doesn't really explain I think. I am not trying to patch a null. I don't know what the value is that comes out of that code because it isn't blank or empty but at the same time if displayed in a label shows nothing?
Find your favorite faces from the community presenting at the Power Platform Community Conference!
See the latest Power Apps innovations, updates, and demos from the Microsoft Business Applications Launch Event.
ISV Studio is designed to become the go-to Power Platform destination for ISV’s to monitor & manage published applications.
Features releasing from October 2020 through March 2021