none
SharePoint workflow for currency comparing

    Question

  • 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:

    • Condition 1       Amount is $5000 - $9999 notify user 1
    • Condition 2       Amount is $10000 - $24999 notify user 2
    • Condition 3       Amount is $25000  notify user 3

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

    vendredi 13 juillet 2018 16:49

Toutes les réponses

  • HI,

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

    Set Variable: varnum to Current Item:Request amount

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

    send email to user 1

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

    send email to user 2

    If Variable: varnum is greater than or equal to 25000

    send email to user 3


    sal

    dimanche 15 juillet 2018 10:11
  • Hi,

    Check the below example of designer workflow.

    let me know if you have any issues.



    sal

    • Proposé comme réponse Nguyen Kevin lundi 16 juillet 2018 08:58
    dimanche 15 juillet 2018 10:38
  • Hi,

    If you think the suggestion provided by SB Ali is helpful, you could mark it as an answer.

    Best regards,

    Allen Bai 


    Please remember to mark the replies as answers if they helped. If you have feedback for TechNet Subscriber Support, contact tnmff@microsoft.com.


    Click here to learn more. Visit the dedicated forum to share, explore and talk to experts about Microsoft Teams.

    lundi 16 juillet 2018 08:36
  • Yes your solution works great.

    I did have other question though.

    I actually have other conditions as well, but the workflow is notifying more than one person.

    As of now it sends email to mull and murphy but it should have just sent email to Murphy since the Location = TXS.

    What am i doing wrong?


    lundi 16 juillet 2018 14:59
  • Hi,

    As this is a new question, I would suggest you post it in a new thread, it would make others easier to focus on one question in one single thread and it will benefit other community members who stuck with the same question(most people find the question by title). 

    Best regards,

    Allen Bai


    Please remember to mark the replies as answers if they helped. If you have feedback for TechNet Subscriber Support, contact tnmff@microsoft.com.


    Click here to learn more. Visit the dedicated forum to share, explore and talk to experts about Microsoft Teams.

    mardi 17 juillet 2018 01:43