You’re offline. This is a read only version of the page.
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
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:
Share
Report
All responses (
Answers (
@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']))Take a try and feel free let me know if issue still exist.
Best Regards,
Barry
#1
WarrenBelz
146,660
Most Valuable Professional
#2
RandyHayes
76,287
Super User 2024 Season 1
#3
Pstork1
65,999
Most Valuable Professional
