cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
inavedk
Regular Visitor

How to get item from first step

Hi All , 

 

I want extraction date(Already present in this step) from "Run a query against dataset" in Email V2. i have tried using 

@{item('Run_a_query_against_a_dataset')?['Weekly[execmax]']} however it is throwing error "Unable to process template language expressions in action 'Send_an_email_(V2)_2' inputs at line '0' and column '0': 'The template language function 'item' must not have any parameters.'.".
Please suggest how to call a value in V2 email form from 2nd step.
 
inavedk_0-1663171446850.png

 

Thanks
1 ACCEPTED SOLUTION

Accepted Solutions
inavedk
Regular Visitor

Hi all I have got the answer this works for me as i just want first value of the coulumn "outputs('Run_a_query_against_a_dataset')?['body/firstTableRows'][0]?['Weekly[execmax]']"

View solution in original post

3 REPLIES 3
inavedk
Regular Visitor

@Hardesh15 @Expiscornovus please help

 

v-jefferni
Community Support
Community Support

Hi @inavedk ,

 

Could you please check the most recent run history, open the raw outputs and show us the data structure?

vjefferni_0-1663311088487.png

 

Best regards,

Community Support Team _ Jeffer Ni

If this post helps, then please consider Accept it as the solution to help the other members find it.

inavedk
Regular Visitor

Hi all I have got the answer this works for me as i just want first value of the coulumn "outputs('Run_a_query_against_a_dataset')?['body/firstTableRows'][0]?['Weekly[execmax]']"

Helpful resources

Announcements
Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Difinity Conference 2022

Difinity Conference 2022

Register today for two amazing days of learning, featuring intensive learning sessions across multiple tracks, led by engaging and dynamic experts.

European SharePoint Conference

European SharePoint Conference

The European SharePoint Conference returns live and in-person November 28-December 1 with 4 Microsoft Keynotes, 9 Tutorials, and 120 Sessions.

Users online (2,141)