
Announcements
I have a flow that generates a CSV file. I need the information in certain columns to be changed to 1 when it's not empty and 0 when they're empty. I tried using the formula:
but I get error "Action 'AgeBinary' failed: Unable to process template language expressions in action 'AgeBinary' inputs at line '0' and column '0': 'The template language expression 'if(equals(body('Select')?['AGE'],null),0,1)' cannot be evaluated because property 'AGE' cannot be selected. Array elements can only be selected using an integer index. Please see https://aka.ms/logicexpressions for usage details.'."
Any help would be appreciated.
In case anyone is interested, I've solved this issue by using the formula in the Select action, instead of an additional action in the flow: