Thanks for taking the time to share. Its great to see the errors/issues and then how you resolve them. 👍👍
@jeffrhodes
2 жыл бұрын
Glad this was helpful. Thanks for watching!
@elizabeththornburg9485
2 жыл бұрын
Thank you so much for this video! I am slowly working on building an app using your instruction. I did manage to make the Patch function for the status update work using a different route. So instead of Status: varBookedStatus, I was able to use Status: {Value: "Booked"} with no error.
@jeffrhodes
2 жыл бұрын
Good to hear! Yes, the varBookedStatus variable ended up being a bad idea. I switched to {Value: "Booked"} as well. I kept running into problems where the varBookedStatus would revert back to "Available" and cause errors.
@ToniCulu
8 ай бұрын
Dude u just saved my ass. You are good at teaching thank u
@jeffrhodes
8 ай бұрын
Glad this was helpful!
@victoriasymons9295
2 жыл бұрын
This is really useful, thank you for sharing. This is great for newbies like me. I would like use this approach for a simple desk booking app. I've only 4 desks, each bookable by the day. I hope to find a way to use flow to set up the desks. I've plugged in a date picker and can filter the gallery by availability and date. I've added a book button to each item in the Gallery but I am struggling to find a method to update the status column from available to booked without creating a new booking in my list.
@jeffrhodes
2 жыл бұрын
It sounds like you are close. I don't think you need Power Automate/Flow in this case but you should be able to patch the existing reservation (see around minute 23 in the video). Note that instead of the varBookingStatus variable, you can set the value directly as in {Value: "Booked"}. The key is using the LookUp function for the second parameter of Patch() to tell it which list item you are upcating.
@TheGodfather360
8 күн бұрын
Is the appointment length in your sharepoint list? I didn't see it
@jeffrhodes
8 күн бұрын
Good eye. There is an AppointmentLength column set as Number with a default value of 20. I didn't scroll the SharePoint list view to the right enough to show that.
@urdecisionisurs
Жыл бұрын
I am trying to create a onboarding request that the requester has to include training certificates. Then I need to be able to provide them status and use a drop down based on their org; I want to use sharepoint and forms; where should I start? Great video and I bought your book
@jeffrhodes
Жыл бұрын
Thanks for the kind words and the book purchase! If the user doesn't need to edit the information after submitting, then a Microsoft Forms - Power Automate - SharePoint list solution should work well. You can use Power Automate to copy each form response to SharePoint as in this video: kzitem.info/news/bejne/rZho1oCkhWmGqGk. The hardest part will be getting the attachments (training certificates). Do that in the same Power Automate flow right after you create the item. This video should help with that: kzitem.info/news/bejne/ln-vqYp-qqh6i3Y. Hope this is helpful.
@mrnobodyjo
2 жыл бұрын
Hi Jeff, thank you for this! Can this work in a setting where we have a team of 3, and we want to publish the app so that everyone in the company can pick any one hour appointment, that consumes 1 of 3 availabilities for 9am, for example. So that a 6 time slot day will have 18 availabilities. However, users looking up availabilities will only see 6 time slots to pick from any day they click on. The calendar will also have a start date and an end date, where anything outside this range isn't bookable.
@jeffrhodes
2 жыл бұрын
This is basically the use case that this solution is designed for. The main difference is that each of the three availabilities for 9 AM would show up initially. Then they would disappear as they are booked. You wouldn't need the start and end dates since you only add items to the SharePoint list that you WANT booked. So you could add the next month's appointments on the 15th of the previous month if desired. You can also set logic on the cancellation of appointments so those can't be done within 1 day of the appointment if desired. I should also mention that you might want to use Bookings for this whole process instead if that is available to you.
@Giu.Tanaka
2 жыл бұрын
Hey, Jeff! This video was very useful! Can you explain how did you fixed de person column issue in power apps? I re-watched but I couldn't understand. I saw you used the var instead combox.
@jeffrhodes
2 жыл бұрын
Good to hear. Can you give me more details on your question? There were some challenges in configuring the combobox (around 11:30 in the video). Later, I saved the email address of the selected user in the OnSelect event so that I could use that in my later logic.
@Giu.Tanaka
2 жыл бұрын
@@jeffrhodes thanks!
@wallvids
2 жыл бұрын
I’m getting an error on ID=varSelectedApt.ID. Is ID supposed to be from the SharePoint list?
@jeffrhodes
2 жыл бұрын
You will want to set varSelectedApt in the OnSelect event on the Gallery. That will look up the selected row/item with the row that you want to update.
@ismailmotala2
Жыл бұрын
Can you make a video on the SharePoint you used for the database at the start? Thanks so much
@jeffrhodes
Жыл бұрын
Hi Ismail - there is a pretty good view of the SharePoint list at about 50 seconds into the video. Main thing is a date column for the appointment, a person column for the participant, a status (booked, available), a subject, and notes. Hope that helps.
@joshuabailey1290
Жыл бұрын
Hi Jeff, For the ComboBox is there a way to pull Users from a out Global Address List instead of 365 Users? Thanks for the help
@jeffrhodes
Жыл бұрын
Hi Joshua - my experience is that the 365 Users IS the Global Address List. But if that is not the case (e.g. an on-premise versus Azure Active Directory), I'm not aware of how to link to a different set of users. If anyone knows how to do that, please chime in.
@TheRealSykot1k
Жыл бұрын
Is it possible to Filter the Gallery by showing Appointments Available for just Mondays of that week for example?
@jeffrhodes
Жыл бұрын
Great question. You can use the Weekday() function to get the day of the week from a date. You might be able to do a variation of the filter in this post to limit to Mondays or whatever: www.matthewdevaney.com/power-apps-filter-a-gallery-by-date-range-examples/power-apps-filter-gallery-by-dates-in-next-n-weeks/.
@joshuajames7231
2 жыл бұрын
was that a list that you pulled those dates from ? or was it a calendar connected to the contents of sharepoint ?
@jeffrhodes
2 жыл бұрын
I used a SharePoint list for this.
@joshuajames7231
2 жыл бұрын
@@jeffrhodes Thank you, and do you know how to fix time zone issues ? I added my data and the time was two hours more than what I had originally.
@jeffrhodes
2 жыл бұрын
@@joshuajames7231 I did notice in our actual implementation that the times were adjusted for my actual time zone. This might be happening if your SharePoint list is in a different time zone than your area. But if you put in the date and time for THAT time zone, it should then show up correctly for each user no matter their time zones. Hope this helps.
@Punjabgovtjob
2 жыл бұрын
*nice*
@kelvinvelazquez8758
2 жыл бұрын
👍🏽
@TheNsmallwood
Жыл бұрын
How did you create the appointment length data field?
@jeffrhodes
Жыл бұрын
Hi Nicole. The AppointmentLength column is in the SharePoint list and is of type Number. I set its default value to 20 as that is normally the length of the scheduled meetings. Hope this helps.
Пікірлер: 33