You’re offline. This is a read only version of the page.
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)
Pleas help me realise this within the 2 Form Drop Downs
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.
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:
Share
Report
All responses (
Answers (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.
#1
mmbr1606
22
Super User 2025 Season 1
#2
stampcoin
17
#3
ankit_singhal
11
Super User 2025 Season 1
