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!
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.
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!
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 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: ruclips.net/video/EVAwMmc9qos/видео.html
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.
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
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!
The way you explain is great. Thanks
Thanks Christophe, I appreciate that!
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
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.
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!
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.
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: ruclips.net/video/EVAwMmc9qos/видео.html
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
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? ruclips.net/video/h3m-U7jQnMQ/видео.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.