web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate - Building Flows / Filter empty rows in e...
Power Automate - Building Flows
Unanswered

Filter empty rows in excel (excel online connector)

(0) ShareShare
ReportReport
Posted on by ebonshark 12

I'm trying to optimize a flow that currently picks up an *.xls file in attachment of an email, converts it in *.xlxs , then creates an Excel Table in one specific Tab with the intent to List Rows, and Add a Row to  SharePointList.

 

but it contains blank fields, so it gives me an error when loading them in sharepoint list

There is a way to filter the empty columns and separate them from the table, to be able to upload only the data with value.

 

ebonshark_0-1698415552473.png

Is there a way to filter, empty data, Do you have any idea how to do it?

Thanks You!!

Categories:
Business Process Flows
I have the same question (0)
  • Unknown geen idee Profile Picture
    Unknown geen idee 1,757 on at
    Re: Filter empty rows in excel (excel online connector)

    Dear E,

     

    If you want to remove columns from a table via PowerAutomate, this can be done, but is tricky.

    Suggest that you would look into either doing this by ensuing that the input for the flow is of a higher quality ... alternatively you may look into 'office scripts' to run in excel which you can trigger from PowerAutomate (but which function outside of this).

     

    If you can live with the empty columns and can just work around it, then you could just loop (Apply to each) through the rows of the output array from your 'List rows' action and simply ignore any empty cells. This can be done with a condition/expression, something like 'empty(items('Apply_to_each')?['field'] = true'.

     

    Hope the suggestions help,

    Happy flowing,

    Koen

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Welcome to the Power Platform Communities

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Chiara Carbone – Community Spotlight

We are honored to recognize Chiara Carbone as our Community Spotlight for November…

Congratulations to the October Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 659 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 386 Moderator

#3
chiaraalina Profile Picture

chiaraalina 290

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