Thanks for watching all, feel free to leave any questions in the chat for me. Right now I have so many questions lined up they can last until 2025 😍. We will try to get to them all!
Thanks for this. I am getting back into software after a 6 year hiatus and trying to determine if PowerApps would be good for a client. I was following along fine until you lost me in SharePoint. For a beginner video, it left out some of the steps for creating the list. I am not sure why, when the datasource at 8:58 is connected to the form you get a drop down for the food. Also, not sure when the Food types were added. I must be missing something. Is there another list of Food populating the Food drop down? How did the app know to show a drop down? Is there a missed segment after 8:25 on making the drop down? Otherwise, it all worked. Thanks.
Hi Gary, This was added on the SharePoint side, in the list not in Power Apps. The Food column was created as a choice field and the choices were set in SharePoint. I may have skipped over that part. Here is an example from a random blog I found: blog.enterprisedna.co/adding-sharepoint-choice-field-in-a-list/
Hi @lijunchen the AI tool used here is Leonardo.AI, you can actually use it for free daily! Check it out! It's wonderful! Also, I don't work for them 😀 I truly enjoy the product.
So, #1 people outside the organization can use your app, if they have a license somewhere else. If they have M365 and a license in their own tenant, then they can use Power Apps. Another option is Power Pages for full customization based on a consumption model. Finally the simplest way is to use MS Forms. MS Forms is public facing.
Helped a lot, especially the part where you changed the default mode to new, because that is exactly where I was stuck and could not understand why. When you write the formula for the button (Submitform...) what if I have two lists? One is the database where I would like the info to be saved after hitting submit and another list where the data comes from to create the form. How do I have the info saved to the database and not to the other list. Thank you. Because in your video you created one list.
Hey man, I added the three columns into the list (Name, Food and Guests) like you did but however whenever I import the form in power apps and connected the data via sharepoint, it doesn't give food a drop down menu. Can you explain to me please how you did that? Thanks. Edit : I realised I just needed to edit it and under type it needs to be changed to choice, my bad.
Hi Michelle, seems like you got it? There are 2 ways, 1 You can change it to choice field in SharePoint. 2. You can replace the text field in Power Apps with a dropdown and change the update property of the card to write the new dropdown instead.
@@andrewhess123 Hi Andrew! yes I got sorted, it was my bad for watching the video with CC as it mustn't have picked it up. Your videos are fab, thanks for replying to my issue!
Hi Andrew, If I don't use form and I am creating input directly in screen for more control and then if I want to refresh all the field when I click submit then what should I use script in fx
Hi vivek I have a few videos where we go over this, but if you want more of a custom form you will use patch. You need to set up all your default or defaultselecteditems properties for every field. There are other tricks like using a variable in your Reset field to trigger Reset action in all you fields. You have a few options on how to do this and it also there are some differences between Modern and Classic. Here is a newer video where I set up a custom modern form: th-cam.com/video/EVAwMmc9qos/w-d-xo.html
Hi Andrew, your videos have been very helpful for me to learn create an app. I am trying to create an input form for purchase order and save the data to SharePoint. I um unable to share a screenshot but basically the master details for a PO would have PO number, vendor name, approver, etc. The details part is where I add new lines via a button for Qty, unit price, Amount and would like to save each line to SharePoint in a separate row and copy same master data for each row. Would you be able to make a video to show how to do this? Thanks!
I have just started PowerApps and this is a great video to start of with. Can you guide me to any of your videos wherein the Users can edit their submitted responses and the database be it SharePoint List or Dataverse would also capture the name and email address of the User along with his Manager? That would help. Many thanks.
Hi Shubhabrata, there are a few different ways to do this, I'm not sure I have the exact video you are looking for... but this is something I should create. But what you would do is default your user field to User().Email, and to grab manager you may have to pull in another connector. But I will write this down, thank you for the idea.
Hey Andre, love your videos, but did you remove a bunch of your SharePoint videos? I was in the middle of following along on custom list formatting and now I cannot find it anywhere
![NISAMANEE - TADA (ท้าดา) [ OFFICIAL MV ]](http://i.ytimg.com/vi/hcQHEPMmJpU/mqdefault.jpg)
Thanks for watching all, feel free to leave any questions in the chat for me. Right now I have so many questions lined up they can last until 2025 😍. We will try to get to them all!
Could you also do a video where form entries can be reviewed and edited by the person who entered them please.
Hi Nicholas this sounds like a good video idea. I will write it down. @@nicholascresswell8647
Very nicely explained the components and logic. I have seen many people giving tutorials, in my opinion. You Shine keep it up Andrew
Thank you Tariq, I appreciate that!
Thanks for this. I am getting back into software after a 6 year hiatus and trying to determine if PowerApps would be good for a client. I was following along fine until you lost me in SharePoint. For a beginner video, it left out some of the steps for creating the list. I am not sure why, when the datasource at 8:58 is connected to the form you get a drop down for the food. Also, not sure when the Food types were added. I must be missing something. Is there another list of Food populating the Food drop down? How did the app know to show a drop down? Is there a missed segment after 8:25 on making the drop down? Otherwise, it all worked. Thanks.
Hi Gary, This was added on the SharePoint side, in the list not in Power Apps. The Food column was created as a choice field and the choices were set in SharePoint. I may have skipped over that part. Here is an example from a random blog I found: blog.enterprisedna.co/adding-sharepoint-choice-field-in-a-list/
Once you create it as a choice field, then you will need to refresh your datasource in Power Apps for it to get the new update.
By the way, what AI tool do you use to create the pretty background image?
Hi @lijunchen the AI tool used here is Leonardo.AI, you can actually use it for free daily! Check it out! It's wonderful!
Also, I don't work for them 😀 I truly enjoy the product.
@@andrewhess123 Just tried it out. It is generating amazing images. Thanks a lot.
It is amazing!@@lijunchen
Great video. Clear and straight forward instructions. Is there anyway you can use the app for people outside your organization?
So, #1 people outside the organization can use your app, if they have a license somewhere else. If they have M365 and a license in their own tenant, then they can use Power Apps.
Another option is Power Pages for full customization based on a consumption model.
Finally the simplest way is to use MS Forms. MS Forms is public facing.
@@andrewhess123 Thank you for your advice.
Helped a lot, especially the part where you changed the default mode to new, because that is exactly where I was stuck and could not understand why. When you write the formula for the button (Submitform...) what if I have two lists? One is the database where I would like the info to be saved after hitting submit and another list where the data comes from to create the form. How do I have the info saved to the database and not to the other list. Thank you. Because in your video you created one list.
Hey man, I added the three columns into the list (Name, Food and Guests) like you did but however whenever I import the form in power apps and connected the data via sharepoint, it doesn't give food a drop down menu. Can you explain to me please how you did that? Thanks.
Edit : I realised I just needed to edit it and under type it needs to be changed to choice, my bad.
Hi Michelle, seems like you got it? There are 2 ways,
1 You can change it to choice field in SharePoint.
2. You can replace the text field in Power Apps with a dropdown and change the update property of the card to write the new dropdown instead.
@@andrewhess123 Hi Andrew! yes I got sorted, it was my bad for watching the video with CC as it mustn't have picked it up. Your videos are fab, thanks for replying to my issue!
@@MichelleT-z1t Awesome Michelle, thanks for watching, have a wonderful day!
Hi Andrew, If I don't use form and I am creating input directly in screen for more control and then if I want to refresh all the field when I click submit then what should I use script in fx
Hi vivek I have a few videos where we go over this, but if you want more of a custom form you will use patch. You need to set up all your default or defaultselecteditems properties for every field. There are other tricks like using a variable in your Reset field to trigger Reset action in all you fields. You have a few options on how to do this and it also there are some differences between Modern and Classic. Here is a newer video where I set up a custom modern form: th-cam.com/video/EVAwMmc9qos/w-d-xo.html
Hi Andrew, your videos have been very helpful for me to learn create an app. I am trying to create an input form for purchase order and save the data to SharePoint. I um unable to share a screenshot but basically the master details for a PO would have PO number, vendor name, approver, etc. The details part is where I add new lines via a button for Qty, unit price, Amount and would like to save each line to SharePoint in a separate row and copy same master data for each row. Would you be able to make a video to show how to do this? Thanks!
The way you explain is great. Thanks
Thanks Christophe, I appreciate that!
I have just started PowerApps and this is a great video to start of with. Can you guide me to any of your videos wherein the Users can edit their submitted responses and the database be it SharePoint List or Dataverse would also capture the name and email address of the User along with his Manager? That would help. Many thanks.
Hi Shubhabrata, there are a few different ways to do this, I'm not sure I have the exact video you are looking for... but this is something I should create. But what you would do is default your user field to User().Email, and to grab manager you may have to pull in another connector. But I will write this down, thank you for the idea.
Hey Andre, love your videos, but did you remove a bunch of your SharePoint videos? I was in the middle of following along on custom list formatting and now I cannot find it anywhere
Nope, not that I am aware of, i've only ever deleted like 2-3 videos
Thanks for watching though Kevin! Maybe this is the one you were looking for? th-cam.com/video/h3m-U7jQnMQ/w-d-xo.html
Hi Andrew, you move too quickly! If you do another beginner's video, please consider we don't know everything you do. Frustrating
Sorry ILE PMO, I will try to slow down more. You are 100% right though.