If you use Lookup + ForEach actives, the Foreach Items should be:
@activity('Lookup1').output.value
Your solution may be hard to achieve that.
Since you have found that Data Flow doesn't support Cosmos DB Serverless, I think you may can ref this tutorial: Copy Data From Blob Storage To Cosmos DB Using Azure Data Factory
It uses copy active to copy data from a csv file in Blob Storage to Azure Cosmos DB directly.
与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…