cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Capuchino
Helper I
Helper I

Combobox using if and 2 differents data source

Hello, 

 

I am trying to build a combobox with an If Statement, however it doesn't work as I have data coming from 2 different data source. 

 

Both formula of the if statement works separately but not together. 

 

is there a solution?

 

If(ToggleShipFrom.Value=false, Filter('REPORTING.V_IBP_POSSIBLE_LOC_REPUNIT', DESTPLANTDESCR= CBShipto.Selected.Result).SOURCEPLANTDESCR, RenameColumns('REPORTING.M_IBP_LOCATION'.LOCDESCR , "LOCDESCR", "Result"))

1 ACCEPTED SOLUTION

Accepted Solutions

I found the solution, the 2 column needed to have the same name

 

Capuchino_0-1656581089880.png

 Thanks @Anonymous  for your help !

View solution in original post

10 REPLIES 10
Anonymous
Not applicable

Tried this out. You can use collections to solve this. So, if you have a toggle, you can add to OnChange:

ClearCollect(List1, Source1.item)

ClearCollect(List2, Source2.item)

 

Add any filtering you need, so you get the items you require.

 

Then the combobox items would be:

If(ToggleShipFrom.Value=false; List1; List2)

 

Remember to add those collections also in Screen1 (or whatever screenname you have) -> OnVisible, so you'll have the collections ready when the app is started. The collections are updated with the toggle.

Hello @Anonymous , 

 

Thank you for the idea... unfortunatelly it doesn't work. The combobox is still blank. Any other idea ?

 

Thanks in advance, 

Capucine 

Anonymous
Not applicable

It works for me. Maybe I explained it badly. Here's a more descriptive tutorial:

 

toggle1.PNG

Code for my toggle. As you can see, i'm getting data from two different sources. The point is to get one column of data from that source and make it a collection. In my case, i'm getting a column called "Title" from one source and a column called "KP" from another source.

 

 

combobox1.PNG

Code for my combobox. I simply check the value of the toggle, and fetch the collection (List1 and List2) based on the value.

 

 

true1.PNG

End result, if the toggle is "true".

 

 

false1.PNG

End result if the toggle is "false".

 

Hope this helps!

Hello, 

 

thanks for the detailed explication...  however it is still not working for me please find bellow the screen shot : 

 

Capuchino_0-1656574037343.png

 

Capuchino_1-1656574079862.png

 

Capuchino_2-1656574106728.png

 

Anonymous
Not applicable

Thanks for the pictures! If you go to File -> Collections, what data is showing in List1 and ListFull?

Anonymous
Not applicable

Nevermind, I think I know where the problem is. The problem is with this code:

Filter('REPORTING.V_IBP_POSSIBLE_LOC_REPUNIT', DESTPLANTDESCR= CBShipto.Selected.Result)

 

Power Apps is expecting a text, but that is not a text value. You can get around this by setting the selected result as a variable. So, select CBshipto combobox (or dropdown) and change the code in OnChange to this:

 

Set(ShipTo; CBShipTo.Selected.Value)

 

Then change the previous code to:

Filter('REPORTING.V_IBP_POSSIBLE_LOC_REPUNIT', DESTPLANTDESCR= ShipTo)

 

I think that will fix this.

 

 

Capuchino_0-1656579291500.png

Capuchino_1-1656579317161.png


Here are the 2 screen shot 

 

This is not fixing the problem...  CBShipto.Selected.Result is a text 

Capuchino_0-1656580257019.png

 

And If use only this formula it is working for my Combobox 

 

Capuchino_1-1656580494731.png

 

 

I found the solution, the 2 column needed to have the same name

 

Capuchino_0-1656581089880.png

 Thanks @Anonymous  for your help !

Helpful resources

Announcements
Power Apps News & Annoucements carousel

Power Apps News & Announcements

Keep up to date with current events and community announcements in the Power Apps community.

Community Call Conversations

Introducing the Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Apps Community Blog Carousel

Power Apps Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Top Kudoed Authors
Users online (2,737)