Parameters setting other parameters

[solarnstorage]

Hi,

I want to show specific weather data for one city at a time, among a list of different cities, as requested by the user. The data grab works through a URL that has a numerical code for a specific city. I have parameterized the data grab with these numerical codes, where I can choose which numerical code gets fed to the URL link. However, I want to be able to let the user make a selection based on city name (ex. New York, which has a specific associated numerial code), and that to set the numerical value parameter that feeds into the data grab.

Wondering if that's possible?

Thank you!

[v-danhe-msft]

Hi @solarnstorage,

Could you please offer me some sample data and post your desired result if possible?

Regards,

Daniel He

[solarnstorage]

I think HotChilli has the right idea, I'm trying to figure out how to do that.

My table looks like this:

The parameter I want the user to be able to filter the data with is the city name: Webster or Mayer. But the value I have to pass to as a parameter to the URL is the numerical code (4954677 for Webster). I don't know how to connect that together.

Thanks!

[HotChilli · Accepted solution]

You must be quite close because haven't you already edited your M code to append the number (which is in the parameter) to the URL?

You then have to add a line before 'Source = ..... ' in the advanced editor of your query which creates a new variable, something like           CityNo = if CityParameter = "Webster" then "4954677" else if CityParameter = "Mayer" then "5036896"

You then use CityNo in the URL which gets assigned in the 'Source =' line.

[HotChilli]

Should be possible, I think.  Set up the parameter to pick from a list of cities instead of codes (which presumably you are doing at the moment) If you write M code to translate the value of the parameter from the city to a numerical code, then append the code to the URL.