DropDown Control contains data from multiple datasource

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hello Teams,

Hope you all are doing great! Going through the issue which I am facing currently,

Note : Both have a different data source.

Here I have 2 dropdown control. For example, All roll number we have 1 to 50 Numbers. Roll No have only one record '50'. Now what data I need for roll no, If both data source have some common number (in our case '50'). Then it will cut that number and display 1 to 49 records in roll number.

Summary is if both datasource share common no then I don't want to show that no and display rest of all numbers in my dropdown list.

Thanks in Advance!

Regards,

Bansari Pandya.

Categories:

Building Power Apps

All responses (4)

Answers (1)

Sort by

Vijay Tailor 2,961 on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @Anonymous ,

Please Find the solution for your Issue.

Formula - For Filter

If(Last(Coll2).Value=Last(Coll1).Value,FirstN(Coll2,CountRows(Coll2)-1),Coll2) //Coll1 - First Source //Coll2 - Second Source

See the Demo below
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

@VijayTailor
Sorry but you can not understand my question. It's not fix that for roll no I need 1 to 49 number.

For example, I add '23' in my "Roll No" data source. So dropdown display 1 to 50(accept '23' and '50'). Hope now you understand my question and give a solution.

Thanks in advance!
Verified answer

v-siky-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Anonymous ,

Let's say ‘Roll Number' and 'All Roll Number' are the data source of two dropdown, and Number is the field name, so the code should be:

Filter('All Roll Number', Not(Number in 'Roll Number'.Number))

If this doesn't make any sense, please share the detailed information to help us understand your scenario.

Sik
Vijay Tailor 2,961 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Anonymous ,

See the solution for your Issue,

The concept is the same as I mentioned in my previous post, just you need to tweak the code as per your need.
But no issue, I tried the solution for your Need.

As per my understanding if you select any value from first Combobox then selected the value in First Combobo and Last same value not present in the second Combobox.

See the Demo gif.
See the New Formula -
If(Last(Coll2).Value=Last(Coll1).Value,Filter(FirstN(Coll2,CountRows(Coll2)-1),Value <> ComboBox13.Selected.Value),Coll2)

Thanks,
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."-Vijay