List Update using Power Automate

Completed Posted 20 hours ago Paid on delivery
Completed Paid on delivery

I'm looking for an expert in Power Automate who can help me with automating data update within SharePoint / Microsoft list

I need a simple Power Automate flow designed to update a SharePoint list. This flow should specifically handle updating existing items..

Details: 2 lists.

List A: Title and Stock

List B: Title (lookup from A), Type (choice with values Add/Remove), Quantity

First step will be user adds list of items in list A with stocks (no flow so far)

Logic: when a user adds a record in list B, flow will check if type is Add, modify the Stock value for the respective title

Example, Item 1 has 1000 stock in list A, add a new item in list B, type Add, Quantity is 100, in this case modify the stock to be 1100

Now, add a new item in list B, type as Remove, Quantity is 300, in this case, the stock is updated to 800

Similarly, whenever a record is added in list B, check in list A, match the title and update its quantity, if Add then amend the value, if Remove, then subtract the value of stock..

Any queries feel free to discuss,

Ideal skills for this project include:

- Extensive experience with Power Automate

- Proficiency in managing SharePoint lists

- Strong understanding of flow creation and automation techniques

NOTE: please apply only if you have an expertise and demonstrates similar workflow

Question for you:

Q1. The solution will work both for Microsoft List / SharePoint List

Q2. Is it possible to have this functionality for lookup column like above, or we need to manually add name of title, open for recommendations

Sharepoint Microsoft Power Automate

Project ID: #38927887

About the project

15 proposals Remote project Active 13 hours ago

Awarded to:

(145 Reviews)
6.9

15 freelancers are bidding on average €33 for this job

raheelkxoftech

Greetings, With over 15 years of experience as a technology and business professional, I am confident that I can help you with Power Automate. I have a deep passion for SharePoint and have worked extensively with all More

€30 EUR in 7 days
(3 Reviews)
4.7
manoj0284

Power Platform Expert | 4+ Years of Experience | MS Certified | 30+ Projects Delivered I am a seasoned professional with over 4 years of experience in the Power Platform, having successfully completed 30+ projects for More

€15 EUR in 1 day
(2 Reviews)
1.9
ImtiyazAliJafri1

Hello I have worked on numerous projects involving Power Automate and SharePoint list automation, and your requirements align perfectly with my expertise. With over 7 years of experience in PowerApps and SharePoint, I More

€20 EUR in 7 days
(2 Reviews)
3.0
toriquldev123

Hello Dear! Good Day! Hope you are doing fine. This is Toriqul Islam . I am an expert "Web Developer" with 10+ years of working experience in PHP, HTML5, CSS3, JavaScript, jQuery, Bootstrap, MySql and different Frame More

€30 EUR in 3 days
(0 Reviews)
0.0
winindicator07

Hello, there. I am familiar with sharepoint as I hav done similar data processing project. I can achieve all your requirements within a 2 hours. Thank you.

€30 EUR in 1 day
(0 Reviews)
0.0
piyush201301

I have reviewed your requirements and am eager to collaborate with you on this project. With over three years of experience in Power Automate, I have successfully created numerous flows similar to the one you require, More

€20 EUR in 1 day
(0 Reviews)
0.0
genuinesoftpro

Hi there, I specialize in Power Automate and SharePoint workflows, with extensive experience designing automated flows for SharePoint and Microsoft Lists. I can create a seamless solution for your requirements, ensuri More

€19 EUR in 7 days
(0 Reviews)
0.0
yashsoni7

I have worked on similar Power Automate projects involving SharePoint list automation and inventory management. With certifications in Microsoft Power Platform and experience at PwC Consulting, I specialize in creating More

€25 EUR in 3 days
(0 Reviews)
0.0
aliahmadmalikk

Hi There. So list A is filled manually and whenever item is added to list B get that Item from list a and based on Add/Remove increase or decrease stock in list A based Quantity of list B correct? What should happen if More

€30 EUR in 1 day
(0 Reviews)
0.0
madhurivsm

The Requirement can be fulfilled with excel formulas and do not any kind of automation. Q1. The solution will work both for Microsoft List / SharePoint List - It is possible to make it work in both Lists and Sharepoi More

€19 EUR in 2 days
(0 Reviews)
0.0