Reply
tswm00
Frequent Visitor
Partially syndicated - Outbound

Expression.Evaluate to examine value of parameter?

Is it possible to use Expression.Evaluate to (dynamically) examine the value of a Power Query Parameter?

Trying the below results in null despite the parameter "InitFileGLOBAL" has a value.

 

let
  ParameterName = "InitFileGLOBAL",
  Source = Expression.Evaluate(ParameterName, #shared)
in
  Source
5 REPLIES 5
Vijay_A_Verma
Super User
Super User

Syndicated - Outbound

You have to just say

let
   Source = InitFileGLOBAL
in
  Source

Syndicated - Outbound

Thanks! I was unclear. I want to examine value dynamically and thus select what parameter to examine based on a string value representing the name of the parameter.

Syndicated - Outbound

The way you have done is right. Check whether InitFileGLOBAL contains a value or not in Parameter screen. 

The null will come when there is no value in current value.

1.png

Syndicated - Outbound

Thanks for your response!

I am trying to accomplish this in Power Query Online (Datamart)

When testing the same thing i Power Query for Excel it works as a charm so the question is if this is a permanent limitation in Power Query Online?

Online doesnt like the #share object or any other dynamic values in my queries (that works fine in the Excel version) so perhaps i need to rethink the design fundamentally.

tswm00_0-1654090019907.png

 

tswm00
Frequent Visitor

Syndicated - Outbound

Perhaps Expression.Evaluate is not the right way?

Examining #share results in:

tswm00_0-1654086800246.png

 

avatar user

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

ArunFabCon

Microsoft Fabric Community Conference 2025

Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.

December 2024

A Year in Review - December 2024

Find out what content was popular in the Fabric community during 2024.

Top Solution Authors (Last Month)
Top Kudoed Authors (Last Month)