Filter records based on part of string

(0) Share

Report

Posted on by panand99

641

Hi,

I want to filter records based on parts of the string which needs to compare from another collection. for ex,

Collection 1 - Having a field with value in SelectedDepartments like ["Management","Purchase"] ( this is single TEXT column having dquare brackets)

Collection 2 - Users having access to the departments

Department

Purchase

In collection 2, having a column 'Department' which is a single text field having 'Purchase' as a value in one record. (there can be multiple records on which user is a member of)

Now I want to filter records from collection1, where it needs to be show only records on which user member of from collection2.

Any help would be appreciated.

Thanks,

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (0)

rubin_boer 4,841 Super User 2024 Season 1 on at

Like (0)

Report
hi @panand99

Try

Filter( colYourSelectedDepartments, galYourDepartments.Selected.Department in Department )

Where Department is the selected department field where you store your slected departments.

Hope this helps

Was this reply helpful? Yes No
panand99 641 on at

Like (0)

Report
Hello @rubin_boer ,
Thanks for the response.

But this does not work, as I have couple of records in collection2. whereas you mentioned to use
galYourDepartments.Selected.Department

Was this reply helpful? Yes No
panand99 641 on at

Like (1)

Report

Hello @rubin_boer ,
Thanks for the response.

But this does not work, as I have couple of records in collection2. whereas you mentioned to use
galYourDepartments.Selected.Department

Was this reply helpful? Yes No
panand99 641 on at

Like (0)

Report

Hi @WarrenBelz @RandyHayes
May I request some help here.

Thanks,

Was this reply helpful? Yes No
v-jefferni on at

Like (0)

Report

Hi @panand99 ，

Could you please share more details about your scenario? How did you create the collection1? I think it would be better to use actual data as an example to explain.

Best regards,

Community Support Team _ Jeffer Ni
If this post helps, then please consider Accept it as the solution to help the other members find it.

Was this reply helpful? Yes No