Hi Folks -
I have a need to leverage a ComboBox, but I need the list of values to be populated from (2) different data sources:
RD_Target_List & RD_Portfolio_Compound_List. From both tables, I need to display the "Alias" column. Another peices is there is another field in both SP tables called "Portfolio_Status" so I only want to display values from the Alias columns AND are not "Terminated" for the "Portfolio_Status" column.
I'm trying to play around with multiple galleries but can't quite seem to get anything to produce the results I want. Hoping some folks can shed some light for me, thank you!
have you considered working with a collection for your combobox values? Collect data from both of your data sources into that collection and use the collection as the items for the combobox. This is considering you don't have too many rows for each of those 2 sources.
On the OnStart statement of your app :
Filter(RD_Target_List ;Portfolio_Status= "Terminated");
And then, on your dropdown Items statement, you put ListElements
Hi Both - this worked like a charm!! However, since it's a dropdown box, i'm unable to search the list of values.
is it possible to make this a ComboBox? If so, what would I use as the data source?
Read the announcement for more information!
Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.
Features releasing from October 2019 through March 2020
Innovate, Collaborate, Grow - The top training and networking event across the globe for Microsoft Business Applications