So essentially you have data, you want to point to a specific Row in your data, compare that against some particular data value, then in the current Row, update its value specifically.
It is possible to do this, and David provided some guidance, but what I will add is, what you are missing to give us is the Context of when you plan and need this.
What I mean is.
Imagine you have an Excel sheet that you want to populate to SharePoint.
You grab the data and before you insert the row into SharePoint, that's the point where you want to do this check, well then my answer would be different, than if you said you wanted to add it to an Array.
The point being is, you can absolutely grab data from somewhere and have it return an array of data items (rows)
You can then loop through that to impact another datasource (or the same) and do the calculation you want and by calculation I simply mean do the check of the value in whatever ROW is constant (you define) compared to the current row and update it WITHIN the action that will insert the data, NOT in the actual Array of data returned from Excel.
Now, let's pretend instead, that you pulled Data from Excel.
You wanted to create an Array of data to Email someone and you needed the functionality above.
You could use the Select action, to pull ONLY the Columns from the Data you pulled from excel, you could then add an additional Column Named (Image Id) and in there put an expression that would calculate what value to put there.
You could then use the Create HTML Table, to create a Table that looks like the above
Then the Send Email Action to email it
So totally possible, but depends on your scenario, how to implement it.
Cheers,
If this answers your question Please mark the answer as such and maybe a like
Thanks!
