Referencing a specific column in an array

(0) Share

Report

Posted on by Sbsyx

113

I'm getting an error like this:

Unable to process template language expressions for action 'Warunek' at line '0' and column '0': 'The template language expression 'string(body('TabelaLicencjeM365')?['Subscription End Date'])' cannot be evaluated because property 'Subscription End Date' cannot be selected. Array elements can only be selected using an integer index. Please see https://aka.ms/logicexpressions for usage details.'.

Here is a piece of automation:

"zawiera" is contain on English.

I want to compare two columns unfortunately I can not refer to the array TabelaLicencjeM365. I've tried by the column name then the above error pops up, as it indexes via string(body('TabelaLicencjeM365')?[ 4]) it gets me all the data from the table.

Is it possible to refer to the contents of a table outside the loop in a loop?

All responses (2)

Answers (1)

Sbsyx 113 on at

Like (0)

Report

Re: Referencing a specific column in an array

Thank you, I did it a different way 🙂
Verified answer

Expiscornovus 31,732 Most Valuable Professional on at

Like (1)

Report
Re: Referencing a specific column in an array

Hi @Sbsyx,

I see in your example you use index [4]. Do you want to compare with Subscription End Date value of the 5th item of your TabelaLicencjeM365?

If that is the case try the expression below in your condition and see if that works for you?

body('TabelaLicencjeM365')[4]['Subscription End Date']