SharePoint Form Customization with Modern Power Apps Controls | Step-by-Step Tutorial

Поделиться
HTML-код
  • Опубликовано: 28 май 2024
  • In this comprehensive Power Apps tutorial, you will learn how to customize SharePoint List forms with Modern Power Apps controls. Discover how to harness the full potential of PowerApps to build custom forms for SharePoint Lists that perfectly suit your team or organization's needs.
    🔹 Create Custom Forms: Learn to craft forms with the all-new Modern Form control in Power Apps
    🔹 Column Customization: Dive into the art of re-ordering columns, configuring column validations, and conditionally showing/hiding columns.
    🔹 Conditional Validations: Explore the power of applying conditional validations to your forms
    🔹 Power Apps Formulas: Discover how generated formulas and the SharePointIntegration control make working with custom SharePoint forms easier.
    🔹 User Collaboration: Explore security & guest user access to SharePoint custom forms, utilization in SharePoint pages, and integration with Microsoft Teams.
    🔹 Form Size Adjustment: Learn how to tweak the size of your SharePoint customized Power Apps form panel.
    Join me in this Power Apps tutorial as we unravel all the details of SharePoint list form customization. Don't miss out on exploring the differences between forms and apps, guest licenses, modern controls and more...
    ⬇️ Download the SharePoint custom Power Apps form showcased in the video:
    Exclusive for Channel Members (Silver 🥈 & Gold 🥇 Club)
    Find the download link in the Community Tab for Members
    To become a member, click here: ruclips.net/user/rezadorranijoin
    Power Apps for Beginners
    • Power Apps for Beginners
    How to Customize SharePoint list forms with Power Apps - Beginners Tutorial
    • How to Customize Share...
    Customize a Microsoft Lists or SharePoint form by using Power Apps
    learn.microsoft.com/en-us/pow...
    Power Apps Modern Controls and Themes
    • Modern controls and th...
    #SharePoint #PowerApps #Tutorial #PowerPlatform
    Table of Contents:
    00:00 - Introduction to Customizing SharePoint List forms with Power Apps
    00:38 - What are Power Apps customized SharePoint Forms?
    04:05 - Modern Form Control in Power Apps
    11:30 - How to get versions of SP customized PowerApps forms?
    12:31 - Browser caching issues with SharePoint forms customized using Power Apps
    13:59 - Explore and update controls in Power Apps Modern Form + Person type combo box
    17:00 - Modern multi-select combo box for SharePoint custom forms
    18:47 - Power Apps form validations + columns show hide
    23:07 - Change Display size of SharePoint customized forms based Power Apps
    24:09 - Add Reset and Save buttons in Power Apps SharePoint form
    25:27 - SharePoint List Item Version History link from Power Apps
    28:07 - Guest user access to SharePoint custom Power Apps forms
    29:16 - Add SharePoint custom forms to Modern Pages & Microsoft Teams
    30:44 - READY to subscribe to Reza Dorrani’s channel
    🤝 Let’s connect on social:
    🔗 Reza Dorrani LinkedIn: / rezadorrani
    🐦 Reza Dorrani Twitter: / rezadorrani
  • НаукаНаука

