cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper III
Helper III

Re: Save Filtered Lookup Value in List Custom Form

@gujjaL 

 

my solution works with multiple selection for dropdown. 

 

 

Highlighted
Frequent Visitor

Re: Save Filtered Lookup Value in List Custom Form

It saves only one value . For example if I select "a","b" 

the value saved in SP is "a" only.

Highlighted
Helper III
Helper III

Re: Save Filtered Lookup Value in List Custom Form

In my app, there are 2 items saved. 

 

Filter(Choices('CMT Niv 2'.B_TO1_cmt2);Value in Filter(gebruikers; Diensten.Value = "CMT Niv2").'Naam Gebruike')

 

The first part are the items of the dropdown of a the lookupcolumn: Choices('CMT Niv 2'.B_TO1_cmt2)

 

Then you start to filter, based on the value (in my case the departmentvalue in "diensten") in a column of the other sharepointlist (my list of users = gebruikers) with result the usernames of the namecolumn (naam gebruike)

Highlighted
Frequent Visitor

Re: Save Filtered Lookup Value in List Custom Form

Filter(Choices('CMT Niv 2'.B_TO1_cmt2);Value in Filter(gebruikers; Diensten.Value = "CMT Niv2").'Naam Gebruike')

 

CMT Niv 2-- Is this a sharepoint list?

gebruikers--Is this a sharepoint list?

Diensten,Naam Gebruike'-- are these column of gebruikers list

Highlighted
Helper III
Helper III

Re: Save Filtered Lookup Value in List Custom Form

Filter(Choices(sharepointlistname.columname);Value in Filter(sharepointlistname; columnname.Value = "CMT Niv2").columnname)

Filter(Choices('CMT Niv 2'.B_TO1_cmt2);Value in Filter(gebruikers; Diensten.Value = "CMT Niv2").'Naam Gebruike')

 

sharepointlistname.columname: this is the list and column that is attached to the form (where the data has to be stored)

 

sharepointlistname: this is the listname where the lookupcolumn looks his data up. (the big users list) 

 

Columnname in pink sharepointlist (big userlist with columns for the names, phonenumber and department) this column is the department

 

Columnname in pink sharepointlist (big users list) . This is the column with the name of the user. 

 

With this formula. I filter the items of a lookupcolumn   so i have only the names of the department "CMT Niv2" 

 

How do you would like to filter your dropdown in the form? 

 

 

 

Helpful resources

Announcements
Check this Out

Announcing

Class of 2020- Season 2

Check this Out

Helpful information

Featuring samples like Return to the Workplace and Emergency Response Applications

August 2020 Community Challenge: Can You Solve These?

August 2020 Community Challenge: Can You Solve These?

We're excited to announce our first cross-community 'Can You Solve These?' challenge!

secondImage

Return to Workplace

Reopen responsibly, monitor intelligently, and protect continuously with solutions for a safer work environment.

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors
Users online (8,390)