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 / Use MS Flow to update ...
Power Automate
Unanswered

Use MS Flow to update a Sharepoint item from List A based on quantity received in List B

(0) ShareShare
ReportReport
Posted on by 46

Hello,

 

I have a new challenge. I want to build an inventory app via PowerAPPS based on Sharepoint lists.

 

I did created the sharepoint list with name Inventory with some basic column data like:

name, description, manufacturer, part image, serial number, stock, reorder stock threshold.

 

Now i want this list to be updated via a 2nd list, named asset_movement (in this list i want to keep track of all incoming products to stock/inventory).

This list contains: name, description, manufacturer, serial number, date received, stock received.

 

I want to link both lists based on serial number since is unique and is linked to a certain product, and i want to update in List A the column with stock by adding the values form the 2nd list on stock received.

 

Did it make sense to you?

 

Using integrated Lookup function in sharepoint column didn't do the trick, and in MS Flow i am stuck.

 

Anyone has a better idea?

 

Thank you.

Categories:
I have the same question (0)
  • v-xiaochen-msft Profile Picture
    Microsoft Employee on at

    Hi @cgh2022 ,

     

    I made a sample for you.

    vxiaochenmsft_0-1673234511181.png

    vxiaochenmsft_1-1673234523900.png

    vxiaochenmsft_2-1673234546437.png

    vxiaochenmsft_3-1673234570035.png

    vxiaochenmsft_4-1673234683849.png

    vxiaochenmsft_5-1673234711706.png

    vxiaochenmsft_6-1673234766137.png

    vxiaochenmsft_7-1673234777582.png

     

    Best Regards,

    Wearsky

  • cgh2022 Profile Picture
    46 on at

    Going to build it now, thank you.

  • cgh2022 Profile Picture
    46 on at

    I think i miss something, created the flow as you instructed, but still fails with error: "column serialnumber doesn't exist.

     

    Atached is the flow, I am doing something wrong, but can't figure out what.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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Congratulations to the April Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Vish WR Profile Picture

Vish WR 707

#2
Haque Profile Picture

Haque 475

#3
Valantis Profile Picture

Valantis 456

Last 30 days Overall leaderboard