You’re offline. This is a read only version of the page.
Is there a way to make a excel workbook that only displays the columns that has data send from the PowerApps or make visiable only columns that hava data into them? Is there any way to clear out the data already in an excel workbook before replacing the data with new data?
Hi @v-bacao-msft ,
How can the Delete Row action tell which ones are blank. Is there a way of doing this through Dynamic Content? Can you take a screenshot please?
Thanks in advance.
Hi @Anonymous ,
Currently, Flow only supports deleting rows. It does not support deleting columns.
I am afraid there is currently no suitable method to achieve your needs.
If you want a similar feature to be supported by MS Flow, please consider submitting your suggestions in the ideas forum:
https://powerusers.microsoft.com/t5/Flow-Ideas/idb-p/FlowIdeas
Best Regards,
Hello @v-bacao-msft ,
Would this delete any empty columns? I have a template already set up and I can delete empty rows now, but I need to find a way to delete empty columns.
Hi @Anonymous ,
The prerequisite for achieving your needs is that an Excel table has been defined in advance in the Excel spreadsheet.
Then you could use List rows present in a table action to get all the rows in the table and use condition to determine if the specified field is empty.
If all of the above conditions are met, then you could use Delete row action to remove the blank rows. It is recommended to use a non-empty field with a unique value as the key column to delete rows.
The basic structure of Flow is consistent with the above, and there are many posts in the community about removing blank rows for reference. You could also try to create a Flow based on the above description. If you have any questions, please ask.
Best Regards,
Hi everyone,
I have figured out how to remove blank row, but I do not know how to remove blank columns from a excel spreadsheet.
#1
Michael E. Gernaey
497
Super User 2025 Season 2
#2
David_MA
436
Super User 2025 Season 2
#3
Riyaz_riz11
244
Super User 2025 Season 2
Share
Report
All responses (
Answers (