I have an Excel file with a column "Status" and the status is set to Yes. I need to automate any value set to yes, changed to no. Any advice?
This is what I used so far, however it only changes the value on the first row.
Hi @brodosi
With List rows, I would set a filter, where
Status eq 'Yes'
Then your apply to each should traverse through all "values" and update the row to No.
When you say it only updates 1 row, how have your built the apply to each and update row?
Does the get rows show more than one row in the output of the history?
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Cheers,
Damien
P.S. take a look at my new blog here
Is the above a good example of the table your are working with?
Hi @brodosi
I believe (but might be wrong) your filter query is wrong.
Should be
Status eq 'Yes'
But also, your key column needs to be unique, i.e. 1,2,3,4,5,6 You cannot have multiple rows with the same key value as it will always find the first one and therefore only update ONE row.
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Cheers,
Damien
P.S. take a look at my new blog here
@brodosi - which error is it feeding? Looking at those screenshots that's basically where I was headed......
I'm pretty close, you can probably make due from here. The single ticks are apparently not needed. All cells marked "Yes" were updated to "Maybe'" in my spreadsheet (see below)
Here's the flow.
User | Count |
---|---|
88 | |
37 | |
26 | |
13 | |
13 |
User | Count |
---|---|
127 | |
54 | |
37 | |
24 | |
21 |