Combobox using if and 2 differents data source

[Capuchino]

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"))

[v-qiaqi-msft]

Hi @Capuchino，

Glad that you have resolved your problem.

Could you please mark your reply as solution?

Thanks for your cooperation.