Answered

Creating and updating a list based on the data (column) in another list

(0) Share

Report

Posted on by Ajwou

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

Categories:

General topics

I have the same question (0)

All responses (2)

Answers (1)

Sort by

Verified answer

ScottShearer 25,290 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!

@Ajwou

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.

Was this reply helpful? Yes No
Ajwou on at

Like (0)

Report
Copy link

Link copied!

@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.

Was this reply helpful? Yes No