Showing results for 
Search instead for 
Did you mean: 
a68tbird Helper III
Helper III

Invoke Function Based on User Selection

Hello All -

   Here's my situation.  I have an orders table with customer email, order number and a shipping reference number. I also have a custom function that will make an API call using that shipping reference number and return a tracking link.  These API calls have to be on demand - I can't load a table of 10,000+ records and expect to get responses.  That many calls at once will just be frowned upon. 


What I ideally would like is to have a table of order details on the user canvas with a slicer on email address.  When a user searches for the customer email address, the order details table filters to the order in question, and then upon selection (highlight or something) triggers the custom function to make the API call.  Note that the customer email can return multiple orders and multiple shipping references. 


Is this possible? Any one have any suggestions on a different way to approach?





Re: Invoke Function Based on User Selection

Hi @a68tbird,


No. It is not possible to pass a slicer selection to Power Query and invoke the custom function. Please be aware that Power BI always gets dataset first via Power Query, then, we can display the data in report page. We cannot pass any value from report to Power Query.


Best regards,
Yuliana Gu

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcing the New Spanish Forum

Announcing the New Spanish Forum

Do you need help in Spanish? Check out our new Spanish community section.

MBAS Gallery 2020

MBAS Gallery 2020

Watch Microsoft Business Applications Summit sessions on-demand.

‘Better Together’ Integration Forum Launch

‘Better Together’ Integration Forum Launch

We've launched a how-to forum where you can learn about how Power BI integrates with other Power Platform products.

Top Solution Authors
Top Kudoed Authors