Looking for some assistance with creating a workflow that pulls data from List A and pulls looped though data from List B, then combines the data in an email notification. We are using SharePoint 2016 on premise.
Currently this is a workflow created on List A
List A - Supply Request:
This is the parent list. Only one parent per request
Columns: Item, Vendor, Total Cost, ID (list created ID), etc...
List B – Expense Items
Columns: Expense Type, Quantity, SRID (SRID is linked to the List ID in the Lisa A – Supply Request), etc...
Each parent request from List A, can have multiple child records from List B.
Using just Lisa A: my problem is when I try to pull the child records from list B, no results are included in the email notification.
Here is my current workflow for List A:
Query List A and place each option into a collection.
Query List B and place each option into a collection
Build eMail string
Run parallel actions… Collection Operation. A collection Operation was created for each Field in the Query List actions. This is just one of the Collection Operations…
Math Operation (used for looping)
Any suggestions are greatly appreciated?
Solved! Go to Solution.
@klmerrills ...It seems the variable you're using to filter List B is a collection. Try below approach: