Filter On Lookup Column

(0) Share

Report

Posted on by Ianhall1892

168

I'm trying to filter a gallery based on the value set in lookup column in a SharePoint Library. Is this possible?

Cheers

Ian

Categories:

Building Power Apps

I have the same question (0)

All responses (10)

Answers (1)

KrishnaV 5,023 on at

Like (0)

Report
Hi @Ianhall1892,

Yes it is possible try the below:

Filter(SPListName,lookupcolumnname.value="test") ex: Filter(SampleList,'LKP Column'.Value="Anand")

I hope this resolved your issue if you see any challenge/need further help let me know I am always happy to help.
Regards,
Krishna
If this post helps give a 👍 and if it solved your issue consider Accept it as the solution to help the other members find it more.

Was this reply helpful? Yes No
Ianhall1892 168 on at

Like (0)

Report

Hi,

Already tried that dosent seem to work

cheers

Ian

Was this reply helpful? Yes No
KrishnaV 5,023 on at

Like (0)

Report
Hi @Ianhall1892 ,

I have changes the formula with .Value I hope you used without that because I see it is working seamlessly:

Filter(SPListName,lookupcolumnname.value="test") ex: Filter(SampleList,'LKP Column'.Value="Anand")

I hope this resolved your issue if you see any challenge/need further help let me know I am always happy to help.

Regards,
Krishna
If this post helps give a 👍 and if it solved your issue consider Accept it as the solution to help the other members find it more.

Was this reply helpful? Yes No
Ianhall1892 168 on at

Like (0)

Report

Hi,

Yes sorry single value does work. I'm trying to do it where the column is multi value.

Cheers
Ian

Was this reply helpful? Yes No
KrishnaV 5,023 on at

Like (1)

Report
Hi @Ianhall1892,

I agree because multi selection will give it as a table:
Filter(SampleList,"Anand" in Concat('LKP Column'.Value, Concatenate(Text(Value),", ")))

I hope this resolved your issue if you see any challenge/need further help let me know I am always happy to help.
Regards,
Krishna
If this post helps give a 👍 and if it solved your issue consider Accept it as the solution to help the other members find it more.

Was this reply helpful? Yes No
KrishnaV 5,023 on at

Like (0)

Report

Hi @Ianhall1892 ,

I just want to followup on this.

If you see any challenge/need further help let me know I am always happy to help.

Regards,
Krishna
If this post helps give a 👍 and if it solved your issue consider Accept it as the solution to help the other members find it more.

Was this reply helpful? Yes No
v-xida-msft on at

Like (1)

Report
Hi @Ianhall1892 ,

Do you want to filter your Gallery Items based on the LookUp field in your SP Library?

Please take a try with the following formula:

a. Single value of LookUp field:

Set the Items property to following:

Filter('Your SP Library', LookUpColumn.Value = "Specific Value")

b. Multi-Value of LookUp field:

Set the Items property to following:

Filter('Your SP Library', "Specific Value" in LookUpColumn.Value)

Note: Above formula may cause a Delegation issue, if the amount of your SP Library records is not more than 2000, you could ignore this warning issue. Please make sure set the "Data row limits for Non-Delegable queries" to maximum value -- 2000 within Advanced settings of App settings of your app.

Please take a try with above solution, then check if the issue is solved.

Best regards,

Was this reply helpful? Yes No
Ianhall1892 168 on at

Like (0)

Report

Hi
Thanks for the solutions both worked. I want to hide the gallery if the filter choice dose not exist in the Library. Can this be done with a variable?

Was this reply helpful? Yes No
Verified answer

v-xida-msft on at

Like (0)

Report
Hi @Ianhall1892 ,

Do you want to hide the Gallery if the filter choice ("Specific Value") is not existed in your SP Library?

Based on the needs that you mentioned, I think the variable could achieve your needs. You could consider store the specific filter choice value into a variable, called "FilterChoice", then you could use the FilterChoice variable in the Filter function I mentioned above:

Filter('Your SP Library', FilterChoice in LookUpColumn.Value)

If you want to hide the Gallery if the filter choice ("Specific Value") is not existed in your SP Library, please take a try with the following workaround:

Set the Visible property of the Gallery to following:

If( IsEmpty(Filter('Your SP Library', FilterChoice in LookUpColumn.Value)), false, true )

Please take a try with above solution, check if the issue is solved.

Best regards,

Was this reply helpful? Yes No
KrishnaV 5,023 on at

Like (0)

Report

Hi @Ianhall1892 ,

I see that you mentioned that it would for you would you mine mark the reply as a solution.

Regards,
Krishna

Was this reply helpful? Yes No