I have a table that’s a list of tasks for clients. Grouped by client. How come that I got two groups for the same client? [image] And no, those aren’t two different rows — it’s the same client. Hint: some tasks were entered manually with client being selected from a drop-down list. And the other…

Not sure if this is what you’re getting at, but it seems similar, anyway: Manually entered tasks with client selected from drop-down list = single row. “Current client” field returns a list of some kind (e.g., Filter(), Lookup(), etc). Tasks created by button copy the list-of-one value to the clie…

Here’s a riddle for the community

Denis_Peshekhonov July 15, 2019, 4:31pm 9

Cool. Thats why we need FilterFirst() function

Topic		Replies	Views
Copying data from table to table... and avoiding lists of lists	2	937	April 30, 2020
Selecting more than one option in Multiselect List empties data from formulas using the selection	4	1726	May 20, 2020
The never ending saga of look-up vs select lists, and more potential differences	9	2559	December 12, 2019
Lookups, different results, different input methods?	21	2853	September 26, 2021
Bug: switching from Lookup column type to List column type doesn't remove references to the rows from the lookup source table Bugs	2	891	August 20, 2020

Here’s a riddle for the community

Related topics