How to Customize SharePoint list forms with Power Apps - Beginners Tutorial
In this video, you will learn how to Customize SharePoint list forms with Power Apps. This is a complete step-by-step tutorial for beginners and covers all key concepts needed to customize SharePoint list forms with PowerApps. We will start with the basics of forms customization and then lead into conditional formatting, conditional validations, conditional show/hide for columns, Power Apps form layouts and more.
#PowerApps #SharePoint
Table of Contents:
00:00 - Intro
00:40 - Create a SharePoint list form using Microsoft Lists Template
01:42 - Customize SharePoint list form using Power Apps
05:42 - Add, Remove and Order SharePoint list form columns with PowerApps
07:18 - Add conditional show hide of columns and conditional validations
10:05 - Change the colors (theme) of the SharePoint customized form in Power Apps
11:22 - Publish SharePoint custom form
12:34 - Run Power Apps customized SharePoint form
14:34 - Change screen size of Power Apps customized SharePoint form
16:12 - Add conditional formatting to form
20:01 - Look at version history of form
20:40 - Switch to default SharePoint list form experience
21:11 - Switch to Power Apps customized SharePoint list form
22:20 - Do not use InfoPath
22:35 - Closing and Subscribe
Пікірлер: 692
This is exactly what I needed to get started in Power Apps. Thanks so much.
@RezaDorrani
3 жыл бұрын
Yay! So happy to hear this feedback. I am focusing more on getting started videos. A lot more coming.
I have spent days trying to figure out how to do this exact thing! Thanks for making it easy to follow and practical. I really appreciate this video!
@RezaDorrani
Жыл бұрын
Glad it helped! Thanks for watching.
Thanks so much Reza! I followed along during the tutorial and built my first form. Can't believe how easy you make it!
@RezaDorrani
2 жыл бұрын
Great to hear! Thanks for following along.
Just getting started with Power Apps and tutorials from Reza are extremely helpful. To the point, thank you so much!!
@RezaDorrani
3 жыл бұрын
You are most welcome.
This is very well done, thank you so much! Just enough content to get started in PowerApps without feeling overwhelmed. I will be checking out all your other videos as I get more involved in working with PowerApps and trying not to use InfoPath any longer! 🙂 Thank you again!
@RezaDorrani
2 жыл бұрын
Great to hear! Wish you the best of luck in your Power Apps journey. No more InfoPath :)
This covers it all. Thank you, Reza!
@RezaDorrani
3 жыл бұрын
Thanks Chad
Just what I was looking for! Crisp, to the point and the right mix of basic and advanced options to customise a SP list in minutes. Thanks a lot for this tutorial!
@RezaDorrani
Жыл бұрын
Awesome! Thanks so much for watching.
@meetdenis82
Жыл бұрын
@@RezaDorrani I have a SP form with a field type 'Person or Group'. How do I auto populate the currently logged in username in this field? I tried using User().Fullname but the card is showing an error. Can you help?
@RezaDorrani
Жыл бұрын
@@meetdenis82 I recently did a video on setting default values which includes data cards. Check Set Default Values in Power Apps | Dropdown, Lookup, Choice, Date | SharePoint kzread.info/dash/bejne/lJ6qy8mafJmepNY.html
@meetdenis82
Жыл бұрын
@@RezaDorrani Thanks again!
Explained explicitly. Thank you so much.
@RezaDorrani
2 жыл бұрын
Most welcome.
You do a great job explaining things! Thank you for putting this tutorial out, very helpful.
@RezaDorrani
3 жыл бұрын
Thank You
I was struggling as a complete beginner until I found this video. Thank you so much for this amazing tutorial! Subscribed!
@RezaDorrani
3 ай бұрын
Thanks for the sub!
I greatly appreciate how easy to follow and applicable your videos are. Keep them coming.
@RezaDorrani
2 жыл бұрын
Awesome, thank you!
I watched your multiple PA videos...all concepts are so crystal clear with a solid clear voice...I am surprised why don’t you have million subscribers now...Thank you for helping us in PA...
@RezaDorrani
2 жыл бұрын
Thank You for the sub and thanks for watching the videos. I believe in organic growth of subscribers. If I go about asking or requesting folks to subscribe, they would but may not watch my videos.
That was exactly what I needed. Thank you for making it easy!
@RezaDorrani
2 жыл бұрын
You're most welcome!
Finally, this is what I am looking for. Thank you so much, sir Rezza for this helpful video!
@RezaDorrani
2 жыл бұрын
Glad to hear that! You are most welcome.
Very good overview, learnt more in 20 minutes than with hours of reading "how to" articles. Earned a subscription from me. Thank you Reza!
@RezaDorrani
Жыл бұрын
Thanks for the sub!
This is spectacular! In my current job, I am one of the resident InfoPath experts. We are migrating to SPO and I am having to learn Power Apps and convert some of my highly intricate InfoPath forms. This series of videos is proving quite helpful. I love the level of control I can have without using custom code!
@RezaDorrani
2 жыл бұрын
Thank You for the awesome feedback. Glad to hear the videos are helpful!
@HinaGeo
2 жыл бұрын
Hi JBib, My situation is exactly same as of you and i agree Reza is helping us a lot on it. :)
Easy walk through and nice tutorial! Thanks for that!
@RezaDorrani
3 жыл бұрын
Thanks for watching
Great, thanks for the concise help. Very helpful!
@RezaDorrani
8 күн бұрын
Most welcome
from all of your Tutorial , this tutorial is best and clear. Thank you so much!
@RezaDorrani
3 жыл бұрын
That means I am improving :) Thank you for watching and thanks for the feedback.
That was exactly what I needed and perfectly delivered. Thanks
@RezaDorrani
2 жыл бұрын
Your most welcome
This is exactly what I need. Awesome! Thank you
@RezaDorrani
2 жыл бұрын
You are most welcome
best beginners tutorial i would say, got to learn so many things!
@RezaDorrani
3 жыл бұрын
Thank You 😊
This is exactly what I was looking for! Thank you for the clear and concise explanations.
@RezaDorrani
5 ай бұрын
You're very welcome!
This was a really clear, focused and helpful session. Thank you so much! I'm off to customise a form!🥳
@RezaDorrani
Жыл бұрын
Glad it was helpful! Thanks so much for watching.
ur my saviour! Ive learned updating SP forms via Apps quickly
@RezaDorrani
3 жыл бұрын
Glad to hear that! Thanks for watching
Great tutorial Reza. Great delivery and content ! Thank you !
@RezaDorrani
2 жыл бұрын
Thanks Alex
Thanks Reza! This and your other Power Platform how-to videos may make me a hero in my role! (this year anyway)
@RezaDorrani
Ай бұрын
Thanks so much and best of luck
Great tutorial!!!!!!!!!!Clear explanation and so easy to understand and remember!
@RezaDorrani
Жыл бұрын
Thanks so much
WOW!! This is an excellent place for beginners to get started with PowerApps development. Thank you for sharing your knowledge with everyone.
@RezaDorrani
2 жыл бұрын
You’re most welcome
Thanks so much for this, a really helpful breakdown of Power Apps to help get me started!
@RezaDorrani
Жыл бұрын
You're very welcome!
Fantastic demonstration. Thank you!
@RezaDorrani
Жыл бұрын
Thanks Mark
Getting familiar with SharePoint for some company Onboarding forms and this was helpful, looking for to seeing some more but for on boarding custom forms with automation - thank you Reza!
@RezaDorrani
3 жыл бұрын
I will plan to include some onboarding scenarios in future videos.
Reza, you are a legend. Thank you so much!
@RezaDorrani
2 жыл бұрын
Thanks for your kind words. I love sharing what I learn. I am no legend :)
Thank you Reza , Very clear and It covers all.
@RezaDorrani
3 жыл бұрын
Glad it was helpful!
Very helpful Tutorial !! Thank you so much!!
@RezaDorrani
2 жыл бұрын
You're welcome!
Thank you for this very informative video. You are a great teacher!
@RezaDorrani
2 жыл бұрын
Your most welcome and thanks for watching
Thanks for this video. Tip of the day - Rectangle box fill color with status value is awesome and really waiting for your next video list relationship and show it in tabbed form.
@RezaDorrani
3 жыл бұрын
Thank You
You are a God send! Thank you so much for the relevant tips and how tos!
@RezaDorrani
Жыл бұрын
Most welcome
Thank you Raza, look forward to the next one. -))
@RezaDorrani
3 жыл бұрын
More to come!
Saved My day .This is what is was exactly looking for .Thank You.
@RezaDorrani
Жыл бұрын
Your most welcome
Best video for beginners. Big Thanks Reza.
@RezaDorrani
Жыл бұрын
Your most welcome
Exactly what i was looking for. Thank you so much.👍
@RezaDorrani
Жыл бұрын
You're welcome!
Great video!!...much needed..Thank You!!
@RezaDorrani
3 жыл бұрын
You are most welcome
Raza .. This one is very clear and Incredible.. just watch once and no need to rerun it.
@RezaDorrani
3 жыл бұрын
Thank You
Thanks for this tutorial!
@RezaDorrani
3 жыл бұрын
My pleasure!
PERFECT!!! Thank you Reza!!!
@RezaDorrani
2 жыл бұрын
Great! Thanks for watching.
Excellent! covered all I need to get over the hump converting infopath to powerapps
@RezaDorrani
2 жыл бұрын
Glad it was helpful! Thanks for watching.
Great tutorial,,, thanks... Really lear some basic form building skills.... Looking forward to your next video with depending drop down list...
@RezaDorrani
3 жыл бұрын
Depending dropdowns is done - kzread.info/dash/bejne/e4t5s9mAfMa9Z7Q.html
Awesome video. Really appreciate this, as I have to set up a form soon for customers : )
@RezaDorrani
Жыл бұрын
Thank You Josh
Great one :) Very much helpful for beginners.. Thank a lot for sharing the knowledge
@RezaDorrani
2 жыл бұрын
My pleasure 😊
Thank you Dorrani, for a great tutorial. It sets the problem clearly and provided an easily understood solution.
@RezaDorrani
3 жыл бұрын
Thank you Sani
@SaniGarba
3 жыл бұрын
@@RezaDorrani May I mention to you, as a fact that, for me, the strongest attribute of your presentations is the flawless authority carried in your voice which provides emphasis and invites immediate acceptance and respect. Thank you.
@RezaDorrani
3 жыл бұрын
@@SaniGarba Thank you for the amazing feedback. Motivates me to work harder.
Great Video, Thank you so much, it was useful for me to start.
@RezaDorrani
Жыл бұрын
Glad it was helpful!
very useful video, thank you!
@RezaDorrani
2 жыл бұрын
You're welcome!
Advanced Tutorial and More Features !! lets goo , good content
@RezaDorrani
2 жыл бұрын
Thanks!
excellent tutorial, as always!
@RezaDorrani
3 жыл бұрын
Thank you! Cheers!
Very helpful - you are awesome!!!
@RezaDorrani
3 жыл бұрын
Thank You!
simple and understanding thanks so much
@RezaDorrani
2 жыл бұрын
Glad to hear that!
Thank you so much Reza.. You make my day.. You are underrated..
@RezaDorrani
2 жыл бұрын
Your most welcome. The 💗 to my videos is more important than being underrated. Thank You so much for watching and liking the videos.
Great Tutorial. Thank you.
@RezaDorrani
3 жыл бұрын
You are most welcome
Wow! you are awesome. Thank you so much!
@RezaDorrani
Жыл бұрын
Most welcome
Thank you so much!
@RezaDorrani
Жыл бұрын
Welcome
back to basic ! regards from Italy
@RezaDorrani
3 жыл бұрын
Basics is what I plan on covering.
Great tutorial!
@RezaDorrani
Жыл бұрын
Thanks
Nice . This helped !
@RezaDorrani
6 ай бұрын
Great
Thanks, Reza. It is a big pleasure to follow you.
@RezaDorrani
3 жыл бұрын
Thank You
Great tutorial. I am your fan now.
@RezaDorrani
2 жыл бұрын
Awesome, thank you!
Great as always 👍
@RezaDorrani
Жыл бұрын
Thank you! Cheers!
Very well explained TQ bro
@RezaDorrani
2 жыл бұрын
Most Welcome 👍
eres un crack bro¡¡¡¡¡¡
@RezaDorrani
3 жыл бұрын
gracias
Thanks thanks thanks Reza!
@RezaDorrani
2 жыл бұрын
Most most most welcome!
Great video. 👍
@RezaDorrani
3 жыл бұрын
Thanks 👍
Great Video! One clarity on show and hide options --> if I want published link visible for "published" as well as for "ready to publish" , then what formula should I use in this scenario
@RezaDorrani
3 жыл бұрын
DataCardValue.Selected.Value = "Published" || DataCardValue.Selected.Value = "Ready to Publish" Make sure DataCardValue is replaced with your card internal name.
Thank you.
@RezaDorrani
3 жыл бұрын
You're welcome!
Thanks!
@RezaDorrani
Жыл бұрын
Your welcome
Excellent Video - Very Informative - Thank You
@RezaDorrani
3 жыл бұрын
Glad you enjoyed it!
@jray1429
3 жыл бұрын
@@RezaDorrani Do you mind directing me to one of your videos that helps me move fields around please? I find Power Forms very rigid compared to InfoPath when it comes to moving fields around. I know how to change the order of them, but I’m used to being able to smoothly dragging them around. I’m sure I’m just not doing something right. Thanks!
@RezaDorrani
3 жыл бұрын
@@jray1429 Here you go - kzread.info/dash/bejne/k4p5w7Spcc_HhKQ.html
@jray1429
3 жыл бұрын
@@RezaDorrani You are incredibly helpful. Very Impressed‼️
excellent content!
@RezaDorrani
2 жыл бұрын
Much appreciated!
As always thank you Reza
@RezaDorrani
3 жыл бұрын
Thanks for watching Marcelo
@cptcavernicola
3 жыл бұрын
I have all your videos on a play list
@RezaDorrani
3 жыл бұрын
@@cptcavernicola Wow!!! Thanks
Amazing Raza!
@RezaDorrani
2 жыл бұрын
Thank you!
Awesome 👍
@RezaDorrani
3 жыл бұрын
Thanks Ranjit
Thanks again for the great tutorial. Have you created a tutorial on SharePoint forms using sharepoint designer?
@RezaDorrani
2 жыл бұрын
SharePoint designer in Office 365 is not recommended to be used. Check JSON based SO Form customization- kzread.info/head/PLTyFh-qDKAiE7C_2lVNAPzgHXsBykG0Tf
Thanks Reza, great tutorial. Could you provide a demo on how to use Dynamic Forms for SharePoint please.
@RezaDorrani
2 жыл бұрын
Dynamic forms tutorial kzread.info/dash/bejne/qYWlx9aBYrSyqc4.html
Thank you for sharing such s good content . Could you please explain how to change the controls of save and cancel button .
@RezaDorrani
2 жыл бұрын
Save & Cancel are a part of SP customized list forms with Power Apps. I don't think they can be changed.
This is awesome, so clear, and easy language! May we please know how we can have different forms/views for a new item, and view/edit existing.
@RezaDorrani
Жыл бұрын
Why not reuse the same form control? More forms more controls more complexity
thnk you, sir
@RezaDorrani
8 ай бұрын
Welcome!
thank you very much for this video , please i need to print form using custom print button in PowerAPP
@RezaDorrani
2 жыл бұрын
SP Customized list forms do not support printing.
This is just an excellent tutorial. You are a great teacher and really appreciate all that you do. Do you have a tutorial on how one can send an email from a customized SharePoint list from only when a new request is logged? I have seen a few videos where a custom submit button was added to the form but need guidance on using the default SharePoint experience for this.
@RezaDorrani
3 жыл бұрын
The technique for sending an email will be the same for SharePoint customized list forms as well. Add a button and send email OR there is a function called OnSuccess on form control - You can send an email here by checking form mode as new.
@shakadezulu8615
3 жыл бұрын
@@RezaDorrani Thanks
Thanks
@RezaDorrani
Жыл бұрын
Thank You
Thanks Reza
@RezaDorrani
3 жыл бұрын
Your welcome
Great video! Do you have one for creating a different form view depending on if you are adding a new item or editing an existing item?
@RezaDorrani
9 ай бұрын
I typically reuse the form control by changing the form mode. kzread.info/dash/bejne/k4p5w7Spcc_HhKQ.html
As always, nicely explained. One question: how would you handle a choice column with “can add values manually” settings in power apps form?
@RezaDorrani
3 жыл бұрын
I don't believe there is a direct option for that. You would have to create a text box and build that scenario. Something that I have not tried.
Another great tutorial, Reza. Thank you. Following this tutorial to customize the SP form for a List works exactly as described. However, doing the same in a Document Library appears to work differently. Example: Invoking the Details pane from a document opens the default SP form, in edit mode. When you click "edit all" the PowerApps version is displayed and all is well from there. Any idea how to have the doc library PA form work like the List version? Thanks.
@RezaDorrani
2 жыл бұрын
Thank You for liking the video. Document Library version kzread.info/dash/bejne/imGcqK-Ge9i2o7A.html
Reza you are amazing thank you so much for making this. I have one question if we click on the new button only limited fields should be displayed but on edit, all fields should be displayed if this is possible, please tell me how.
@RezaDorrani
Жыл бұрын
Possible by checking form mode. I have done numerous videos on form control.
Hi this is really helpful, thank you. I wonder what are the steps needed if this sharepoint list integration is just one aspect of the powerapps, meaning there are other flows in the apps that I want to build. Is there a video to help with that?
@RezaDorrani
2 жыл бұрын
Apps & flow integration - kzread.info/head/PLTyFh-qDKAiE8Cl15mz1wMNz2nUbgXFGU
Outstanding video! A perfect amount of detail and an easily relatable use case, all professionally presented. Question: have you ever tried to access the customised list form as an external user to a Teams Shared Channel? Works fine for internal-to-tenant users but fails when collaborating with external users. Does it work for you?
@RezaDorrani
Жыл бұрын
Thanks David. External users will need a Power Apps license.
@davidadams421
Жыл бұрын
@@RezaDorrani Got that.
thanks Reza for this video. Could you please show us how to export/import list attached PowerApps form to another environment e.g. Dev > UAT > Prod.
@RezaDorrani
2 жыл бұрын
Currently, SharePoint customized list forms do not support ALM.
Great video! Just what I needed to get started. Do you know a source of a formula cheat sheet for form customization?
@RezaDorrani
2 жыл бұрын
Thanks Trevor. Forms customization - kzread.info/dash/bejne/k4p5w7Spcc_HhKQ.html
Thanks Reza for a great tutorial! Is there a possibility of history tracking for data columns. For example, when the status changed to planned, published etc
@RezaDorrani
2 жыл бұрын
SharePoint has an inbuilt versioning option that can be turned on.
Hi Reza, this is really a great one! I am just a beginner in power tools. Just wondering whether we can build a pivot table like in power apps which first shows the total counts for each category and then we can drilldown each category to get a detailed counts. The data is fetched from sql server. It would be great if you can advise on the same.
@RezaDorrani
2 жыл бұрын
Thanks for watching and liking the videos. Group By and Totals is possible. I did a video on GroupBy kzread.info/dash/bejne/Z2t1ptqen8KXY84.html I have no references for SQL Server based scenarios. I will recommend checking on the forums at powerusers.microsoft.com/ in case someone has done something similar.
Wow!!!! Very nicely explained for a beginner like me :). Thank you so much, Reza. Can you please tell me how we can open a new/edit/view screen of the form to the full page? Also can you please guide how we can open a view mode of a form to a specific group of users based on a column value? Shall be thankful if you please guide on it. 👍
@RezaDorrani
2 жыл бұрын
It can either open as a mobile size experience or a tablet size experience. It does not support full width or responsive design. Show/hide controls based on security/access - check kzread.info/dash/bejne/fGGcr6-Roq6zhqg.html & kzread.info/dash/bejne/mJZ4s6pppqzZfps.html
@HinaGeo
2 жыл бұрын
@@RezaDorrani Thank you so much for your help.
Thank you for the excellent video. :) Appreciate your work. I have been able to learn all thanks to your video. However, I have a bottleneck, I do not have the current plan for Power Apps. Is there other way to Customize SharePoint list forms without Power Apps?
@RezaDorrani
2 жыл бұрын
You do need a minimum Office 365 license (which includes the Power Apps standard license) to work with Power Apps.