You’re offline. This is a read only version of the page.
Announcements
22
I am new to power apps and would like to create a simple booking system for a gym. How do you save this submission to a excel sheet with the time slots and date in a excel file. Thanks.
Hi @TrucoBen123 ,
Using Excel files in Power Apps requires converting the data into table format, and you could upload the Excel files to OneDrive or SharePoint to connect it.
1. You could use a formula in the "OnSelect" property of the button control, and use the "Patch" function in the formula to add the selected "time slots" control and "date" control value to the specified column in the excel file.
formula:
Share
Report
All responses (
Answers (
Time(Value(startHourValue.Selected.Value), Value(startMinuteValue.Selected.Value), 0) & "-" &Time(Value(endHourValue.Selected.Value), Value(endMinuteValue.Selected.Value), 0)
Patch(Table1, Defaults(Table1), { Dates:dates.Text,'Time slots':timeslots.Text})
2. You could also add controls that select the "time slots" value and "date" value to the Form contro,l and use the "Submitform" function in button control to add data to the excel data source.
results:
Best Regards,
Jessica Gu
