Using the Value from Table row

(0) Share

Report

Posted on by mudbloodz1

Sorry if this is a basic question.

I am using "Run a query against a Power BI Dataset" function which returns a single table row.

The Query is below:

EVALUATE
ROW(
"MaterialNo", 'Material Orders'[MaterialNo]
)

and it returns

I would like to use the number value in the returned row within the flow by setting it as a variable.

Any help is much appreciated.

Thanks.

Categories:

Building flows

I have the same question (0)

All responses (5)

Answers (1)

Verified answer

v-xiaochen-msft on at

Like (0)

Report

Hi @mudbloodz1 ,

I made a sample for you.

Best Regards,

Wearsky

Was this reply helpful? Yes No
mudbloodz1 8 on at

Like (0)

Report

Thanks for the info!
I replaced the Array wording with the dynamic content from the Query and it gives me an error.

outputs('Run_a_query_against_a_dataset')?[0]?['[MaterialNo]']

ERROR:
Unable to process template language expressions in action 'Compose' inputs at line '0' and column '0': 'The template language expression 'outputs('Run_a_query_against_a_dataset')?[0]?['[MaterialNo]']' cannot be evaluated because property '0' cannot be selected. Object properties can only be selected by names. Please see

What did I do wrong!
Thanks,

Was this reply helpful? Yes No
v-xiaochen-msft on at

Like (0)

Report

Hi @mudbloodz1 ,

Do you use 'Apply to each' action in your flow?

Could you show me the entire flow?

Best Regards,

Wearsky

Was this reply helpful? Yes No
mudbloodz1 8 on at

Like (0)

Report

The issue I seem to be having is referencing the output table of the Power BI Query. It works if I initialise a variable as you have and save the output of the query to the variable.

That's the dynamic content that produces the same array as your variable.

This is the dynamic content syntax
I tried to replace your variable with the dynamic content.... Which throws the error.

Hope that clarifies.

Was this reply helpful? Yes No
mudbloodz1 8 on at

Like (0)

Report

I Got it to work!
I needed to remove the @{} frmo the dynamic content.
This worked
outputs('Run_a_query_against_a_dataset')?['body/firstTableRows']?[0]?['[MaterialNo]']
Thanks for your help!

Was this reply helpful? Yes No