cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
HannesV
Frequent Visitor

Filter Choice Dropdowns based on foreign SPO lookupcolumn

Hello togehter, 

 

I am Struggeling in a Problem

i have 3 SPO Lists

First List is my a Invoice inbound list wich should be manged within a Powerapp (Canvas) 

Columns:

1 Lookup Column to the Budget List,

1 Lookup Column to a Supplier List.

 

The Powerapps Form uses Dropdowns for these 2 columns.

 

Now i was trying to reduce the form dropdown itmes for the budged selection based on the selected  Supplier.

The realise this a have a SPO Lookup Columns added on the Budged List where i can add multible Suppliers.

 

 

A was able to realise the list reduction useing DataTables, but not within the form.

 

Datatable with SPO Budgets shows only Budges which Supplier Column contains the Suppplier lookup

items:

Filter(SPOBudgets,((DTsupplier.Selected).ID) in Supplier.Id)

 

Datatable with a selected Supplier 

DataCardValue14 is the form selector for the supplier to filter the Datatable

If(DataCardValue14.Selected.Id<>Blank(),Filter(SPOSupplier,ID = DataCardValue14.Selected.Id),Supplier)

HannesV_1-1637864578734.png

 

 

 

Pleas help me realise this within the 2 Form Drop Downs

 

HannesV_0-1637864294005.png

 

 

 

 

 

3 REPLIES 3
HannesV
Frequent Visitor

Here is some data model visualisation on my question.

HannesV_0-1637908471267.png

 

 

Hi @HannesV ,

 

Based on your description, you have added a LookUp column in the Budget list to look up from the Supplier list and it allows multiple selections, so actually the two lists are with a N:N relationship, the relationship diagram in your reply is not correct. As you would like to show budget selections in the dropdown according to the selected supplier, why not create a LookUp column in the Supplier list and look up from the budget list (allow multiple selections as well)? Once this operation is done, you could simply LookUp the Supplier list as the Items of the budget dropdown, using the criteria in the formula as follows:

LookUp(Supplier, Title = SupplierDD.Selected.Title)

 

If using LookUp column in the Budget list, as suppliers will be allowing multiple selections, in your case you will absolutely encounter the delegation issue which will hardly to work around.

 

Hope this helps.

 

Best regards,

Community Support Team _ Jeffer Ni
If this post helps, then please consider Accept it as the solution to help the other members find it.

Community Support Team _ Jeffer Ni

If this post helps, then please consider Accept it as the solution to help the other members find it.

HannesV
Frequent Visitor

Hi @v-jefferni , 

you are absolutly correct. in result it is a N:N.

My thought was to have a Supplier to one Buget relation, so an accountant does not need to know which buget to assign, cause the "computer" does it for him. In most cases we already detect the supplier by his email domain. In case of many supplier we do not have a "default" budget.   

this is the general first step of invoice registration. 

 

the second step is a budget assignment / approval for an invoice by the budget responsible. 

I case of a budget responsible, we would like the budget responsible to managed his budged their self and therefore it would be nice to assign N Supplier on one budget. 

In case of an new Invoice (supplier known / budget unkown) the responsible could only assign budgets, which has this supplier assigned to. this would reduce the dropdown list enormouse case we have many many suppliert / budgets.

 

But i will try to give your suggestion a try, if i can realise it

Best regards. 

 

Helpful resources

Announcements
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

Power Platform Call June 2022 768x460.png

Power Platform Community Call

Join us for the next call on June 15, 2022 at 8am PDT.

PA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

This training provides practical hands-on experience in creating Power Apps solutions in a full-day of instructor-led App creation workshop.

PA.JPG

New Release Planning Portal (Preview)

Check out our new release planning portal, an interactive way to plan and prepare for upcoming features in Power Platform.

Users online (4,310)