Power Platform Community Forum Thread Details

Hi, i'm having trouble by using Flow.

Microsoft Flow is creating blank rows and filling a new collumn called "_Powerappsid_". My information is filling at row 5001. Help me please

Categories:

Using flows

Hi @Anonymous,

Could you share a screenshot of your Flow configuration?

I guess you are using Excel connector-action, so the Excel table adds a field called "_Powerappsid_" by default.

This column will add the maximum number of rows to your table by default, which is the number of rows in the table you set at the beginning. Powerappsid is automatically generated to be able to identify each specific row later.

If you don't want to have those blank rows, you could configure Get rows-Delete row to remove blank rows after your previous action.

If a non-empty column is empty, delete the row. You could also use “@and()” to determine if it is indeed a blank row if multiple columns are empty.

Like:

@and(empty(items('Apply_to_each')['Title']),empty(items('Apply_to_each')['Column2']), empty(items('Apply_to_each')['Column3']), empty(items('Apply_to_each')['Column4']))