Hello,I've built the following Flow where:A Form Response is submittedGrabs team member's personal information from Sharepoint using employee number&n

Managed to solve this!To get the current row, I-initialized a variable named RowCount, set to integer, and put the 'Initialize Variable' expression as

You’re offline. This is a read only version of the page.

Power Platform CommunityForums Power Automate - Building Flows Getting current excel row

Power Automate - Building Flows

Answered

Getting current excel row

Like (0) Share

Report

Posted on 11 Apr 2024 18:12:27 by kona134

Hello,

I've built the following Flow where:

A Form Response is submitted
Grabs team member's personal information from Sharepoint using employee number

Adds the SharePoint information into a row to an Excel table

What I would like to do is get the current Excel row that, when an option is chosen from a dropdown list, have that option sent to the team member via email. So for I've managed to get the flow working so that it gets A row and the current row chosen option into email. What I'm having difficulty with is:

Getting the current row in the email notification
Only sending one email instead of multiples or duplicates.

Thanks for any help!

I have the same question (0)

All responses (1)

Answers (1)

Verified answer

kona134 67 on 12 Apr 2024 at 22:06:19

Like (0)

Report

Re: Getting current excel row

Managed to solve this!
To get the current row, I-
initialized a variable named RowCount, set to integer, and put the 'Initialize Variable' expression as
length(body('List_rows_present_in_a_table')?['value'])
Then used 'Get Row', set key column to 'Unique ID' and set Key Value to the 'Initialized Variable' RowCount
Then in 'Send Email' set the body using the Excel values from 'Get a Row'.

Here is the overall Flow Structure:

Was this reply helpful? Yes No