web

You’re offline. This is a read only version of the page.

Power Platform CommunityForums Power Automate - Building Flows Change value for all c...

Power Automate - Building Flows

Unanswered

Change value for all cells in a column?

Like (0) Share

Report

Report

Posted on 7 Apr 2021 15:40:01 by brodosi

18

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.

Screen Shot 2021-04-07 at 11.38.38 AM.png

I have the same question (0)

Summarized by AI

All responses Img

All responses (6)

Answers Img

Answers (0)

NorthernChuck 152 on 07 Apr 2021 at 16:32:18

Like (0)

Report

Re: Change value for all cells in a column?

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.

Was this reply helpful? Yes No
NorthernChuck 152 on 07 Apr 2021 at 16:02:32

Like (0)

Report

Re: Change value for all cells in a column?

@brodosi - which error is it feeding? Looking at those screenshots that's basically where I was headed......

Was this reply helpful? Yes No
DamoBird365 8,942 Microsoft Employee on 07 Apr 2021 at 16:02:13

Like (1)

Report

Re: Change value for all cells in a column?

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

Was this reply helpful? Yes No
brodosi 18 on 07 Apr 2021 at 15:55:34

Like (0)

Report

Re: Change value for all cells in a column?

@NorthernChuck Yes, that it.

Was this reply helpful? Yes No
NorthernChuck 152 on 07 Apr 2021 at 15:47:27

Like (0)

Report

Re: Change value for all cells in a column?

Is the above a good example of the table your are working with?

Was this reply helpful? Yes No
DamoBird365 8,942 Microsoft Employee on 07 Apr 2021 at 15:45:24

Like (0)

Report

Re: Change value for all cells in a column?

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

Was this reply helpful? Yes No

Helpful resources

News and Announcements

Welcome to the Power Platform Communities

Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft

Quick Links

Leaderboard > Power Automate

#1

Michael E. Gernaey 626 Super User 2025 Season 2

#2

Tomac 374 Moderator

#3

Expiscornovus 284 Most Valuable Professional

Last 30 days Overall leaderboard

Featured topics

Share your ideas and struggles with building Power Automate flows!

Start and wait for an approval action

Product updates

Microsoft Power Platform Community release plans