web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / How to update related ...
Power Automate
Unanswered

How to update related list in SharePoint

(0) ShareShare
ReportReport
Posted on by

I've two lists Product and Receipt in a SharePoint site

 

Product => ProductName, Stock

Receipt => Date, ProductName(Lookup column), QtyRecd

 

When a item is added to Receipt I want to update Stock column in Product list with Stock + QtyRecd

 

How can i achieve this using Flow?

 

I tried to use the (Get Item) Product but can't see the lookup column in Receipt List

 

Thanks

Adi

Categories:
  • mmangiante Profile Picture
    304 on at

    Hi @Adi

     

    have you tried with update item action?

     

     

    --

    Regards,

     

    Marco Mangiante

  • v-micsh-msft Profile Picture
    Microsoft Employee on at

    Hi @Adi,

     

    Could you please explain a bit for the lookup fields configured for those two lists?

    If the ProductName lookup column under Receipt only reference single column (Value should be unique) in Product list, then we could take a try with the following way to update the related Stock:

    1. First the SharePoint trigger "When a new item is created", set with the SharePoint site URL, and the Receipt list,

    2. Add a SharePoint Get items Action, specify the Sharepoint Site URL, and the Product list,

    3. Add a condition, choose the ProductName Dynamic content generated from Get Items as the Object name, and the ProductName value dynamic content generated from "When a new item is created" as the value,

    4. Under the Yes part, select the update item, use the ID generated from "Get items"  as the Item ID, then update the corresponding column with the data you want

    A screenshot for reference: ("Title" here should from Product list->Get items action, "Lookup value" should from Receipt list->When a new item is created trigger )

    76.PNG

    If you need any further question on this, please post back.

    Regards

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

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Leaderboard > Power Automate

#1
Mohsin Ali Profile Picture

Mohsin Ali 445

#2
11manish Profile Picture

11manish 345 Super User 2026 Season 2

#3
M Bilal Khan Profile Picture

M Bilal Khan 300

Last 30 days Overall leaderboard