accessing an Excel column from Flow

[BenDonahue]

I need to access the column so I can find the max value.

This does not seem a difficult thing to do, after all the column is already a list/array so, accessing the column from within a max() method would return the maximum value in the array. Excellent! 

So, how does one access an Excel column from Flow?

Here's a hint, not like this:

outputs('List_rows_present_in_Log')?['Data-ID'])

Thank you for your help.

[Hardesh15]

@BenDonahue 

Do you want to fetch column value from excel? is this your problem?

Thanks

Hardesh

[BenDonahue]

@Hardesh15 ,

In this use case, I am trying to access the max value in Data-ID column. My strat is to get the column as an array and use 'max()' expression.

What I am trying to do is create a unique ID for each entry. Starting with a blank column, with pre-filled data in other columns, I want to grab the maximum value for Data-ID from the Log table, add 1 to it, and use that number in the first row, then add one to each subsequent row until all rows that have data are filled with a unique Data-ID.

[Hardesh15 · Accepted solution]

@BenDonahue 

i have created a value column(which has value 12,13,14) in excel and it type is string so i am converting into Int in Apply to each. In array variable 'Max' i am appending all values in variable and later used max() expression.

Thanks

Hardesh

[BenDonahue]

It seems strange that we humans have to create an array from what is essentially an array.