
Hi,
I'm creating a flow that will send an equipment request email when a powerapps form is submitted/list is updated. I have automate adding a row to a table (this step is due to the way it's being developed and is temporary) and some of the cells using vlookup to check for a part number in a different table. In the request email, I'm trying to evaluate to see if the result of the vlookup is listed as '#N/A' and if so, use a generic descriptor, if not, use value in the cell. However, the expression 'if(equals(items('Check_for_new_item_and_add_PN')?['MonPN'],'#N/A'),foo,bar) always evaluates to False. Any ideas?