In the Azure Data Factory pipeline, you can have a LookupActivity --> ForEach Activity --> Set Variable + other Activity. Please see the screenshot for details. Thanks!
----------
If the above response is helpful, please accept as answer and upvote it. Thanks!