I created two lists- Configuration list with two columns namely title and approver.title has some ids and this is a lookup column.The other list is Service list - with columns like- titlew(ids),workordercost,date and status.logic is to use workordercost, so if workordercost is less or equal to 600k- person a
workordercost is between 600k to 2million - person b
workordercost is greater than 2million - person c
I need to select the approver and id based on the workordercost when the workflow is run and send mail accordingly
what i did- my configuration list and i gave my name as approver
3.Send notifications are assigned to initiator and flexi task assignee is vApp(my variable)
5.written the logic in workflow settings when item updated
6.my update action
Am not able to trigger email and how to go about the process.
Please help .
Thanks in advance
I'm sorry you description is not clear at all.
can you describe what's your business case? - what data do you get on input and what you need to lookup and update?
you says, you want to select ID and approver by cost, but you have 3 cost levels and 4 cost IDs. how these do match together? from your service list example there doesn't seem to be any logic between ID (titlew) and cost amount...
btw, your workflow start conditions are pointless, it always evaluates to true.
what did you want to achieve with this?
I know the total workflow is wrong.I dint know what action items to be used and ended up with the wrong one.
I think Titles are not to be matched from both the lists.
i just have to see that "If WorkOrderCost is less than or equal to 600k, retrieve item with Title WOC1 in Configuration List "
I need to determine item in config list to fetch depending on WorkOrderCost.
so, should it work like
if WorkOrderCost <=600k then get from configuration list approver for WOC1
if WorkOrderCost > 600K and <= 2M then get from configuration list approver for WOC2
if WorkOrderCost > 2M then get from configuration list approver for WOC3?
then I would suggest following approach:
- extend configuration list by two fields that will define lower and upper approval limit. this limits will then be configurable without workflow change. so config list might look like
- and your query list will then look like