cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
cgabriel22
New Member

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
Expiscornovus
Dual Super User
Dual Super User

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
Canadian Cloud 2022 768x460.png

Register for a free PVA chatbot creation workshop.

Learn how to respond rapidly to your customers and employees at scale, using intelligent conversational chatbots.

PVA Community Blog Build Carousel (1) (1).png

What does the community say?

Discover what our community thinks about the announcements at Build 2022.

June 14th PVA AMA Carousel (up on May 25th, take down June 15th) (1).png

'Ask Microsoft Anything' about Power Virtual Agents!

Join the community to ask questions and provide helpful answers about Microsoft's conversational AI and Power Virtual Agents.

Users online (1,530)