Answered

Filter choices based on lookup

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hello!

I'm currenty using a combo box which has a choices() value in it, the thing is that I would like to filter the value it shows based on conditions. For example:

Currently my items selection is

Choices('Ajuste sueldo'.Proyecto)

But I want to filter this value, Proyecto is a lookup column from another list which on it it has a People column. I want on this combo box to appear only the Projects that the person using the app has, I thought using a lookup inside a choices column, but i cant manage to resolve it, something like this:

Choices(
 LookUp(
 'Ajuste sueldo';
 varUser in Proyectos[@'Delivery Manager']
 ).Proyecto
)

But it throws me an error saying I cant use Metadata values (referring to Proyectos[@...]

Anyone could give me a hand?

Thanks!

Categories:

Building Power Apps

I have the same question (0)

All responses (8)

Answers (1)

Sort by

JR-BejeweledOne 5,836 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!
Try something like this:

AddColumns(Filter('Ajuste sueldo', 'Delivery Manager' = varUser), "User Proyecto", Proyecto)

"User Proyecto" is the name of the column you are adding. You can call it anything you like. This is the column you will use for your ComboBox.

It is filtering the list 'Ajuste sueldo' based on if the 'Delivery Manager' column equals varUser.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks for the reply!
I dont have any column in Ajuste Sueldo called Delivery Manager, should i replace Ajuste sueldo with Proyecto? And second, Delivery Manager is a people column that accepts multiple values, that '=' should be replaced with an in?

Was this reply helpful? Yes No
JR-BejeweledOne 5,836 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!
Ajuste sueldo is the name of your list, yes? For Delivery Manager:

AddColumns(Filter('Ajuste sueldo', varUser in 'Delivery Manager'), "User Proyecto", Proyecto)

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

I have a list called Ajuste sueldo, that list has a lookup column (Proyecto) linked to another list, called Proyectos, that list has the delivery managers asigned to each project (so it has a column called 'Nombre Proyecto' and another one called 'Delivery Manager'), I want in my combobox to show a list of the Projects the person using the app has assigned.
Am I being clearer now?

Was this reply helpful? Yes No
JR-BejeweledOne 5,836 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

I just needed to verify that this was the list with the lookup column. No you shouldn't need to replace it. This is something I had already done in one of my apps. The information I provided is based on that.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Okay, but if I use it like you send it to me, it says that the column Delivery manager is not recognized, and I believe it is because its not on 'Ajuste sueldo', its on 'Proyectos' list

Was this reply helpful? Yes No
Verified answer

JR-BejeweledOne 5,836 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

I am not sure it's going to work the way you want. It might be easier to just add Delivery Manager as another lookup column in 'Ajuste sueldo'

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!

Okay! I will do that! Thanks for your help!

Was this reply helpful? Yes No