Forum Discussion
Dynamic Parameters with Multiple Selection
Not clear what your question is. Please provide a more detailed explanation of what you are aiming to achieve. What have you tried and where are you stuck?
lbendlin I have a requirment where I have to use two parameters when I extract data. The firs paramter is Media Type, we have only 3 media types, and the second paramter is for Contract Tile. Eevry media type has several Contract tile. So I want to pick a media type or multiple media type, then i need the corresponding contract title related to the select media type's. Then I am using VBA to auto populate a template after the data extract. It will extract and save copy of a template with the contarct tile in a folder. Right now i want to acheive how i can get those two paramters to work dynamically.
Are you trying to do this in Power Query for Excel?
Yes sir I am trying this on Excel.
lbendlin If you dont mind can we exchange email address to i can explain you with the excel sheet.