You’re offline. This is a read only version of the page.
7
This is my first timing trying to use Flow.
I'm trying to create a Flow that runs a query on a dataset and then puts the results into an email.
How do I get the result from the query into the email? I've tried using a variable but can't see what to do next.
Any idea what I would put in the Key and Value fields for this?
Thanks @v-jefferni, I think I can see what's going on there. So does it have to be an EVALUATE statement returning a table? Or can I return a single value like a count of rows in a table or similar?
Hi @ihavenoname ,
The method is simple. See in below screen shot:
Just use a Select action to map columns then you can get the app using Compose ("Get" in the screenshot).
Best regards,
Thanks but I can't work out what's going on in their example. It seems far more complicated than what I'm trying to do.
Hi @ihavenoname ,
The basic process is as in the following thread:
1. Run a query against pbi dataset
2. Select, map columns
3. use the value in Send email from Select, there would be an Apply to each come up automatically since output of Select is an array.
Best regards,
#1
Michael E. Gernaey
497
Super User 2025 Season 1
#2
David_MA
436
Super User 2025 Season 1
#3
Riyaz_riz11
244
Super User 2025 Season 1
Share
Report
All responses (
Answers (
