asked on

Update a list item from another list by SP 2010 Designer workflow

Dears,

I have a SharePoint 2010 custom list called 'Car_Names' with two fields which are Car_Name(text), Status(choice, choice values are In, Out) and another custom list called 'Car_Requests' with three fields which are Name(text), EMP_No(text), Car_Name(Lookup field, getting cars names from the first list 'Car_Names')

Now my question is , if any one created a request for a car by using the first list then the status of that particular car in the second list must change to 'Out'. How this we can achieve by using SharePoint 2010 designer workflow.

Any help on this is appreciated.

cobrachen

Since you already know that SPD workflow can help you, I will not go into why or how to create a workflow.

When you use workflow to process lokkup values, you want to first add the value into a workflow parameter(text data type0 to make sure you get a text value, not the row ID value.

You can use log to help you to check the value you recived in each step an compare results to assure you will update the correct row in the Cars list.

Generally, you can have a workflow fire when a car is selected from the 2nd list, compare the car names from both lists, find the row in the second lit and update the status.

Thanks.

ASKER CERTIFIED SOLUTION

Manoj Patel

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

mshaji

ASKER

Thank you very much dear. You rocked. Problem solved for me. 2 days i was spending time on this issue.

Admin pls redeem to him full points