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?
This training provides practical hands-on experience in creating Power Apps solutions in a full-day of instructor-led App creation workshop.
Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.
At the monthly call, connect with other leaders and find out how community makes your experience even better.