Hello,
I have a list with tasks where each task is assigned to a project (number) - there might be several tasks with the same project number. This list is being created/refreshed daily from an external source (through API). I would like to create another list with a column showing individual project numbers (without any reoccurrence) and keep updating the project list - only adding new project numbers that are not present from the original task list.
Please would any one be able to help and suggest possible flow.
Kind Regards,
Ajwou
@ScottShearer Thank you very much. It works really well. I was previously setting the column properties in the target list to enforce unique values and it worked, however wasn't sure whether that's the best way to do it. Thank you again.
There are a few ways to achieve your goal - see my example below for one solution. Please note the single quotes around Project in the filter query. Let me know if you have any questions.