Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Syndicate_Admin
Administrator
Administrator

need help automating a share point list

so I have a  share point work progress list and an inventory list, when a user selects an inventory item in the work progress list(ns look up column) id like it to change one of the fields from available to in use inside the inventory list

 

Thanks!!!

1 REPLY 1
Syndicate_Admin
Administrator
Administrator

Hi @cgabriel22,

 

Yes, that should be possible with an update item action in a Power Automate flow. You can use the lookup id to find the correct item to update.

 

Below is an example.

 

1. Inventory list with a couple of items (Hammer and Screwdriver). This list has Status column which is Single line of text.

 

inventorylist.png

 

2. A Work in Progress list. The Tool column is a lookup column to the inventory list. It selects the title.

 

workinprogress.png

 

3. The setup of the flow with the update item. It uses the Tool Id to lookup the correct item. And sets the status field with In Use.

 

updateitem_inuse.png

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors