Create Brand New Excel File Based on Gallery Selection in Power Apps

Ever need a brand new Excel file or .csv from a selection in Power Apps. In this tutorial, we will show you how to create an Excel file directly from a Gallery selection in Power Apps! Learn how to capture data from your app's gallery and export it into a neatly formatted Excel file with just a few clicks. This step-by-step guide is perfect for anyone looking to improve their app's functionality and streamline data management. Don't forget to like, comment, and subscribe for more Power Apps tips! Video to create Gallery Selection: https://youtu.be/hIDRup4LcHE Export JSON in Power Apps: Set(varJSON,JSON(colSelection,JSONFormat.IgnoreUnsupportedTypes & JSONFormat.IgnoreBinaryData & JSONFormat.IndentFour & JSONFormat.FlattenValueTables)); ExportToExcel.Run(varJSON); 1. PowerAppsV2 with JSONInput 2. Initialize variable 3. Parse JSON 4. Select 5. Compose Excel File Name: ExcelFile_@{formatDateTime(utcNow(),'yyyy-MM-dd_hhmmss')}.xlsx 6. Send HTTP: _api/web/GetFolderByServerRelativeUrl('Shared%20Documents')/Files/add(url='@{outputs('Compose_Excel_File_Name')}',overwrite=true) 7. Create CSV: @{body('Select')} 8. Create Table: @{body('Send_an_HTTP_request_to_SharePoint')['d']['UniqueId']} Column Names: @{first(split(body('Create_CSV_table'), decodeUriComponent('%0A')))} 9. Add a row: file: @{first(split(body('Create_CSV_table'), decodeUriComponent('%0A')))} Row: Current item Chapters: 0:00 Introduction 3:02 Power Apps (V2) Trigger 4:10 Write JSON Equation in Power Apps 8:15 The Bulk of the Power Automate 10:20 Select from the JSON 12:45 Send HTTP Request to Create Excel 15:28 Create CSV Table 16:54 Trouble Shooting an Error 18:25 Create Excel Table 20:20 Looping through our Rows 22:40 Conclusion