none
Lookup another List - SharePoint designer - Advanced Workflow

    Question

  • Dear All,

    I am working on inventory system and I am stuck in sp designer 2013 lookup[out of the box]. Well I have 3 List

    1)Product Type
    2)Stocks
    3)Store Request

    Product Type contain: one column : Product Name (Single Line Text)

    Stock contain: Product Name(Lookup from Product Type), Quantity Purchased(Number), Quantity Used(Number), Remaining Stock(Calculation based on other column-Number).

    Store Request contain: Items (Lookup from Product Type), Qty(Number)

    Workflow is in Store request

    Well my problem is in workflow. I want to check the stock availability. And if found request qty is larger then remaining stock, then email storekeeper. But VStrchk throw zero.

    Vriable VStrchk is number

     Kindly suggest what is wrong in my below workflow.  

    Stage: stock Check
    Set Variable: VStrchk to Stock:Remaining Stock
    if CurrentItem:Qty is greater than Variable: VStrchk
    Email: CurrentItem:<emailID>

    Field Data to Retrive
    Data Soruce: Stock
    Field from Source: Remaining Stock
    Return field as: As Double
    Fild the list item
    Field: ID
    Value: Current Items: Items

    lookup for integer
    Data source: Current Item
    Field from source: Items
    Return field as: Lookup ID(as integer)

    Thanks is advance.





    • Edited by cosmicwave Sunday, March 5, 2017 6:57 AM variable type
    Saturday, March 4, 2017 4:06 PM

Answers

  • Ya did same and there is no such multiple values.

    --

    Updates: 

    Well i created new sub site and created workflow/list from scratch and Amazingly its working. Ya  !!!

    Ya this worked now, i dont know how? This same what i did earlier and it was not working and now its workign in new sub-sites.. Ooooo confusing Oooooo !!!

    Field Data to Retrive
    Data Soruce: Stock
    Field from Source: Remaining Stock
    Return field as: As Double
    Fild the list item
    Field: ID 
    Value: Current Items: Items

    lookup for integer
    Data source: Current Item
    Field from source: Items
    Return field as: Lookup ID(as integer)

    Thanks Linda for your support again. At least you care to help.

    Wednesday, March 8, 2017 7:59 AM

All replies

  • Hi cosmicwave,

    In your situation, the workflow is running on the “Store Request” list, and you want to get the "Remaining Stock" from the "Stock" list.

    For this requirement, you should find the item based on the “Product Name” from the “Stock” list.


    Best regards,

    Linda Zhang


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

    Monday, March 6, 2017 6:09 AM
    Moderator
  • HI Linda, Thank you very-much  for your reply. I tried that too. But result same zero. I really dont know why this workflow not working for me :(

    HI Linda, Thank you very-much  for your reply. I tried that too. But result same zero. I really dont know why this workflow not working for me :(. 

    Well can any one simulate same in their system. I am using office 365 Share point online + Share point designer. This is really killing me.. tried so many times with different tick but could not cracked. :( :(

    Thanks again.

    • Edited by cosmicwave Tuesday, March 7, 2017 3:41 AM
    Monday, March 6, 2017 10:12 AM
  • Hi cosmicwave,

    Are you using the Set Workflow Variable action as the following settings?

    Field Data to Retrive

    • Data Soruce: Stock
    • Field from Source: Remaining Stock
    • Return field as: As Double
    • Fild the list item
    • Field: Product Name
    • Value: Current Items: Items

    lookup for String

    • Data source: Current Item
    • Field from source: Items
    • Return field as: Lookup Value (as Text)

    And please ensure that the lookup column does not have multiple values.

    Best regards,

    Linda Zhang

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

    Tuesday, March 7, 2017 10:05 AM
    Moderator
  • Ya did same and there is no such multiple values.

    --

    Updates: 

    Well i created new sub site and created workflow/list from scratch and Amazingly its working. Ya  !!!

    Ya this worked now, i dont know how? This same what i did earlier and it was not working and now its workign in new sub-sites.. Ooooo confusing Oooooo !!!

    Field Data to Retrive
    Data Soruce: Stock
    Field from Source: Remaining Stock
    Return field as: As Double
    Fild the list item
    Field: ID 
    Value: Current Items: Items

    lookup for integer
    Data source: Current Item
    Field from source: Items
    Return field as: Lookup ID(as integer)

    Thanks Linda for your support again. At least you care to help.

    Wednesday, March 8, 2017 7:59 AM
  • Hi cosmicwave,

    I am glad that the workflow works now.

    You can mark the post as an answer, it will help others in this forum.

    Best Regards,

    Linda Zhang


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

    Thursday, March 9, 2017 1:08 AM
    Moderator