You’re offline. This is a read only version of the page.
104
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:
Share
Report{
"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"
]
}
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.
All responses (
Answers (
skip(body('Parse_JSON'),1)
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
