用于货币比较的SharePoint工作流程 [英] SharePoint workflow for currency comparing

问题描述

我有一个名为"Amount"的列

I have a column named "Amount"

我有维修请求的工作流程

I have a workflow for Repair Request

如果请求的金额如下，我需要通知用户：

I need to notify users if the requested amounts are as followed:

• 条件1      金额为5000美元 - 9999美元通知用户1
• 条件  2      金额为$ 10000 - $ 24999通知用户2
• 条件  3      金额为25000美元  通知用户3

如何进行计算或确定金额何时在上述范围内？

How do I do a calculation or something to determine when the amount is within the ranges above?

推荐答案

HI，

创建类型编号的变量varnum并将变量设置为请求的数量

create a variable varnum of type number and set the variable to requested amount

将变量：varnum设置为当前项：请求金额

Set Variable: varnum to Current Item:Request amount

如果变量：varnum大于或等于5000

和变量：varnum小于或等于9999

If Variable: varnum is greater than or equal to 5000
and Variable: varnum is less than or equal to 9999

向用户1发送电子邮件

如果变量：varnum大于或等于10000

且变量：varnum小于或等于24999

If Variable: varnum is greater than or equal to 10000
and Variable: varnum is less than or equal to 24999

发送电子邮件至用户2

send email to user 2

如果变量：varnum大于或等于25000

If Variable: varnum is greater than or equal to 25000

向用户3发送电子邮件

这篇关于用于货币比较的SharePoint工作流程的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！