Answered

Filter Dropdown in Custom Form

(1) Share

Report

Posted on by MS-03101913-0

I have 3 lists.

Apps – Title
Apps User List – User, Apps (linked to the Apps – can have multiple apps selected) list
Request – Apps (linked to Apps – can have multiple apps selected), Request Description; I want to customize the input form for the request and only show the apps the user is “assigned” in the Apps User List.

When making a Request I want to filter the Apps dropdown based on the apps the user is eligible for:

Originally the Apps field has this for the items:
Choices([@Request].Apps)

Tried this

Filter('App User List', User.Email = User().Email)

How do I get the dropdown for apps to display just the apps that the user is eligible for from the Apps User List?

Categories:

Power Apps Pro Dev & ISV

I have the same question (0)

All responses (13)

Answers (1)

Sort by

WarrenBelz 155,315 Most Valuable Professional on at

Like (2)

Report
Copy link

Link copied!
Hi MS-03101913-0

I am not totally clear on which list you want to filter here, but I have guessed it is 'App List'. The complexity is mainly to give the code some Delegation capacity (it could be done simpler if this was not required).
With( { _Apps: LookUp( 'App User List', User.Email = User().Email ) }, Ungroup( ForAll( _Apps As _A, Filter( 'App List', Title = _A.Apps ) ), Value ) )

Please click Does this answer your question 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 a Like.
MVP (Business Applications) Visit my blog Practical Power Apps Buy me a coffee

Was this reply helpful? Yes No
MS-03101913-0 71 on at

Like (1)

Report
Copy link

Link copied!

Thank you for your reply. We're almost there.

I don't understand the Ungroup part of the code.

I want to filter the selections for the App in the Request Input form based on the logged in user and the apps they are eligible set in the App User List.

Was this reply helpful? Yes No
WarrenBelz 155,315 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!
Where are you using this and what is the error ?

The With() statement should output a Record which has a Table (multi-value choice) field Apps containing the list of Apps the user is eligible for.

The bottom complexity is only for Delegation management - it loops through the Apps field and finds the matching records from 'Apps List' with individual Delegable filters You then need to Ungroup the Table field Value that each loop output is contained in.

If you are not worried about Delegation, simply look for all instances of the top filter Apps field contained in the Title field of 'App List' (although I still do not understand the reason for the error if this is what you are trying to filter).

With( { _Apps: LookUp( 'App User List', User.Email = User().Email ) }, Filter( 'App List', Title in _Apps.Apps ) )

Please click Does this answer your question 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 a Like.
MVP (Business Applications) Visit my blog Practical Power Apps Buy me a coffee

Was this reply helpful? Yes No
MS-03101913-0 71 on at

Like (1)

Report
Copy link

Link copied!

Closer... it's still barking at the formula, but when I run the form it's returning all the items in the App List.
I'm using it in the items field of the dropdown of Apps in the Request form.

The request list/form has 3 fields
Apps - linked to the App List - but I only want to display the apps the user is assigned from the App User List
Notify Manager
Description of why the person needs to make this request.

I was thinking this would work:
Filter('App List', Title in LookUp('App User List', User.Email = User().Email).Apps)
But I get this:

I think this is the delegation thing you were referring to.

Was this reply helpful? Yes No
WarrenBelz 155,315 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!

What type of field is Apps in 'App User List' ? If it is a Lookup column, you need _A.Apps.Value

Was this reply helpful? Yes No
Verified answer

MS-03101913-0 71 on at

Like (1)

Report
Copy link

Link copied!

I tried the . at the end but it didn't pull any intellisense so I didn't follow through with it. It looks like it is limiting it but when I run the form and click the drop down it is showing all the items:

Was this reply helpful? Yes No
WarrenBelz 155,315 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Apart from the Delegation issue (which you cannot avoid), I assume this is now solved ?

Was this reply helpful? Yes No
MS-03101913-0 71 on at

Like (0)

Report
Copy link

Link copied!

Hi Warren,

Unfortunately it is not resolved. I'm still getting the full list of the apps in the drop down. It's not filtering per the user and the apps that the user is eligible for.

Check my last post with the drop down screen shot (shows all 5 apps in the list) and also the screen shot in the development window, when hovering over the code the quick peek of the results IS filtering to the users' eligible apps.

Mike-

Was this reply helpful? Yes No
WarrenBelz 155,315 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hi MS-03101913-0 ,

The fact that the code window is showing the desired results (as it should) sort of eliminates the code. Are you using a Classic or Modern Combo Box ?

Was this reply helpful? Yes No
MS-03101913-0 71 on at

Like (0)

Report
Copy link

Link copied!

This is a customized SharePoint form so it is using the Classic Combobox.

I added a Drop Down control, but it doesn't have a display fields property to set the text of the dropdown in the data source.
When I run the form with the same code in items I get what appear to be 3 items in the drop down but I can't see the values.

It wants me to configure the "depends on", but when I do it changes the items property and then doesn't work.

Was this reply helpful? Yes No