
Announcements
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
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.