Showing results for 
Search instead for 
Did you mean: 
Helper IV
Helper IV

Referencing an excel column from a condition

Hey all,


I have a form that captures 'Site ID" I'm trying to verify the Site ID from an excel sheet. I added List rows present in a table. 

Then made a condition if Site ID is equal to (table) Site ID.  It comes out false even if the Site ID is correct. Any idea how to fix this?



Super User
Super User

Hi @Charliemacdmv 


You have a condition, which expects you to compare two similar datatypes.  I would stick both of your dynamic values into a compose prior to your condition and then you can see what you are playing with and then you will realise why it isn't working. 


Your List rows will return an Array, if you are looking to search that array, you want to use a filter.  You can then add the "values" dynamic value from the list rows and compare the item()?['Site ID'] equals your form response.


Take a look here:


You can then use length and if the length is greater than 0, you know you have a match.


If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

P.S. take a look at my new blog here and like & subscribe to my YouTube Channel thanks 😉

Helpful resources

Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

May UG Leader Call Carousel 768x460.png

June User Group Leader Call

Join us on June 28 for our monthly User Group leader call!

MPA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

Power Automate Designer Feedback_carousel.jpg

Help make Flow Design easier

Are you new to designing flows? What is your biggest struggle with Power Automate Designer? Help us make it more user friendly!

Top Solution Authors
Top Kudoed Authors
Users online (2,121)