Комментарии • 227

  • @fanxu3560
    @fanxu3560 6 месяцев назад +11

    I am amazed by the implementation of the 'Version History' feature. It's truly remarkable how this functionality allows users to track and review the SP list item.

    • @RezaDorrani
      @RezaDorrani  6 месяцев назад

      It is an amazing feature indeed.

  • @ChrisSimmsJr
    @ChrisSimmsJr 6 месяцев назад +2

    I built a modern SharePoint List form last week. This video is right on time!

  • @777Scottman
    @777Scottman 6 месяцев назад +1

    Everyone MUST go through a journey of some kind in all that they do - even a learning journey. I'm just a little disappointed that my journey didn't bring me to your amazing tutorials a lot sooner! Oh, the time I would have saved!
    Clear, concise, to-the-point and informative. Excellent! Thank you.

    • @RezaDorrani
      @RezaDorrani  6 месяцев назад

      Thank You so much! We all learn together.

  • @cmarkbernal
    @cmarkbernal 4 месяца назад

    This is a great update video showcasing the modern controls and some new little nuances I didn't know about! Thank you.

  • @nickc655
    @nickc655 6 месяцев назад +1

    Awesome video Reza. It blows my mind how much you can do with the Power Platform. And it keeps getting better.

    • @RezaDorrani
      @RezaDorrani  6 месяцев назад

      Thanks Nick. Im so happy to hear the feedback.

  • @HareKrsn213
    @HareKrsn213 6 месяцев назад +1

    I find it surprising that why you do not have one million subscribers or more 🤨.You put a lot of effort into segmenting the video, and your ideas and voice are really evident.
    As of now I am not working any Power Apps based project but still love to watch your videos.
    Thank you Reza!😊

    • @RezaDorrani
      @RezaDorrani  6 месяцев назад

      Thanks so much.
      Hopefully it will happen someday.

  • @dianemattheson4389
    @dianemattheson4389 6 месяцев назад +2

    Reza, you are excellent at your instructional videos! I am amazed at the level of expertise you display. Keep up the good work - you have helped me as a newbie tremendously!

  • @sravanireddy573
    @sravanireddy573 6 месяцев назад +1

    Reza's videos creates magic of learning to everyone with enjoyment 😄

  • @dougydoe
    @dougydoe 6 месяцев назад +3

    I'm quite comfortable customising the List forms in PowerApps via the Classic controls but didn't know you could actually treat the List form just like a PowerApps form where you insert formulas to further upgrade the quality of the form! A real eye opener.🙂 What about using the Modern controls? I should have seen this video earlier before working on some recently!!! Great watch, Excellent presentation and amazing nuggets to pick up. Always worth my time watching your videos. Excellent stuff and thanks for sharing.

    • @RezaDorrani
      @RezaDorrani  6 месяцев назад

      Thank You so much for the amazing feedback as always. Much appreciated!

  • @oluwatobiyusuf
    @oluwatobiyusuf 5 месяцев назад +1

    Thank you Reza. The modern control is really a game changer

    • @RezaDorrani
      @RezaDorrani  5 месяцев назад

      Most welcome!

    • @yankeedoll2jeter
      @yankeedoll2jeter 4 месяца назад

      I dont know why, but I can't seem to find that option in settings. It gives me the option to "Keep classic themes". What am I missing?

    • @RezaDorrani
      @RezaDorrani  4 месяца назад

      @@yankeedoll2jeter Option is moved to General Tab.
      Always best to check documentation

  • @georgegualda4262
    @georgegualda4262 6 месяцев назад +1

    Excellent video Reza, as always.

  • @zackmalaysia5384
    @zackmalaysia5384 6 месяцев назад +2

    As always..reza will come out with a great tutorial to learn..keep the good work❤

  • @TheHallmackenreuther
    @TheHallmackenreuther Месяц назад +1

    Clean and very understandable tutorial. Thx for that

  • @gunasekar4098
    @gunasekar4098 6 месяцев назад +2

    i am the first person to watch this video.. Nice Reza... good content and easy understand.. How to achieve if more than 5000 records in Sharepoint to power apps.

    • @RezaDorrani
      @RezaDorrani  6 месяцев назад

      Thanks so much!
      This is a SP custom power app. You dont have to handle 5000 items in power apps.
      The app only works with a single item.

  • @tsion1919
    @tsion1919 4 месяца назад

    This is amazing. Thank you Reza!

  • @LifeMusic87
    @LifeMusic87 6 месяцев назад +1

    Thanks for share you knowledge, you are the best

  •  6 месяцев назад +1

    Thats a very good Video Thanks a lot !

  • @lijunchen
    @lijunchen 6 месяцев назад +2

    Great video. So much skills/tricks are packed into this seemingly straight forward app. I do meet with an issue when displaying the form in the landscape format. Although I changed the display from portrait to landscape with 2 columns, the app displays well as in landscape in the Apps Studio / and in Test Preview, but when I saved / published and open the App in the List, the form is still as narrow as in before although the fields are 2 columns now (all squeezed to the top right side of app). I wonder how the problem arise? Thanks.

    • @RezaDorrani
      @RezaDorrani  6 месяцев назад

      Thanks!
      I have not experienced any such issue.

  • @dominikpetri2120
    @dominikpetri2120 6 месяцев назад +1

    Another great video Reza. Thanks a lot! One question: Why are you using a variable for the form mode instead of the forms FormMode property? Thanks again! 👍

    • @RezaDorrani
      @RezaDorrani  6 месяцев назад

      Bcoz forms formmode property still resulted in caching issues upon testing.

    • @dominikpetri2120
      @dominikpetri2120 6 месяцев назад +1

      @@RezaDorrani Didn't know that! Thanks for you quick reply! Will use your variable method from now on (and will change my old apps) ;-) THANKS!

  • @deonshipmon9981
    @deonshipmon9981 5 месяцев назад +1

    Hello, Reza! Awesome job with the videos! I have definitely learned a lot as the organization I work for has migrated to SharePoint Online.
    I have a question about the 'Reset' button portion of the video. I followed along step-by-step but when I edit an existing item in the list and click the 'Reset' button my entire form resets. I have my list, form, and code for the OnSelect property of the button set exactly as you. Thanks in advance!

    • @RezaDorrani
      @RezaDorrani  5 месяцев назад

      Most welcome!
      Video description has link to download sample app (members only)
      I have not come across this issue and hence not sure what is the cause for your issue. I recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com

  • @MaverickNextGen
    @MaverickNextGen Месяц назад +1

    Fantastic video, Thank you! I have implemented the modern controls as you have, however whilst in the Power Apps editor if click on the Status drop down I cannot see the choice values Completed etc, it remains "New". I just get a resizing/move handle highlighting the control - the drop down with the values never opens whereas in your video you are able to do this in situ on the canvas, is there a special mode that I need to be in to do this? EDIT - Found the answer, you need to press the "Alt" key when click the drop down/control and the choices will appear!😄

  • @kevinbaroro2857
    @kevinbaroro2857 6 месяцев назад +1

    Awesome content as always Reza. ❤
    With regards to sharing the custom sp list to external users, do we need to assign them a m365 license?

    • @RezaDorrani
      @RezaDorrani  6 месяцев назад

      Most welcome!
      No license needed. I showed a snapshot of the license in video 😊

  • @sanjayadsure
    @sanjayadsure 6 месяцев назад +1

    Hi Reza, Thank you for this video! May I know if Modern Controls can be used in Production?

    • @RezaDorrani
      @RezaDorrani  6 месяцев назад

      Modern controls are in preview. Wait until GA.

  • @HinaGeo
    @HinaGeo 29 дней назад +1

    Thank you for this very informative video. Do you please know how to empty/blank the Assigned To combobox based on some check?

    • @RezaDorrani
      @RezaDorrani  29 дней назад

      Welcome!
      I don’t have a video reference on that scenario

  • @alexandrubirsan7608
    @alexandrubirsan7608 6 месяцев назад

    Hey Reza, this is nice! I'm having some issues though with a normal canvas powerapps regarding the modern Form and the controls from it. It seems like people picker is still outdated and needs to be done the old way? or am I missing something? I've watched your video regarding them but it isn't of any help because I'm using a SharePoint List and the PowerCAT People Picker just doesn't write data into the field in SP...

    • @RezaDorrani
      @RezaDorrani  6 месяцев назад

      Check this video again. I mention currently not to use modern controls for person picker.
      Power CAT people picker - if there are any issues then best to report that at github for creator kit.

  • @Isaiah.43.4
    @Isaiah.43.4 Месяц назад

    So so helpful!! qq, ~16:10 when you add the classic combo box control and bring it to the modern form, anything to make it visually more uniform with all the modern controls? It doesn't follow the theme and on view doesn't have the background color either.

    • @RezaDorrani
      @RezaDorrani  Месяц назад

      Check my video on modern controls. I did show how to apply modern colors to classic controls in those videos.
      App.Theme.Colors.Primary will give you the modern theme color.

  • @zed.prince
    @zed.prince 3 месяца назад +1

    This is a great video. The only problems I run into are with: 1) the people picker. I can only see claims, and not the whole organisation. 2) Managed Meta data tags showing either a number or a whole string instead of the label.

    • @RezaDorrani
      @RezaDorrani  3 месяца назад

      Modern controls don’t support person and managed metadata fields completely as of now

  • @user-bo4qe9ww5n
    @user-bo4qe9ww5n 5 месяцев назад +1

    Thank you very much Reza. Another amazing video. Best Power Apps and Power Automate videos by far. Is it possible to share a link with external users that contains a filtered version of the list. Sometimes, depending on the user, we do not want them to see all the items.

    • @RezaDorrani
      @RezaDorrani  5 месяцев назад

      Showing and hiding is not true security. Views is not security.
      But you can share a link to views with users.

  • @phillharris3656
    @phillharris3656 Месяц назад

    Hello Reza! Your content and your knowledge are truly inspirational. So, I have a problem that I hope you can assist with. I applied a PowerShell command to a custom PowerApps SharePoint list form in an effort to disable the pop-up permissions prompt when a user accesses the form for the first time--it is not a Power App per se. I thought it seemed to work. The App ID I used in the script is from a Settings page I see while the custom form is being edited. I tried the fix with a generic tenant account and while a little clunky, it eventually bypassed the permissions prompt. However, other users still get the prompt regardless. Any thoughts on why and how to stop it?

    • @RezaDorrani
      @RezaDorrani  Месяц назад

      Thanks!
      I have not used PowerShell on any app to block prompts and have no knowledge about that. I recommend checking or posting your query on forums in case someone has done something similar powerusers.microsoft.com

  • @nimishanalinam
    @nimishanalinam 6 месяцев назад +1

    Dear Reza, Thanks a lot for all your videos. is there any possibility in future sp form customization will support multiple content types ? Also content types like Document set where we can add multiple content types even folder content types. It’s really tricky now to handle such scenarios.would be very helpful if you can show any such scenario best practices. Thank you.

    • @RezaDorrani
      @RezaDorrani  6 месяцев назад

      Most welcome!
      Content type support is not in release planner for now. I am not sure of the future.

  • @iulianburlacu
    @iulianburlacu 6 месяцев назад +1

    Cool stuff!

  • @lencardinal1584
    @lencardinal1584 6 месяцев назад +1

    Hi Reza. Nice video again, lots of tips.
    Question: For document libraries, the form does not appear by default when you click the '(i)nformation button'. The user has to click 'Edit All'. Is there any way to have the form come up as the default form experience - for View and Edit?
    We have a library of 'vendor invoices' that are pretty much all PDF's. Clicking one will bring up the PDF Preview, and the user can page through their invoices to be approved, using navigation buttons in the preview pop-up. They can open the Information panel to view properties of each doc as they page. But the Information panel does not seem to be PowerApps forms. Only when the user clicks 'Edit All' does the customized form come up. It's not intuitive. And when they page to the next record, the form closes, showing only the built-in Information panel again.
    Thanks.

    • @RezaDorrani
      @RezaDorrani  6 месяцев назад

      Info panel is by design. It will not launch power apps forms there. I have done a video showing doc lib form customization with power apps as well. Check that video.

  • @DMK573
    @DMK573 2 месяца назад +1

    Hi Reza, This is an excellent video similar to other great videos you have posted. I have just started designing list forms using PowerApps and I'm in a need to use a list with a Choice column. For Choices I'd like to have group headers such as:
    Group A
    Choice 1
    Choice2
    Cjoice3
    Group B
    ChoiceX
    Choice2
    Choice3
    etc,. I can name a choice option as Group A (header) but it should be a disabled choice and user should not be able to add it. Or otherwise, is there a way to implement group headers in list of choices? Any suggestions or some advice would be appreciated.
    Thanks!!

    • @RezaDorrani
      @RezaDorrani  2 месяца назад

      Group headers is not an option. You would need to create 2 separate columns.

    • @DMK573
      @DMK573 2 месяца назад +1

      @@RezaDorrani Thanks so much for your reply!!

  • @sashavaldesjimenez5969
    @sashavaldesjimenez5969 2 месяца назад

    Hi Reza, can I restrict the items listed so a user can just see those who are assigned to him or maybe to a group of common users?

    • @RezaDorrani
      @RezaDorrani  2 месяца назад +1

      Item level permissions ruclips.net/video/EJyZfYMi4n0/видео.html

  • @janardhanansgm521
    @janardhanansgm521 6 месяцев назад +1

    Fantastic 🎉🎉🎉

  • @alvarovillachica-fk9oz
    @alvarovillachica-fk9oz 6 месяцев назад +1

    Hello Reza, first thanks for your tutorial I am new learning power apps but your tutorial are very useful. about this project I have downloaded the app, I would like to add a column of text into the share/point, what do I need to change into the apps to add this new text column into the share/point? thanks

    • @RezaDorrani
      @RezaDorrani  6 месяцев назад +1

      You would need to add the column in SharePoint first.
      Then edit power app and add that column to form.

  • @khazd0rf
    @khazd0rf 4 месяца назад +1

    Hi, thanks for a amazing content. I'm having an error "onsuccess" with this formula. ResetForm(SharePointForm1);RequestHide() RequestHide() is not accepted.

    • @RezaDorrani
      @RezaDorrani  4 месяца назад

      I have not come across the mentioned issue and hence not sure what the cause could be.
      I recommend posting your issue on forums in case someone has experienced something similar powerusers.microsoft.com

  • @user-lo1eg8eg9n
    @user-lo1eg8eg9n 6 месяцев назад +1

    Great tutorial!! is there any way we can create a template of this list or site and generate a new sharepoint site with a list including this form? and also if the whole site or list is shared with a guest, will he be able to use the form directly without having the individual form share?

    • @RezaDorrani
      @RezaDorrani  6 месяцев назад +1

      1 - ALM story for SP custom forms is weak.
      aka.ms/movespforms will give you a lot of details about it
      Also, if you are a channel member (silver and above), I have shared the app which will allow you to push it to your SP site. Its a hack method.
      2 - If guest user has access, either via site or list permissions, they will be able to run the SP custom form.

    • @user-lo1eg8eg9n
      @user-lo1eg8eg9n 6 месяцев назад +1

      @@RezaDorrani Thank you Reza for your invaluable help ( as always)

  • @user-me7nr9pt2v
    @user-me7nr9pt2v 2 месяца назад

    Interesting video Reza. We would also like to put our own SAVE button on the form, so we can force some fields updates. But is there a way to make disappear the OOTB SAVE button on the top of the form? Because if our users use this button, the extra fields updates will not take place.

    • @RezaDorrani
      @RezaDorrani  2 месяца назад

      You cannot hide the OOTB save button as far as I know.

  • @myama9688
    @myama9688 Месяц назад

    HelloReza , I'm trying to build a simple customized form to my SharePoint Document Library List (Customized Content Type - Document Set) ; there a single field, but I always get "Network error when using Patch Function", I wonder if I can customize form for a SharePoint Document Library List (Customized Content Type - Document Set) ?

    • @RezaDorrani
      @RezaDorrani  Месяц назад

      As far as I know it can be done. Not sure about your issue though.
      I recommend posting your issue on forums in case someone has experienced something similar powerusers.microsoft.com

  • @bobbyw1074
    @bobbyw1074 3 месяца назад

    Thanks Reza! Does users need power apps license for this?

    • @RezaDorrani
      @RezaDorrani  3 месяца назад

      An office license that includes power apps will suffice

  • @AnandAnand-ii6ef
    @AnandAnand-ii6ef 6 месяцев назад +1

    Hi Reza, thanks for the video. Version history was amazing..
    I have two queries in using sharepoint list with PowerApps forms..
    1. Does the user need to have PowerApps license to use this form
    2. Sharepoint has a 5000 limit view threshold.. does this affect PowerApps performance.
    It would be helpful if you can share some views around this

    • @RezaDorrani
      @RezaDorrani  6 месяцев назад

      1 - Yes for internal users - Standard license for power apps (part of most office licenses)
      No for guest users
      2 - Power Apps is connected to list and only shows 1 item. 5k+ list does not have any impact. You can test it out which such a list.

    • @AnandAnand-ii6ef
      @AnandAnand-ii6ef 6 месяцев назад

      Thank you for the reply😊

  • @PowerUserJ
    @PowerUserJ 6 месяцев назад +1

    Hello Reza, thanks again for the excellent video.
    However, when i changed the display like you mentioned and open the form in my sharepoint list the width of the flyout form is still the same width it was before and the form is tiny.
    Please advise, and thank you again.

    • @RezaDorrani
      @RezaDorrani  6 месяцев назад

      Welcome!
      I have not come across this issue and hence not sure what is the cause for your issue. I recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com

    • @PowerUserJ
      @PowerUserJ 6 месяцев назад

      I did some research and found out it is likely a caching issue. I cleared my cache data do you have any other recommendations on clearing cache for sharepooint/powerapps?
      @@RezaDorrani

    • @PowerUserJ
      @PowerUserJ 6 месяцев назад

      An update on this, it takes like a day for sharepoint to reflect display changes.

    • @RezaDorrani
      @RezaDorrani  6 месяцев назад

      @@PowerUserJ I have not come across this issue so no updates from my side

  • @path_ethics
    @path_ethics 3 месяца назад

    Is it possible to have like an estimated time field where whoever creates the issue, selects the estimated time to resolve the issue? For example, select two hours or one day, or one month. Is something like this possible in sharepoint lists?

    • @RezaDorrani
      @RezaDorrani  3 месяца назад

      Have not tried this so not sure.

  • @alexguardiolamartinez2599
    @alexguardiolamartinez2599 5 месяцев назад

    Very thanks of your hard work for all of us! I'm just facing a common problem where I'm stuck on a loading loop when i try to connect the data to the form.. Any solution or smth I'm missing for this?

    • @RezaDorrani
      @RezaDorrani  5 месяцев назад

      Most welcome!
      I have not come across the mentioned issue and hence not sure what the cause could be.
      I recommend posting your issue on forums in case someone has experienced something similar powerusers.microsoft.com

  • @nightwalker7723
    @nightwalker7723 3 месяца назад +1

    Is it possible to make a button with a sign like "+" that would increase a certain field? the idea is that each row has a quantity field that needs to be easily increased or decreased

    • @RezaDorrani
      @RezaDorrani  3 месяца назад +1

      Possible but not something I have tried

    • @nightwalker7723
      @nightwalker7723 3 месяца назад

      @@RezaDorrani Maybe an idea for a video haha? Need to do it at my studentjob:)

    • @RezaDorrani
      @RezaDorrani  3 месяца назад

      @@nightwalker7723 No plans for this one as I have hardly got any requests on this topic.

  • @jandjtempleton
    @jandjtempleton 6 месяцев назад

    Hi Reza, Getting and error when saving for the Person column using the classic combo box "Network error when using Patch function: The specified column is read-only and can't be modified." Any ideas on how to rectify?

    • @RezaDorrani
      @RezaDorrani  6 месяцев назад

      I have not come across the mentioned issue and hence not sure what the reason for your issue is. I recommend posting your issue with screenshots on the forums at powerusers.microsoft.com

  • @vonis22
    @vonis22 6 месяцев назад

    Hi Reza, I know this is a leap, but how do you go about migrating these custom forms to other sharepoint lists? We are still struggling to do proper ALM

    • @RezaDorrani
      @RezaDorrani  6 месяцев назад

      There is no ALM with SP custom forms.

  • @UndeniableLogic
    @UndeniableLogic 3 месяца назад

    Awesome video Reza! I have a question...lets say I have an admin group submitting these 'forms'...Is it possible to give a second "verification" group access to the list, view only or with access to only certain columns so that they may provide additional status and notes on that entry after they have validated the information??

    • @RezaDorrani
      @RezaDorrani  3 месяца назад +1

      SharePoint does not support column level security. You could show hide columns on form but a smart user can always get to that data via apis

    • @UndeniableLogic
      @UndeniableLogic 3 месяца назад

      @@RezaDorrani any recommendations around this? Views may work...after all, the second group is just validating the data, but because it's a new patient verification, it should technically be locked from anyone except the submitter...

    • @RezaDorrani
      @RezaDorrani  3 месяца назад +1

      @@UndeniableLogic Not sure what options are there apart from securing the data but SharePoint does not offer column level security

    • @UndeniableLogic
      @UndeniableLogic 3 месяца назад

      @@RezaDorrani thank you. I suppose it could be created all in a power app. One part to submit, another part to review and validate with notes and accomplish that as a role based app...? Maybe? 😅

    • @RezaDorrani
      @RezaDorrani  3 месяца назад +1

      @@UndeniableLogic maybe

  • @davecfromvb
    @davecfromvb 4 месяца назад

    I have a SharePoint list with content types which allows me to select between 2 forms when selecting “new”. For Example, I have an “Engineering form” and an “Administration form”. I would like to use the custom forms with the content types instead of the default SharePoint forms but have not been able to figure out how to get it working. Currently, when I switch to custom forms, it will only show me “SharePointForm1” which is linked to the Engineering Form, even when I select the Administration Form from the drop down. My guess is that I need to modify the “OnNew” field under Advanced settings - SharePointIntegration within the Power App Forms but I do not know the formula I should provide. Do you know how to execute the content types with custom forms?

    • @RezaDorrani
      @RezaDorrani  4 месяца назад +1

      Content types is not a concept understood by power apps. You would need to show and hide columns based on content type selection in form. In future if any changes are made in content type - it wont reflect in power apps. You would need to make changes in power apps everytime.

  • @shashank6096
    @shashank6096 6 месяцев назад +1

    When I try to add the data source to the form it keeps on loading ( says Please Wait) for a long time
    Happening with only modern control - form
    i have created the same SharePoint with 3 rows only

    • @RezaDorrani
      @RezaDorrani  6 месяцев назад

      I have not come across the mentioned issue and hence not sure what the reason for your issue is. I recommend posting your issue with screenshots on the forums at powerusers.microsoft.com

  • @MaemuTendani
    @MaemuTendani Месяц назад

    Is it possible to create rules for a column in SharePoint forms, lets say I want to view or hide certain information when an item is selected.

    • @RezaDorrani
      @RezaDorrani  Месяц назад +1

      Possible! I have done several videos on form control where I have shown that.

    • @MaemuTendani
      @MaemuTendani Месяц назад

      @@RezaDorrani Thank you so much I will surely check them out

  • @cesarsepulveda9218
    @cesarsepulveda9218 6 месяцев назад

    Hi Reza, I don't see the power apps form in sharepoint, it's been a while since I published and it's still not visible. Should I configure something else in sharepoint?

    • @RezaDorrani
      @RezaDorrani  6 месяцев назад +1

      I have not come across this issue and hence not sure what is the cause for your issue. I recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com

  • @Corinneb1344
    @Corinneb1344 6 месяцев назад

    Really love the version history, however, i can't get it to work on my side. Can you confirm where to get the last bit of the URL? Yours says "&isdlg=1".

    • @RezaDorrani
      @RezaDorrani  6 месяцев назад

      Thats only to open it in a dialog format where chrome is stripped out.
      I have explained entire url in video.

    • @Corinneb1344
      @Corinneb1344 6 месяцев назад +1

      @@RezaDorrani Thank you! If found the issue and it is working now :)

    • @RezaDorrani
      @RezaDorrani  3 месяца назад

      @@path_ethics I recommend posting your issue on forums at powerusers.microsoft.com

  • @chulitoalbo3958
    @chulitoalbo3958 6 месяцев назад

    Do you need a license to create a form with power apps? And how about the other users? Do they need a power apps license / power atomate? Thank you Reza!

    • @RezaDorrani
      @RezaDorrani  6 месяцев назад

      Yes, you need a standard Power App license.
      Internal users need a standard license as well.
      Guest users do not need a license.
      The video is specific to power apps.

  • @sundararamanarikrishnan3672
    @sundararamanarikrishnan3672 6 месяцев назад

    Dear Reza,
    Hope you are doing great, I have a query in the new PowerAutoamte, the "Edit with new designer" looks complex, I am not able to edit expression. can you make one video about this new feature in PowerAutomate.

    • @RezaDorrani
      @RezaDorrani  6 месяцев назад

      I made a video on it months ago
      ruclips.net/video/-AQ_lcpaRec/видео.htmlsi=AQBXOITpEdQHiRr_

  • @kamalakarreddyuppala3772
    @kamalakarreddyuppala3772 6 месяцев назад +1

    Thanks Reeza
    can you take full session on power platform basic to adwance on live

    • @RezaDorrani
      @RezaDorrani  6 месяцев назад

      I am already doing that with memberships.
      My gold membership tier is for training.
      Open my channel on web browser and click on JOIN button.

  • @tracypurdy7974
    @tracypurdy7974 6 месяцев назад

    In this video you hid columns or items whether it was a new form or you were editing the form. You also changed the requirement status depending on another fields value. Are you able to hide a field based on another fields value? For example, in your form, if status is changed to new, could you hide the completion date field at all?

    • @RezaDorrani
      @RezaDorrani  6 месяцев назад

      Yes, all possible. I have done many videos on form control where I have shown various levels of show/hide. I would recommend checking my video list :)

  • @ChrisSimmsJr
    @ChrisSimmsJr 19 дней назад

    Did they remove the modern controls and themes option? I don't see the toggle when I search for it under upcoming features. 🤔

    • @RezaDorrani
      @RezaDorrani  19 дней назад +1

      Its now in General Tab

    • @ChrisSimmsJr
      @ChrisSimmsJr 19 дней назад

      @@RezaDorrani thanks! I don't know why I didn't check there. 🤦‍♂😆

  • @arthurripoll3334
    @arthurripoll3334 Месяц назад

    Hi Reza,
    I created the custom form, however when multiple items are selected, it doesn't display the form I modified in PowerApps.

    • @RezaDorrani
      @RezaDorrani  Месяц назад

      Form only works for single item. This is by design.

  • @nimishanalinam
    @nimishanalinam 6 месяцев назад

    Dear Reza, Thanks for your reply to prev comment. May I also check, when we customize a Form for sharepoint list , how should we encapsulate it into a solution? Also can we add flows that trigger on button click as part of that solution? What's the recommended practice esply in terms of environments . Please help to guide.

    • @RezaDorrani
      @RezaDorrani  6 месяцев назад

      You cannot add sp custom forms to a solution.
      Flows button click can be part of the app.
      Sp custom forms only live in 1 environment so there is no ALM at the moment.
      Check aka.ms/movespforms

    • @nimishanalinam
      @nimishanalinam 6 месяцев назад

      Thank you, Reza, for the reply. In this case, we need to keep the flows (that the custom SP List form calls through button clicks other than the SP List triggers) in the same default environment only, right ? I read we can set the default Sharepoint forms environment through the PowerShell [Set-AdminPowerAppSharepointFormEnvironment]. I guess this is a tenant-wide setting, and a dedicated stand-alone environment for SP List Customizations solutions may be a better approach. Please let me know your thoughts.

    • @RezaDorrani
      @RezaDorrani  6 месяцев назад

      Thats right. Always best to test things out first.

  • @burkhard9155
    @burkhard9155 5 месяцев назад

    Hi Reza, in my Power App customized SharePoint Form I would like to calculate the average out of some values in the App by
    DataCardValue "Default= Text(Average(DCV1,DCV2, ...), "0.0") Unfortunately that doesn´t work. Also Min(...) and Max(..) doesn´t work. Would be great if anyone could help.

    • @RezaDorrani
      @RezaDorrani  5 месяцев назад

      I do not have a video reference on this scenario and would have to try it out to provide guidance. I recommend checking on the forums at powerusers.microsoft.com/ in case someone has done something similar.

  • @gopalyadav9472
    @gopalyadav9472 15 дней назад

    Hi Reza, I've built a Sharepoint list form using Power Apps. However, When i click on edit(to edit a line item), the details vanish when the form window opens. Please help.

    • @RezaDorrani
      @RezaDorrani  15 дней назад

      I have not faced this issue so not sure.

  • @gberosh
    @gberosh 20 дней назад

    Great Video works as expected up until I hit save then the form clears and displays "Getting your data" and never closes. Have others seen this?

    • @RezaDorrani
      @RezaDorrani  20 дней назад

      I have not come experienced this issue and hence not sure what the cause for it could be.
      I will recommend posting your issue on forums in case someone has experienced something similar powerusers.microsoft.com

    • @gberosh
      @gberosh 20 дней назад

      @@RezaDorrani The issue turned out to be that when adding the Modern form the Items property is blank and the OnSuccess was set to false. I updated both of those to what the classic form had and it working as expected now. I was able to replicate this in 2 different environments.

    • @RezaDorrani
      @RezaDorrani  20 дней назад

      @@gberosh Ok. Thanks for sharing

  • @randika118
    @randika118 2 месяца назад

    How do we get the Audit History of the Dataverse Table in the Canvas Power App? is it possible?

    • @RezaDorrani
      @RezaDorrani  2 месяца назад +1

      I have not tried it so not sure. But definitely possible as audit history can be obtained via api.

    • @randika118
      @randika118 2 месяца назад +1

      @@RezaDorrani Thanks for your quick response 💗

  • @j.bagalay1623
    @j.bagalay1623 6 месяцев назад

    is PowerApps still has the limitations to store up to 2,000 records only? if so, is there any other way to extend its limitations or any workaround? Thank you.

    • @RezaDorrani
      @RezaDorrani  6 месяцев назад

      Power apps is not a data source. Ideally you should be saving and retrieving data from a data source. Check my videos on delegation.

    • @j.bagalay1623
      @j.bagalay1623 6 месяцев назад

      @@RezaDorrani if you could send the specific link for that video, will highly appreciate it. thank you.

    • @RezaDorrani
      @RezaDorrani  6 месяцев назад

      @@j.bagalay1623 Search for “power apps delegation reza” and you will get the videos

  • @KProutyglss
    @KProutyglss 2 месяца назад

    The hide on New ONLY works if you go to the actual list and click on new. If you use the weblink or try to embed it on a Sharepoint page, it doesn't respect that code and still shows those fields. Furthermore, when embedded, it shrinks the form.

    • @RezaDorrani
      @RezaDorrani  2 месяца назад

      I was not aware of those limitations.
      90% scenarios are within list or library.
      Weblink has least value as user needs to be in SharePoint context.

    • @KProutyglss
      @KProutyglss 2 месяца назад

      I was trying the web link as a last resort,@@RezaDorrani Our users are NOT sophisticated and some of them truly have a hard time navigating SharePoint lists. That is why we put what they need on a SharePoint page (just need the new functionality). (Nonprofit here.) Got the form to take up the whole page so it doesn't shrink anymore, but it is still not respecting the code.

  • @dane-train
    @dane-train 6 месяцев назад

    My biggest issue I cannot seem to get dynamic height forms like you can in a canvas app. For example If I have a scroll bar that works fine - but when zoomed out there is dead space on the bottom and it still has the scroll bar.
    My particular form has a column that is basically contains CSV data for a item list. So it creates a dynamic height gallery. So my form is never really a set size.
    Best work around it just to make a container that is oversized.

    • @RezaDorrani
      @RezaDorrani  6 месяцев назад

      I dont have the same experience in SP custom forms either. Zoom in and zoom out or responsive design is NOT an option with SP custom forms as they are NOT responsive.

  • @worxart
    @worxart 5 дней назад

    Hi Reza! I am faced a little proble with the versioning. I can't find the correct link to my list which contains the "versions.aspx..." part. Which page could be the right one?

    • @RezaDorrani
      @RezaDorrani  5 дней назад

      There is only 1 versions page per list. Im not sure how to I can help u find it.

    • @worxart
      @worxart 5 дней назад

      @@RezaDorrani Unfortunatelly I can't find the version page with my list. I have checked all of my pages in settings and so on. Maybe it is my lack of experiences. But thank you for your time.

    • @RezaDorrani
      @RezaDorrani  5 дней назад

      check if version history is turned on for your list in settings

    • @worxart
      @worxart 5 дней назад

      @@RezaDorrani Yes, it is turned on, I have checked it. It was my first idea too.

    • @RezaDorrani
      @RezaDorrani  5 дней назад

      @@worxart Ok. Im not sure how I can help though.

  • @blackwolf_majik
    @blackwolf_majik 6 месяцев назад

    We've run into a problem with using (power apps) customized forms for SharePoint lists:
    We created a list for an Equipment Reservation Portal and customized the form using Power Apps.
    A separate Department wanted a copy for their own records, but with small modifications, so we made a template of the list with the intent to make the adjustments afterward.
    When we tried to edit the second list's form - it redirected us to the original template's form.
    As the original was just intended for testing - I deleted the customized form on the template site to try to disconnect the two lists. Now we get an error whenever I try to still customize the production list form saying that the form cannot be found.
    This has caused a lot of trouble and I've had to essentially rebuild the entire Equipment Reservation Portal using lists with no customization at all and switched completely to Canvas apps we duplicate.
    Have you run into this issue in testing?
    Thanks.

    • @RezaDorrani
      @RezaDorrani  6 месяцев назад

      Templates for SP lists do not support SP custom list forms.

    • @raslaankhan5146
      @raslaankhan5146 6 месяцев назад

      You can use exporting and importing customized forms from Power Apps. I use it to migrate my changes from test to Production form all the time.
      You will be able to find a lot of videos on it.

    • @RezaDorrani
      @RezaDorrani  6 месяцев назад +1

      @@raslaankhan5146 There is no supported option in product for SP custom forms.
      We are not talking about standalone apps.
      There are hacks to do it but I dont recommend them.

    • @raslaankhan5146
      @raslaankhan5146 6 месяцев назад +1

      @@RezaDorrani I am also not talking about the standalone apps. I do the hacks and it's working fine for me.

    • @RezaDorrani
      @RezaDorrani  6 месяцев назад

      @@raslaankhan5146 Its a hack at the end of the day and not a recommended approach.

  • @Jaraiya89
    @Jaraiya89 6 месяцев назад

    I'm having an issue with my attachement files now. In the powerapp form version i have to download the attachments, where as before with the standard version, one click would open in a browser experience

    • @RezaDorrani
      @RezaDorrani  6 месяцев назад

      Whats a standard version? Is that power apps or out of the box sharepoint.
      Attachments in power apps download by default.

    • @Jaraiya89
      @Jaraiya89 6 месяцев назад

      Yes I want to change the download by default in powerapps to work like the "out of the box" sharepoint. It's meant for the user to quickly view items. Downloading is unnecessary for my application.

    • @RezaDorrani
      @RezaDorrani  6 месяцев назад

      I think its possible but not something I have done. I will recommend checking on forums at powerusers.microsoft.com/

  • @disturbedcarrot
    @disturbedcarrot 6 месяцев назад

    Is it as well to use a canvas app so you have better ALM?

    • @RezaDorrani
      @RezaDorrani  6 месяцев назад

      Yes but this is an experience for SP specific scenarios.

    • @disturbedcarrot
      @disturbedcarrot 6 месяцев назад

      @@RezaDorrani thank you, a video comparing both custom sp and canvas apps and when to use either would be great. I have an SP solution at the moment and I was going to go with a canvas app but may now consider a custom sp form.

    • @RezaDorrani
      @RezaDorrani  6 месяцев назад +1

      @@disturbedcarrot Its a choice. Pros and cons are there. I do not plan a video on it though :)

  • @farahim732
    @farahim732 2 месяца назад

    Hi sir, I have a question. Why my sharepoint does not showing the customize form option? it is because i do not own the sharepoint?

    • @RezaDorrani
      @RezaDorrani  2 месяца назад

      You need to have owner or edit list permissions + may be your admin has disabled this option for list/library

  • @asmi3007
    @asmi3007 6 месяцев назад

    Hello Reza, wanted a video in which we have two sharepoint list. In one list we have mobiles of different companies with same or different values. And other sharepoint list we have different band of employees who are allowed to buy certain value of mobiles. Say A, D,G employee can only buy mobile worth 5000 , B can buy mobile of 7000 , C can buy 10000, how we will filter scorable gallery based on band of employees

    • @RezaDorrani
      @RezaDorrani  6 месяцев назад +1

      I make videos when I receive multiple requests on a topic. Every quarter I ask subscribers for topic suggestions on Community Tab of my channel. Most voted topic ideas get added to my backlog. Make sure to suggest this idea whenever the next topic suggestion post is out.

    • @asmi3007
      @asmi3007 6 месяцев назад +1

      @@RezaDorrani thank you so much.

  • @adrianhidayat592
    @adrianhidayat592 6 месяцев назад

    hello mr. Reza Dorrani, may u can help me about power apps, i have trouble to make auto increment uniqe ID in my form pelase make a video about that, cause this is for my job, i need to finish it for the deadline

    • @RezaDorrani
      @RezaDorrani  6 месяцев назад

      I make videos when I receive multiple requests on a topic. Every quarter I ask subscribers for topic suggestions on Community Tab of my channel. Most voted idea gets added to my backlog. Make sure to post this idea whenever I post the next topic suggestion post.

  • @youshaali2507
    @youshaali2507 6 месяцев назад

    Aoa Sir ...Sir i am facing the problem its very hard to which tutorial should i start to learn power apps because your playlist is not order it's in random way please help me?

    • @RezaDorrani
      @RezaDorrani  6 месяцев назад

      Sir I answered this question here
      ruclips.net/user/liveoSPw6WJdPoA?si=D9yeMrKRUBn585We

  • @nurqistina4193
    @nurqistina4193 3 месяца назад

    Hello sir, why is it when I click "+New" in SP, it doesn't display the design that I made in Power Apps?

    • @RezaDorrani
      @RezaDorrani  3 месяца назад +1

      I would only be guessing as I have not experienced this.
      1 - You did not publish the app from power apps
      2 - You did not clear your browser cache (sometimes it takes up to 1 min before the SP form loads)

    • @nurqistina4193
      @nurqistina4193 3 месяца назад +1

      @@RezaDorrani thank you sir

  • @mrmozerz
    @mrmozerz 5 месяцев назад

    I'm finding the modern form experience to be somewhat buggy. When I edit an existing item, some of the fields are not populating with data.

    • @RezaDorrani
      @RezaDorrani  5 месяцев назад +1

      Modern form control is in preview.

  • @darylbetts6737
    @darylbetts6737 4 месяца назад

    Is there a way to print a created custom form that has data entered?

    • @RezaDorrani
      @RezaDorrani  4 месяца назад

      I dont think print function is supported for SP custom forms.

  • @muka_32
    @muka_32 2 месяца назад

    I ran into a problem which is error messages card are not working properly. Any hints?

    • @RezaDorrani
      @RezaDorrani  2 месяца назад

      I have not come across this issue and hence not sure what the cause could be.
      I recommend posting your issue on forums in case someone has experienced something similar powerusers.microsoft.com

  • @HazzR8
    @HazzR8 5 месяцев назад

    Modern controls are in Preview and from what I have experienced they are buggy. I would not use them until they are out of preview and tested properly. Example.: When trying to add the modern form in, the whole studio crashes with a massive error - every time LoL!!

    • @RezaDorrani
      @RezaDorrani  5 месяцев назад

      Have not experienced any crashing behavior but completely agree - do not use it if it does not work for you and for sure some of the controls are preview

  • @shrutichavan3404
    @shrutichavan3404 15 дней назад

    "Sir, can you please tell me how to add the modified date with the current date and time?

    • @RezaDorrani
      @RezaDorrani  15 дней назад

      Where to add?
      You simply add those data cards to form (they are system fields though)

    • @shrutichavan3404
      @shrutichavan3404 15 дней назад

      @@RezaDorrani "I need to add it to the SharePoint list.""When I add a new item to the share point list, I need to see the created date with time added after the new item is added."

    • @RezaDorrani
      @RezaDorrani  15 дней назад

      @@shrutichavan3404 Change the view to include those columns.

    • @shrutichavan3404
      @shrutichavan3404 14 дней назад

      @@RezaDorrani "Sir, what exactly are you saying? I don't understand." can you please sir explain me step's of the process. "Or if you've included any of your video, then plz provided its reference.

    • @RezaDorrani
      @RezaDorrani  14 дней назад

      @@shrutichavan3404 I will recommend posting your query on forums
      powerusers.microsoft.com

  • @Jaraiya89
    @Jaraiya89 6 месяцев назад

    i like this video alot but the scaling is buggy, its closing the comment section to a small sliver and the text is shrunk to fit, even in landscape

    • @RezaDorrani
      @RezaDorrani  6 месяцев назад

      That size is fixed for the panel. Landscape or portrait. Not much can be done there.

    • @Jaraiya89
      @Jaraiya89 6 месяцев назад +1

      Okay thank you, yes cause the out of box sharepoint has a comment section we found useful. Appreciate your help! Thanks

  • @jagchandran9419
    @jagchandran9419 Месяц назад

    Modern Controls are moved Under General tab in Settings🙂

    • @RezaDorrani
      @RezaDorrani  Месяц назад

      Yes and as time progresses will move out from there completely.

  • @rafisyed3112
    @rafisyed3112 6 месяцев назад

    How to move same customized app into new environment

    • @RezaDorrani
      @RezaDorrani  6 месяцев назад

      aka.ms/movespforms

    • @raslaankhan5146
      @raslaankhan5146 6 месяцев назад

      ​@@RezaDorraniHi Reza, how to get the inventory of custom sp forms like in the second last slide?

    • @RezaDorrani
      @RezaDorrani  6 месяцев назад

      @@raslaankhan5146 that slide shows a gif.
      Its from CoE power bi report.

    • @raslaankhan5146
      @raslaankhan5146 6 месяцев назад

      @@RezaDorrani How to get it or generate for a tenant?

    • @RezaDorrani
      @RezaDorrani  6 месяцев назад +1

      @@raslaankhan5146 Check documentation on CoE Toolkit. It has all details on how to install.

  • @accordeonist
    @accordeonist 6 месяцев назад

    What is the point of all this complexity? All of this to make the sharepoint form look slightly better? I don't understand the business case use her especially when you can't even share the app?? There is no real way to deploy the app...

    • @RezaDorrani
      @RezaDorrani  6 месяцев назад

      This is not an app. Its form customization using low code toolset.
      Try creating a cascading dropdown for your sharepoint form.

    • @nomanshaikh3495
      @nomanshaikh3495 5 месяцев назад

      we can show and hide some fields based on the value of other control but cannot make them mandatory using OOTB json form formatting.
      Use case could be if the status is set to critical then the expected resolution date field should be mandatory.

  • @NatashaPashkina
    @NatashaPashkina 25 дней назад +1

    great video Reza, so grateful for your support. for the people picker and replacing modern with classic combobox, it sorta worked for me but not completely. instead of the names, i have this format: i:0#|membership| first_lastname@companyname. any suggestions on how to fix?

    • @RezaDorrani
      @RezaDorrani  25 дней назад

      Not experienced that so not sure.