Hi there, hopefully I found the right video. So I have a project to develope and wanted to automate flight, hotel and car rental bookings. Following your video I created columns for each area so obviously the list is longer. Can I do it in this way or should I create 3 separate folders? Next, only 1 person will be able to view the database while the other heads of departments will simply make the booking, so my aprovall stage is not so long. Also, is it possible to autamatically insert a list of names based on the destination? Because each destination will have different people who will go there. Obviosuly the same people will also stay at the hotels or rent the cars or whatever. I tried on my own using dataverse tables, solutions and creating the 3 apps based on the type of booking, but was made aware that it was still too manual, thus I was wondering how to make it less manual possible, like with automatic name insert based on the destination and based on the name the role and department of that person also automatically inserts. For the rest it can be manually typed in, but wanted to automate as much as possible. Right now I've reached "Setting Up Your SharePoint List for Power Apps Travel Request App (Part 1)", so I beleive to be done creating my columns. I would really appreciate your help/step by step guide as on my own and not being able to write code as this app will be shared online with the organization I am restricted to using power automate, power apps, sharepoint etc.
Hi, Thanks for watching my video. I think the way you have it set-up in one list is fine since the bookings will all be done by the same person. It will be easier to retrieve that information when you need it later. In regard to automating the entry of the information, that information will have to be stored in a separate list (name of person, associated destination of person, role, etc.) In your form, you can filter that list based on the name of the person, which would then capture the other associated information. Hope that makes sense.
@@OptimalTrainingGroup So I am trying but it doesn,t work I am writing a formula in the onchange of the cell where the user will type the person's name and tried to connect the formula to the cell where the destination should pop up. For reference I use (;) as syntax but I am just getting a bunch of errors. Saying that the name of my column in sharepoint is not valid even though the column is literally called name etc. because I am using the lookup function within my formula.
Also after a booking has been made, I need the information to be presented as a pdf file so that it can be sent, printed etc. by those interested parties. This would be the final stage, is it possible to do?
Hi there, hopefully I found the right video. So I have a project to develope and wanted to automate flight, hotel and car rental bookings. Following your video I created columns for each area so obviously the list is longer. Can I do it in this way or should I create 3 separate folders? Next, only 1 person will be able to view the database while the other heads of departments will simply make the booking, so my aprovall stage is not so long. Also, is it possible to autamatically insert a list of names based on the destination? Because each destination will have different people who will go there. Obviosuly the same people will also stay at the hotels or rent the cars or whatever. I tried on my own using dataverse tables, solutions and creating the 3 apps based on the type of booking, but was made aware that it was still too manual, thus I was wondering how to make it less manual possible, like with automatic name insert based on the destination and based on the name the role and department of that person also automatically inserts. For the rest it can be manually typed in, but wanted to automate as much as possible. Right now I've reached "Setting Up Your SharePoint List for Power Apps Travel Request App (Part 1)", so I beleive to be done creating my columns. I would really appreciate your help/step by step guide as on my own and not being able to write code as this app will be shared online with the organization I am restricted to using power automate, power apps, sharepoint etc.
Hi, Thanks for watching my video. I think the way you have it set-up in one list is fine since the bookings will all be done by the same person. It will be easier to retrieve that information when you need it later. In regard to automating the entry of the information, that information will have to be stored in a separate list (name of person, associated destination of person, role, etc.) In your form, you can filter that list based on the name of the person, which would then capture the other associated information. Hope that makes sense.
Ok, I think I get it. I’ll have to try it
@@OptimalTrainingGroup So I am trying but it doesn,t work I am writing a formula in the onchange of the cell where the user will type the person's name and tried to connect the formula to the cell where the destination should pop up. For reference I use (;) as syntax but I am just getting a bunch of errors. Saying that the name of my column in sharepoint is not valid even though the column is literally called name etc. because I am using the lookup function within my formula.
Also after a booking has been made, I need the information to be presented as a pdf file so that it can be sent, printed etc. by those interested parties. This would be the final stage, is it possible to do?
Yes, this is possible. You have to use power automate. There are tons of videos on it on youtube.