Autofill column B according to the repective row of column A

(0) Share

Report

Posted on by CU14062117-0

Hi,
How can I istruct Powe Automate to insert the text FP in the column B if the respective cell of columna A contains any text, like in the example?

B1 is FP because A1 contain text
B2 is empty because A1 is empty

B3 is FP because A3 contains text

B4 is FP because A4 contains text

B5 is empty because A5 is empty
….

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (0)

Sort by

André Arnaud de Cal... 679 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi,

There are several ways to achieve this. In case you have a table in Excel, you can use the Excel actions to read and write to the tables. You can then loop all records in the table and perform actions.

Your current screenshot shows no table, nor headings. There is an option to edit Excel sheets using Microsoft Graph connections. Here is an example: Power Automate: Read / Write to Excel using Microsoft Graph (Fast!) – PAWIT.PW

Anyway, as you have a pre-defined logic, you can also use an Excel formula.

Was this reply helpful? Yes No
Suggested answer

MS.Ragavendar 7,431 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
@CU14062117-0,

If your Excel table has Column A → source column, Column B → target column

Then in Power Automate:

List rows present in a table

Apply to each row

Add a Condition:

If Column A is not empty then

Update a row Set Column B = FP Power Fx - not(empty(items('Apply_to_each')?['ColumnA']))

Else

Set Column B = empty (optional)

✅If this helped, please Accept as Solution to help others ❤️ A Like is appreciated 🏷️ Tag @MS.Ragavendar for follow-ups.

Was this reply helpful? Yes No
Suggested answer

chiaraalina 2,425 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @CU14062117-0

If you want to update the Excel file using Power Automate, your Excel range needs to be formatted as a Table. If it is not already a table, select the data range in Excel, then go to Insert > Table.

After that, you can build the flow like this:

1. List rows present in a table and choose your Excel file

2. Apply to each

3. Condition:

empty(items('Apply_to_each')?['Column1']) is equal to false

If false meaning column A is not empty update column B with.

So when the condition is True:

Update the row

If you do not want to, or cannot, use a Table in Excel, then you do not need Power Automate for this. You can simply use an Excel formula in column B:

=IF(A2<>"";"FP";"")

Hope it helps!

Was this reply helpful? Yes No