Hi @Anonymous ,
Could you please share a bit more about your issue?
Do you mean that you could not get all available values within the ComboBox?
Based on the formula that you provided, I could not find any syntax error with it. Please modify your formula as below:
Filter(
'[dbo].[BIT_Addresses]',
code in '[dbo].[BIT_Planning]'.'Load./disch.' || code in '[dbo].[BIT_Planning]'.To || code in '[dbo].[BIT_Planning]'.From
).name
then check if the issue is solved.
In addition, please also take a try to save your two SQL Tables records into two separated collections, then use the Collections as data source within your app instead of Original SQL Tables. Please take a try with the following workaround:
Set the OnStart property of the App control or set the OnVisible property of the first screen of your app to following:
ClearCollect(
PlanningCollection,
'[dbo].[BIT_Planning]'
);
ClearCollect(
AddressCollection,
'[dbo].[BIT_Addresses]'
);
Then modify your formula as below:
Filter(
AddressCollection,
code in PlanningCollection.'Load./disch.' || code in PlanningCollection.To || code in PlanningCollection.From
).name
please take a try with above formula, then check if the issue is solved.
Best regards,
