Power Platform Community Forum Thread Details

All,

I have an export button in my Power App that triggers my flow to run and export the collection/gallery data into an excel file.

I want to know if it's possible to export all the data besides the first row in my Power App.

Parse JSON formula:

{
 "type": "array",
 "items": {
 "type": "object",
 "properties": {},
 "Date": {
 "type": "string"
 },
 "EmployeeName": {
 "type": "string"
 },
 "Friday": {},
 "LaborCode": {},
 "Monday": {},
 "Phase": {},
 "Project": {},
 "Saturday": {},
 "Sunday": {},
 "Task": {},
 "Thursday": {},
 "Total": {},
 "Tuesday": {},
 "Wednesday": {}
 },
 "required": [
 "Date",
 "EmployeeName",
 "Friday",
 "LaborCode",
 "Monday",
 "Phase",
 "Project",
 "Saturday",
 "Sunday",
 "Task",
 "Thursday",
 "Total",
 "Tuesday",
 "Wednesday"
 ]
}

Categories:

Building flows

Hi @aishak12 ,

Do you want to get the data from the collection or Gallery except the first row?

I have made a test for your reference.

1. Here is my collection.

2. You could use the Skip() function in Flow to remove items from the front of a collection, and return all the other items.

skip(body('Parse_JSON'),1)

https://docs.microsoft.com/en-us/azure/logic-apps/workflow-definition-language-functions-reference#skip

Result Screenshot:

3. Besides, there is another method for your reference, you could use the LastN() function in the App to get the data except the first row.

'PowerApp->yourflow'.Run(JSON(LastN(yourcollectionname,CountRows(yourcollectionname)-1)))

https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/functions/function-first-last#examples

Result screenshot:

Best Regards,

Charlie Choi

Community site session details

Skip first row for Power Apps Export button

Helpful resources

News and Announcements

Quick Links

Introducing the 2026 Season 1 community Super Users

Kudos to our 2025 Community Spotlight Honorees

Congratulations to the March Top 10 Community Leaders!

Leaderboard > Power Automate

Featured topics

Product updates