Unanswered

Expression doesn't read variable as index to get an object from array

(0) Share

Report

Posted on by KRyadchenko

I'm comparing the current SharePoint List item vs its previous stage. I'm using Send an HTTP request to SharePoint then I Parese JSON it to get an array of version. I have no trouble getting an entire version history. However, when I try to get the previous version through Initiate Variable I ran into trouble.

When I hardcode the array index inside of the Initialize Variable I have no trouble. Initialize Variable component gives me an array with a single object.

However, when I try to use a previously initialized variable as an index the flow returns me an empty array.

Please help me resolve that problem.

Categories:

Using flows

I have the same question (0)

All responses (2)

Answers (0)

Sort by

v-yetonggu-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @KRyadchenko ，

Please make sure that you initialized the variable Index before the type is an integer, and check the input of the Past Project array.

Best Regards,

Sunshine Gu

Was this reply helpful? Yes No
KRyadchenko 3 on at

Like (0)

Report
Copy link

Link copied!

Thank you.
Yes, I've checked the variable in the past flow to verify that I get Index as Integer.
I've also checked that the Index variable is within the length of the array.
I'm also checking the Index variable with Compose. It shows if the value of the Integer is still valid. And it is.

So with the length of Array 29 I'm trying to get 27th object of the array and get an empty array
Here is the expression for PastProjects

While hardcoded Index used in VersionList variable returns me an array of past version.
Here is the expression for VersionList

So I'm quite confused as to why Power Automate produces an empty array when the index of an object is set as a variable. I guess is that the Index variable gets assigned parallel to using it as an Index.
Please help 😞

Was this reply helpful? Yes No