Power Platform Community Forum Thread Details

Hi,

i do have a problem with Microsoft Power Automate.

Iam getting Data out of Excel and iam savig this data in an Datentabelle/Array in Power Automate.

Now i would like to use a spezfic cell of my Datentabelle/Array and write that information into an Outlook E-Mail.

For excample:

I would like to the the Information of Column2 Row 2 and Post this Information into A Outlook mail.
How should the code look like? %ExcelData[column2;#2]%

I would be happy if you can help my by this problem.

Justen

Categories:

Power Automate Desktop

You can access a value from a data table by providing indexes as follows: %Table[RowIndex][ColumnIndex]%. Indexes are 0-based in PAD, so to get row 2, your row index must be 1. So, for your case, you would need to do %ExcelData[1][1]% to get the value you want. Note that the first index is the row index and the second one is the column index.

You can also use column names, if you have them. So, you could also do %ExcelData[1]['Column2']% to get the same value. There is no such thing as a row name, though, so rows must be accessed via indexes.

-------------------------------------------------------------------------
If I have answered your question, please mark it as the preferred solution. If you like my response, please give it a Thumbs Up.

I also provide paid consultancy and development services using Power Automate. If you're interested, DM me and we can discuss it.