Unanswered

How to get columns name from excel table?

(0) Share

Report

Posted on by alejandromende

Hi everyone

I like to know how to get the column name from excel table, so I after split the text inside each cell belong to the specific column

Thanks

Categories:

Building flows

I have the same question (0)

All responses (4)

Answers (0)

abm abm 32,865 Most Valuable Professional on at

Like (0)

Report

Hi @alejandromende

In PowerAutomate there are no action steps to read the metadata of an Excel file. Could you please explain a bit more about your requirement?

Thanks

Was this reply helpful? Yes No
alejandromende 8 on at

Like (1)

Report

Hi @abm

I have an excel table with a column named Traffic in (speed). I want to split the value in each cell of this column.

I have created a new column to put the first part of the split. The flow run Ok until the new column created.

What is the possible solution to poblate the new column create with the first part of the split (only numbers, first 7 characters) and format the cells to Numbers and calculte the MAX value ?

Thanks

Was this reply helpful? Yes No
abm abm 32,865 Most Valuable Professional on at

Like (0)

Report

Hi @alejandromende

Can't you create the column early? So when you read the rows each column you can use the split() and replace expression() to convert that string value to numeric like you mentioned the first seven characters. Finally pass the value to update action step.

Was this reply helpful? Yes No
alejandromende 8 on at

Like (0)

Report

Hi @abm
The new column was created successfully. I am a newbie working with Power Automate.
Please, Could you explain me in more detail how to extract the row value only related to Traffic in (speed) column, apply the split function and update the rows of the new column.....
Thanks in advanced

Was this reply helpful? Yes No