web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Question about using "...
Power Automate
Unanswered

Question about using "#N/A" value from table to check for true

(0) ShareShare
ReportReport
Posted on by 14

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?

Categories:
I have the same question (0)

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Automate

#1
trice602 Profile Picture

trice602 237 Super User 2026 Season 1

#2
David_MA Profile Picture

David_MA 176 Super User 2026 Season 1

#3
Power Platform 1919 Profile Picture

Power Platform 1919 96 Super User 2026 Season 1

Last 30 days Overall leaderboard