Answered

Flex Office App

(0) Share

Report

Posted on by Hii_iii

691

Hello, I'm trying to create a rather complicated application on Power Apps. The purpose of my application is to reserve an office for a date.

I have a SharePoint list that looks like this:

This SharePoint list stores all office reservations.
"Name" column: Type People Picker (Indicates the name of the person who booked the room)
"Date" column: Type Date (Indicates the date of the reservation, chosen on the calendar screen on power apps)
"Number_Office" column: Number type (Indicates the office number reserved by the user)

This is how my Power Apps app looks:

My first screen is a calendar screen. I would like that when the user clicks on the "Continue" button, it redirects him to the second screen so that he can reserve an office on the chosen date.

The second screen contains an image of a room with several desks. When the user has chosen a date on the previous screen, I would like it to automatically redirect him to this page. To choose a desktop, I'd like them to simply click on a blue circle.

Thank you in advance for your help. I can't get what I want at all 😞

Categories:

Building Power Apps

I have the same question (0)

All responses (18)

Answers (1)

Hii_iii 691 on at

Like (0)

Report

.

Was this reply helpful? Yes No
LuizVicente 984 Super User 2024 Season 1 on at

Like (0)

Report

In the OnChange property of the date control, use the Navigate function to go to the desired screen. The blue circles I imagine are buttons with the border-radius property at 100, right?

Was this reply helpful? Yes No
Hii_iii 691 on at

Like (0)

Report

Yes that's it. But I don't know how to make it save the reservation in the SharePoint list just by clicking on the button @LuizVicente

Was this reply helpful? Yes No
LuizVicente 984 Super User 2024 Season 1 on at

Like (0)

Report
It's actually simple and there are several ways.
For example, if you have a column in the SharePoint list called "SelectedRoom" (it is the column that will contain the selected room), you can save the data with the Patch function. It would be more or less like this:

Patch( MySPList, Defaults(MySPList), { SelectedRoom: "Room 1", // -> Enter the room name for each blue button here. SelectedDate: DatePicker.SelectedDate // rest of your code } )

Was this reply helpful? Yes No
Hii_iii 691 on at

Like (0)

Report

Thank you for your reply. But I don't quite understand where to write this code? @LuizVicente

Was this reply helpful? Yes No
LuizVicente 984 Super User 2024 Season 1 on at

Like (0)

Report

Oops.. sorry about that. You will put this code in the OnSelect property of each button.

Was this reply helpful? Yes No
Hii_iii 691 on at

Like (0)

Report

Sorry but it's doesn't work 😞

Was this reply helpful? Yes No
LuizVicente 984 Super User 2024 Season 1 on at

Like (0)

Report

The values inside the braces { } must be separated by commas.
Hover over the code to understand what the error is.

Was this reply helpful? Yes No
Hii_iii 691 on at

Like (0)

Report

In France it is with semicolons.

The error is this :
The type of this argument "Date" does not match the expected type "Date". Type found "Error"
@LuizVicente

Was this reply helpful? Yes No
LuizVicente 984 Super User 2024 Season 1 on at

Like (0)

Report

Right.
Check the data type of the SharePoint column that will receive the date value.

Was this reply helpful? Yes No