Check if a string exists in a table

[Antonioclk]

Hello I have a table which gets filled based on a gallary. 

the Items property of my DataTable is the following

Distinct(UserList.AllItems.Role,Role)

when clicking a button i want to check if a certain string is present in that table. 

I tried with Lookup(Table, ThisRecord="manager") but it gives me a incompatible type error. Seems like my condition isn't fine... how can i fix it? how can i check if the string "manager" is present in one of the records of the table?

thanks

[cmitchener]

Can the string appear anywhere in the table, or are you only looking in a certain column?

[Antonioclk]

i only have one column, so anywhere is fine aswell

[cmitchener · Accepted solution]

Ok, so PowerApps works a bit strangely; and this is something I fumbled over for a while. Instead of trying to check the table, you want to check the data source directly. What I do is I take the table's Items property (usually a collection or the list name that has been filtered down), into a CountRows with a filter and that should yield the proper result. If you place this into a textbox and you wouldn't even need a button, as it would update real-time. You could try something like this:

CountRows(

   Filter(

      dataSource,

      Find(textValue, column)

   )

);

A few notes:

• In short, this code filters the data source down to match your criteria, then counts the number of records that match
• dataSource would be the Items property of the table (so if the table is already filtering, those filters are still applied)
• textValue is the text you are searching for (you could make this reference a text input, where you could type in the value you are searching for.
• column is the column you would be searching

Let me know if this helps or if it confused you more and/or didn't work.

[Antonioclk]

great it was super clear and it works! thank u so much

[cmitchener]

Sure thing!

[rj0435]

This was excellent Cheers! 

[IswaryaPari]

Thanks a lot it works me Great idea!

Additionally my suggestion if you want exact match try this

CountRows(

   Filter(

      dataSource,

      Find(Lower(textValue), Lower(column))

   )

);

[cmitchener]

@IswaryaPari I was going to send this exact thing as an update; thanks!