
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.
Is there a way to filter, empty data, Do you have any idea how to do it?
Thanks You!!
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