Converting null Time from SQL results in not blank value?

(1) Share

Report

Posted on by BrianHFASPS

732

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?

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Sort by

eka24 20,925 on at

Like
a
(0)

Report
Copy link

Link copied!

Kindly check this post if it can help
https://powerusers.microsoft.com/t5/Building-Power-Apps/can-t-update-value-from-null-SQL/m-p/261780

Was this reply helpful? Yes No
BrianHFASPS 732 on at

Like
a
(0)

Report
Copy link

Link copied!

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?

Was this reply helpful? Yes No
Verified answer

BrianHFASPS 732 on at

Like
a
(0)

Report
Copy link

Link copied!

This problem appears to be caused by recent change in Powerapps. See https://powerusers.microsoft.com/t5/Building-Power-Apps/Regression-Change-in-3-20021-29-to-3-20022-19-related-to-the/m-p/482129 for more details.

Was this reply helpful? Yes No