Coalesce no longer being evaluated properly

[HenryARPhillips]

We were using Coalesce to do something along the lines of 

Patch(DataSource,Record,{
Field1: Coalesce(Value(txtinput1.text),0,Value(txtinput1.text))
}
)

Data Source was Azure SQL

SQL column was currency, not checked with others but don't think it is the SQL column type

For now I have to replace the above with If(IsBlank

It might also be specific to when using the Value function within Coalesce

What I do know is it seriously killed whole chunks of logic when present and led to some really undesirable results such as data being blanked out 😞

[v-litu-msft]

Hi @HenryARPhillips,

I tested it on my side but not found the same issue:

Coalesce() function is a function that return the first non-null value in a collection.

If you could share some screenshots of the issue you met, it will help us assist you better.

Best Regards,
Community Support Team _ Lin Tu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[HenryARPhillips]

Thanks for looking into this. If you click the cursor before coalesce does it show the value cannot be evaluated. As that is what is killing the patches and it only seems to be present on the above formulas within the patch.

If not and it can evaluate for you, then I will do some more testing on my end to confirm repro steps.

Thanks

Henry