Unanswered

Filtering a choice field in a form

(0) Share

Report

Posted on by armiv

Hello,

I have such a situation where every Person is asigned some Legal Entitities. In this case John is assigned Legal entity A and B.

The field 'Same data Entities' is a multiple choice field, containing the names of all possible entities from A - Z.

I am showing all this information in a form in Power Apps and I want to show in the combo-box for 'Same data Entities' only the entities relevant to the user, i.e John should only be able to see either A or B.

How can I filter in a choice field, is iteven possible to filter it?

Thank you in advance.

Categories:

Building Power Apps

All responses (15)

Answers (0)

Sort by

M_Ali_SZ365 1,110 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @armiv ,
Certainly! To filter the choices in a combo-box based on the user's assigned entities, use the Filter function. Assuming your entities are stored in a data source, like a SharePoint list, and the assigned entities for each person are in a field named AssignedEntities, the formula for the combo-box Items property would be:
Filter('YourEntityDataSource', "A" in AssignedEntities || "B" in AssignedEntities)
Replace 'YourEntityDataSource' with the actual name of your data source. This formula filters the choices to show only entities "A" and "B" if they are assigned to the user.
Fuel our success! 🚀 Give a thumbs up and click 'Solution Accepted' to supercharge our community. Your actions speak volumes!
Warm regards,
Muhammad Ali
AARON_C 2,235 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @armiv,

I have created a collection to do this (create the collection anywhere you like, maybe on the OnVisible of the screen your form is on.)

ClearCollect(populateComboBox, Filter('Letter of representation', 'Person Id Information' = First(Split(User().FullName, " ").Value).Value).'Legal entity information' )

Then for the Items property of your combo box place in: populateComboBox

Please tick Accept as solution if the answer is useful.
Thanks,
@AARON_C
armiv 27 on at

Like
a
(0)

Report
Copy link

Link copied!

This would only work for one user and if I know for sure which Legal Entities they are assigned to. It needs to be dynamic since I have areound 400 users.
armiv 27 on at

Like
a
(0)

Report
Copy link

Link copied!

Unfortunatelly it is not workinf for me, since after the Filter I cannot assign any other value:
M_Ali_SZ365 1,110 on at

Like
a
(0)

Report
Copy link

Link copied!
@armiv ,
Hi Try this
Filter('YourUserEntityMappingDataSource', UserField = User().Email).AssignedEntities
Fuel our success! 🚀 Give a thumbs up and click 'Solution Accepted' to supercharge our community. Your actions speak volumes!
Warm regards,
Muhammad Ali
AARON_C 2,235 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

@armiv

Are you not filter your combo box by the 'Person Id Information' column which is the First name of the logged in user? and not by the email.

Please copy the code from my first post and place it into the OnSelect property of a button, then click on the button to create the collection. Then for your combo box please change the Items property to be populateComboBox.
armiv 27 on at

Like
a
(0)

Report
Copy link

Link copied!

I am filtering per email, I could also filter by the 'Person Id Information', that is not a problem, the issue is that my Filter formula doesn't work in the way you have explained.
When I am not putting a dot after the Filter formula, it does not show any error:

Am I doing something wrong?
armiv 27 on at

Like
a
(0)

Report
Copy link

Link copied!

Unfortunatelly my Filter formula gives an error if I try to put a dot in the end to continue the logic:
AARON_C 2,235 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

@armiv

Try and put the filter inside of the ClearCollect function.

That is because there are no other parameters that it is expecting. As you are just using filter it is only expecting the data source and the filtering logic.

Whereas the code I provided is expecting more parameters because I also used the First and Split functions inside the filter function.
armiv 27 on at

Like
a
(0)

Report
Copy link

Link copied!

I think I did all you explained. I created a button and put the code you shared with me on OnSelect:
But still, as soon as I try to put a dot after Filter it goes on error. Without the dot it doesn't show errors.