Power Platform Community Forum Thread Details

Hi,

I have a gallery that has values, but sometimes you want to remove those values and have NULL/Blank(). I'm not allowed to save/patch this to my SQL source.
I have seen workaround with turning on Formula-level error management enabled. However this does not seem to work for me and in addition it creates a whole mess, when all my Text input fields that are values not have an error thrown saying "We cannot convert the value to a number because the value is not a string (or empty string).
Have seen workaround for this aswell with Iferror. But still not getting my gallery to write NULL value to replace a previous value.
Has anyone solved this succesfully as this is a bigg issue for me and would like to not go through my whole app and add iferror on every single text input with values.

Thanks!

Categories:

Building Power Apps