How to update excel row that is output of filter Array

(0) Share

Report

Posted on by kallchri

Hello! I am currently trying to update in Excel only the first row (object) of an array of rows (objects) that come from a Filter Array action. For this purpose, I am using an apply to each action and the 'first' function to retrieve the first row of the array. My problem is that the output of first is an object and not an array, and apply to each does not work for that reason. Does anyone know how to properly fetch the row I want and then update it?

All responses (2)

Answers (1)

kallchri 8 on at

Like (0)

Report

Re: How to update excel row that is output of filter Array

Thank you so much, it worked!
Verified answer

v-mengmli-msft on at

Like (0)

Report

Re: How to update excel row that is output of filter Array

Hi @kallchri ,

Please add [ ] outside the object to convert it to an array.

Best regards,

Rimmon