web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps Booking System for Gym

Power Apps

Answered

Booking System for Gym

(0) Share

Report

Report

Posted on by TrucoBen123

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.

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (1)

Answers Img

Answers (1)

Verified answer

v-JessicaG-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
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:

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:

For the usage of controls and functions, please refer to the following links:

Patch function in Power Apps (contains video) - Power Apps | Microsoft Docs

Edit form and Display form controls in Power Apps - Power Apps | Microsoft Docs

Best Regards,

Jessica Gu

Was this reply helpful? Yes No

Join the conversation