Skip to main content

Notifications

Power Automate - General Discussion
Answered

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

(0) ShareShare
ReportReport
Posted on by

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

  • Ajwou Profile Picture
    Ajwou on at
    Re: Creating and updating a list based on the data (column) in another list

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

  • Verified answer
    ScottShearer Profile Picture
    ScottShearer 25,150 on at
    Re: Creating and updating a list based on the data (column) in another list

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

    image.pngimage.pngimage.pngimage.png

     

     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,343

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,703

Leaderboard