Skip to main content

Notifications

Power Automate - Building Flows
Unanswered

Update Secondary SharePoint list

(1) ShareShare
ReportReport
Posted on by 45
Hello guys,
 
I have 2 lists and created a calculated column in both, to create a unique key, by concatenating columns.
 
what I want: If I edit in list 1, automatically edit same item in list 2..
 
I tried everything but the flows is not working properly..
 
Here is the flow:
 
 
When it goes to the condition it always goes to false.. 
 
anyone know what is wrong?

Thanks
  • ferby2023 Profile Picture
    ferby2023 45 on at
    Update Secondary SharePoint list
    @FLMike
     

     
    this is the list.
     
    the unique tag columns was my idea to connect both lists. its a concatenation of other columns.

    List 1 is equal to list 2.
     
     
     
     
  • FLMike Profile Picture
    FLMike 31,580 on at
    Update Secondary SharePoint list
    Hi
     
     With calculated columns its always a pain and if we could see the data it would be easier, but here are some things.
      
     However, let me clarify what you are doing as you have multiple issues.

    1. inside a Filter array, the expectation is that you are using the item() expression somewhere.

    For example, let's say I had a column called NumberOfKids and its an integer
    and I wanted to filter the Get items where NumberOfKids is greater than 1

    I would not put the dynamic property in there, I would put this

    (on the left)
    item()?['NumberOfKids'] is equal greater than 1

    In your case you have what looks like the Dynamic Property names. Which I am confused by

    Where are you grabbing the data from SharePoint list 2?
    Is this some kind of loop ???

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,580

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,909

Leaderboard