Skip to content

Instantly share code, notes, and snippets.

@anton-dudarev
Forked from Hugoberry/setParameters.ts
Created September 5, 2020 11:05
Show Gist options
  • Save anton-dudarev/d69feaefb6ce7a12c406b39faa5bc202 to your computer and use it in GitHub Desktop.
Save anton-dudarev/d69feaefb6ce7a12c406b39faa5bc202 to your computer and use it in GitHub Desktop.
[Power Query] Replace an unary function type with a custom type that contains metadata for allowed parameter values
(f as function, allowedValues as list)=>
let
//create a new parameter type with metadata for allowed values
parameterType = Value.Type(allowedValues{1}) meta [Documentation.AllowedValues = allowedValues],
//create a function type with custom parameter type
myFunType = type function (select as parameterType) as function
in //replace the orginal function type with the new myFunType
Value.ReplaceType(f,myFunType)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment