Autofill a column in excel

(0) Share

Report

Posted on by Noah100

Hello,

Is there a way to use power automate to autofill all blank rows in an excel table for a specific column? The trigger would be "When an item or file is modified" for a SharePoint file. The flow lists out all rows present in a table and then I need a way for it to view all blank cells in a certain column and change them from being blank to Unassigned.

Let me know if a solution for this exists,

Noah

Categories:

Building flows

I have the same question (0)

All responses (1)

Answers (1)

Verified answer

v-qiaqi@microsoft.com on at

Like (0)

Report
Hi @Noah100,

Do you want to update all the blank rows in a column with string Unassigned?

Could you please share a bit more about your flow?

I have a simple demo for your reference, please check as below:

empty(items('Apply_to_each')?['Status'])
item()?['Title']

Note that Title is the key column in my excel file and Status is the specific column needing updated with Unassigned.

Was this reply helpful? Yes No