Forum Discussion
List Parameter only passes Current Value
I am trying to retrieve detail records for every six-digit ID of a list. I have a parameter that is fed this list: I want the parameter to pass the correct value when its function (API c...
Do you need to create a parameter for this? I'm not at my desk, but can't you just replace
& Number.ToText(CampaignIDParameter)
with
& each Number.ToText([CampaignID])
--Nate
Anonymous is correct. You should pass the ID value from the row, not a single parameter value.
A parameter is designed to be constant throughout the query. It's not a variable that gets updated for each row.