cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
BenDonahue
Skilled Sharer
Skilled Sharer

accessing an Excel column from Flow

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.

1 ACCEPTED SOLUTION

Accepted Solutions

@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.

Hardesh15_0-1599056185780.png

Hardesh15_1-1599056234962.png

 

Thanks

Hardesh

 

 

View solution in original post

4 REPLIES 4
Hardesh15
Super User
Super User

@BenDonahue 

 

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

 

Thanks

Hardesh

@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.

 

@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.

Hardesh15_0-1599056185780.png

Hardesh15_1-1599056234962.png

 

Thanks

Hardesh

 

 

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

Helpful resources

Announcements
October Events

Mark Your Calendars

So many events happening this month - don't miss out!

 WHAT’S NEXT AT MICROSOFT IGNITE 2022

WHAT’S NEXT AT MICROSOFT IGNITE 2022

Explore the latest innovations, learn from product experts and partners, level up your skillset, and create connections from around the world.

Register for a Free Workshop.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

Users online (3,879)