cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

Check if all entries in a table column are the same

Ive been searching for a formula to check if all items in a given column in a table are identical. Eg:

 

COLUMN1

Apple

Apple

Apple

 

This situation would return 'true'

 

COLUMN2

Apple

Peara

Apple

 

This situation would return 'false'. 

 

I appreciate this is a pretty simple request, but I have no idea how to do it...ideas? Thanks. 

1 ACCEPTED SOLUTION

Accepted Solutions
mdevaney
Super User
Super User

@Anonymous
You can COUNTROWS of the unique entries in a column with this function. When it returns true the same value was used for the entire column.

CountRows(Distinct(your_datasource_name,your_column_name))=1

—-
Please Accept as Solution if this post answered your question so others may find it more quickly. If you found this post helpful consider giving it a Thumbs Up.

View solution in original post

2 REPLIES 2
mdevaney
Super User
Super User

@Anonymous
You can COUNTROWS of the unique entries in a column with this function. When it returns true the same value was used for the entire column.

CountRows(Distinct(your_datasource_name,your_column_name))=1

—-
Please Accept as Solution if this post answered your question so others may find it more quickly. If you found this post helpful consider giving it a Thumbs Up.
Anonymous
Not applicable

Aaagh, so simple! Why didn't I think of that? Thank you very much 🙂  

Helpful resources

Announcements
Power Apps News & Annoucements carousel

Power Apps News & Announcements

Keep up to date with current events and community announcements in the Power Apps community.

Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Power Apps Community Blog Carousel

Power Apps Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Top Kudoed Authors
Users online (5,089)