Power Platform Community Forum Thread Details

if(isBlank(items('Apply_to_each')?['FieldName']),"",1)

I am trying to use an expression to test for a blank value in an excel table that i am importing to sharepoint. I want to avoid my prep step of adding numbers into all my blank cells in the table. At the end of the day, i will replace the final 1 (else) with something more useful.

I got the expression builder to finally take this expression/formula/function, but when i ran the flow i got the following error:

InvalidTemplate. Unable to process template language expressions in action 'Update_item_4' inputs at line '1' and column '2275': 'The template function 'isBlank' is not defined or not valid.'.

any ideas how i can build this test in an expression for an update item action?

Categories:

Building Power Apps