I am using sharepoint 2013 and designer 2013. i have two lists "product NC(non-conformance) Detail" and "Product Status". one product have many NC# and status column option column. In Product Status list i want if product id all status resolved than "product Status" list status column update resolved. if one field unresolved than unresolved. Output shown in "Product Status". Below are two lists. Product NC Detail Prod ID NC # NC Description Status 1 1.1 Hardware test failed resolved 1 1.2 Software problem unresolved 1 1.3 etc unresolved 2 2.1 resolved 2 2.2 Hardware test failed unresolved 3 3.1 resolved 3 3.2 resolved 4 4.1 unresolved 4 4.2 resolved
Product Status Product ID Status 1 unresolved 2 unresolved 3 resolved 4 unresolved
Thanks in Advance
Amira BedhiafiPosted Sep 29, 2025, 2:06 PM
Hello !
You can add a numeric helper column in your Product NC Detail list that stores
1if status = unresolved and0if resolved, then create a designer workflow on Product NC Detail that updates this flag whenever an item is created or changedThen you need to create a second workflow on the Product Status list that when triggered looks up all related NC Detail items for that Product ID, sums their UnresolvedFlag values, and updates the parent status to unresolved if the sum is greater than zero, otherwise sets it to resolved.