Getting current excel row

(0) Share

Report

Posted on 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!

All responses (1)

Answers (1)

Verified answer

kona134 67 on at

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: