Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Power Automate - Building Flows
Suggested answer

Problem with adding values to a Lookup column

(0) ShareShare
ReportReport
Posted on by

Hi, 

I have problem with the following situations.

  • Source List: Contains only a "Equipment" column.
  • Target List: Contains the "Equipment" column as a lookup field, referencing the "Equipment" column to the Source List.

Objective: In the Target List, the equipment from the Source List should be automatically added to the lookup field when new equipment is created in the Source List. If equipment with the same name already exists, no new entry should be created.

 

I have tested it several times, but when I create a value in the source list that already exists in the target list, it creates the item again, resulting in duplicate values ("187")

 

  • Suggested answer
    Gopala_Krishna Profile Picture
    1,491 on at
    Problem with adding values to a Lookup column
    While writing OData filter query for LookUp columns in SharePoint we need to define as follows.
     
    LookUpFieldName/Id
     
    In your case I suggest to re-write the OData filter query as Equipment/Id
     

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

Michael Gernaey – Community Spotlight

We are honored to recognize Michael Gernaey as our June 2025 Community…

Congratulations to the May Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard >