ComboBox with 2 SharePoint List connection

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hello guys,

I need your help.

I have 2 Sharepoint List:

Approvals A and Approvals B

Both lists have the same column structure

Approvals A with columns Department X, Department Y, Department Z

Approvals B with columns Department X, Department Y, Department Z

In Powerapps I have a combobox which you can select Approvals A or B

And 3 other combobox for every Department:

Derpatment X - combobox, Department Y - combobox - Department Z - combobox

Now the problem is I`m not able to dynamically change the data for Department Y - combobox based on the ComboBox where user can select Approvals A or B.

The formula I put in for Items is: Switch(DataCardValue5.Selected.Value,"A",'Approvals A'.Department Y,"B",'Approvals B'.Department Y)

If I manually put one connection is working fine, but with formula is not.

Strangely it is working for Department X, I think because the name of the column was Title and I changed it

Thank you,

Alex

Categories:

Building Power Apps

All responses (3)

Answers (1)

Sort by

Verified answer

WarrenBelz 156,528 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @Anonymous ,

Dynamically setting the Items of a drop-down control are problematic at best, however you could do a Collection on the OnChange of your drop-down

ClearCollect( colDD, Switch( Self.Selected.Value, "A",'Approvals A'.Department Y, "B",'Approvals B'.Department Y ) )

Then the Items of the other control would be colDD (or whatever you wanted to call it).

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @WarrenBelz

Thank you for your response.
I tried your solution and it`s working just for Approvals A. I think because this was first selected and some automatically fields were completed for the combobox.
Even if I refresh the application and select first the Approvals B, it will not work, it shows blank fields.
I had the same problem also when I tried with formula in Items property.

Best regards,
Alex
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
I managed to get it done by adding a table and collect data from both sharepoint lists in it.
In both sharepoint lists I created one more column: ApprovalsColumn, filled with "A" and "B" for the second one, this will help to filter the data.

I put on application OnStart, this will populate table with data when the application starts.
ClearCollect( colDD, 'Approvals A' ); Clear( ForAll( 'Approvals B', Collect( colDD, { 'Department X': 'Department X', 'Department Y': 'Department Y', 'Department Z': 'Department Z', 'ApprovalsColumn': 'ApprovalsColumn' } ) ) )

And for the comboBox Item:
Filter(colDD,ApprovalsColumn=Switch(DataCardValue5.Selected.Value,"A",'Approvals A'.Department Y,"B",'Approvals B'.Department Y))

Thank you @WarrenBelz, your response gave me the idea.

Best regards,
Alex