dropdown filter for multichoice sharepoint column

(0) Share

Report

Posted on by patels11

Dear All,

i have list with project names and lead names along with team member.

List name : Admin_Project_list

Column Name : "Project Team"

in powerapp there is one dropdown.when user login then based on logged in users email ,dropdown filter names of project in which users name is thre as project team member, but as it is multichoice column so it is giving Delegation error. Any possbilesollution ?

Categories:

Building Power Apps

I have the same question (0)

All responses (11)

Answers (3)

Sort by

Verified answer

WarrenBelz 156,456 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @patels11 ,

The top filter needs to return under your Delegation limit for this to fully work

With( { wList: Filter( gAdmin_Project_List, 'Piping Lead'.Email = User().Email || 'Stress Lead'.Email = User().Email || 'Stress Team Member'.Email = User().Email ) }, Filter( wList, User().Email in 'Piping Team Member'.Email ) )

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Visit my blog Practical Power Apps

Was this reply helpful? Yes No
patels11 41 on at

Like
a
(0)

Report
Copy link

Link copied!

This resolved issue. but it generated error in gallery which was filtered out based on selection in dropbox. in gallery, for that particular project name selection it popsup 4 values, project piping lead name, piping team member, stress team name and stress team members. not it is showing error in place where it was showing name of piping team member. i guess this need to be changed to accomodate multiple names. if u can help. thanks in advance.

Was this reply helpful? Yes No
WarrenBelz 156,456 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @patels11 ,

That is because it is a multi-select field and contains a Table. If you want the values separated by commas

Concat( ThisItem.'Piping Team Member’, Email & "," )

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Visit my blog Practical Power Apps

Was this reply helpful? Yes No
patels11 41 on at

Like
a
(0)

Report
Copy link

Link copied!

this sollution was working fine yesterday but from today its not working. i dont know why. everything is same no changes. can u please help ?

Was this reply helpful? Yes No
WarrenBelz 156,456 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @patels11 ,

You have no errors there - how many items are in your list ?

Was this reply helpful? Yes No
patels11 41 on at

Like
a
(0)

Report
Copy link

Link copied!

no there is no errro but when i select dropdown nothing shows. filter returns no value. i have 5 names as team member in particular project.

Was this reply helpful? Yes No
WarrenBelz 156,456 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

@patels11 ,

Yes, but how many records are in 'Admin_Project_List' and is (as I assumed) 'Piping Team Member' a multi-select Person field ?

Was this reply helpful? Yes No
patels11 41 on at

Like
a
(0)

Report
Copy link

Link copied!

only 1 line record as only 1 project data is available. out of all column only 'piping team member' is a People type column with "Allowed multiple choice".

Was this reply helpful? Yes No
Verified answer

WarrenBelz 156,456 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
@patels11 ,

Actually I will need to change that as only the bottom filter will work - you are back to having your Delegation issue unfortunately - there is no Delegable solution to an Or() filter (the structure I posted only works on And() arguments)

Filter( gAdmin_Project_List, 'Piping Lead'.Email = User().Email || 'Stress Lead'.Email = User().Email || 'Stress Team Member'.Email = User().Email || User().Email in 'Piping Team Member'.Email )

Was this reply helpful? Yes No
patels11 41 on at

Like
a
(0)

Report
Copy link

Link copied!

i have changed code little bit to make it work.
Filter(
Admin_Project_List,
'Piping Lead'.Email = User().Email ||
'Stress Lead'.Email = User().Email ||
'Stress Team Member'.Email = User().Email ||
User().Email in Concat('Piping Team Member',Email,",")
)

now i just need your 1 last small help. after gettting project name this label get the string of email ids of all team member with Comma. what i wanted to do is in text property i want yes or no as a plain text, means if loged in users name is in string then text will be yes otherwise no.

Thanks in advance.

Was this reply helpful? Yes No