I have a data table Schedule based on excel table Schedule_source. The 1st column is Agent_name and consists agents first name and last name. the rest of the columns are dates (1.03.2021, 2.03.2021 and so on) with shifts of each agent.
I also have a multiselection combobox Agent( items = Schedule_source.Agent_name).
I want the data table to only show schedule of the agents selected in the combobox. It only shows the last value added to the combobox. So when i add AgentA it shows AgentA in the table, When i add Agent B it shows only AgentB and not AgentA + AgentB
I've tried set data table items to items= search(schedule_source, Agent.selected.agent_name, "agent_name") it works for 1 selection but doesn't for 2 and more. I understand why but i cant figure out a way for it to work.
Solved! Go to Solution.
Check out new user group experience and if you are a leader please create your group
Check out how to claim yours today!
Test your skills now with the Cloud Skill Challenge.