SharePoint Form Customization with Modern Power Apps Controls | Step-by-Step Tutorial
Вставка
- Опубліковано 6 сер 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: ua-cam.com/users/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 - Наука та технологія
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.
It is an amazing feature indeed.
I appreciate how thorough you are and how you always think from the user's perspective. It's evident that you put a lot of effort into creating your videos, addressing all the potential questions on the topic before they even arise. You have a remarkable ability to anticipate and answer people's queries, almost like you're reading their minds. I am truly impressed by how you help the entire community. Keep up the fantastic work!
Thank You so much for all the appreciation.
A lot goes in to make these videos. Very happy to see this feedback.
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.
Thank You so much! We all learn together.
I built a modern SharePoint List form last week. This video is right on time!
Great!
This is a great update video showcasing the modern controls and some new little nuances I didn't know about! Thank you.
Glad you enjoyed it!
Awesome video Reza. It blows my mind how much you can do with the Power Platform. And it keeps getting better.
Thanks Nick. Im so happy to hear the feedback.
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!
Thank you very much!
Hello Reza, this video is indeed amazing as lot of required settings you explained. However, i most liked navigating to the version details page directly. Thanks a lot as always. :)
Glad to hear that! Thanks for watching
Excellent video Reza, as always.
Thanks
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!😊
Thanks so much.
Hopefully it will happen someday.
Clean and very understandable tutorial. Thx for that
You're welcome!
This is amazing. Thank you Reza!
Thanks for watching
Thank you Reza. The modern control is really a game changer
Most welcome!
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?
@@yankeedoll2jeter Option is moved to General Tab.
Always best to check documentation
As always..reza will come out with a great tutorial to learn..keep the good work❤
Thank you so much
Thats a very good Video Thanks a lot !
You are most welcome!
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.
Thank You so much for the amazing feedback as always. Much appreciated!
Reza's videos creates magic of learning to everyone with enjoyment 😄
Thanks
Thanks for share you knowledge, you are the best
Thank You so much
Cool stuff!
Thanks
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.
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.
Amazing!
Thanks!
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.
Thanks!
I have not experienced any such issue.
Fantastic 🎉🎉🎉
Thank you! Cheers!
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!
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
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?
Most welcome!
No license needed. I showed a snapshot of the license in video 😊
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!😄
Most welcome!
Thank you for this very informative video. Do you please know how to empty/blank the Assigned To combobox based on some check?
Welcome!
I don’t have a video reference on that scenario
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! 👍
Bcoz forms formmode property still resulted in caching issues upon testing.
@@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!
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.
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.
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.
Showing and hiding is not true security. Views is not security.
But you can share a link to views with users.
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.
Most welcome!
Content type support is not in release planner for now. I am not sure of the future.
Hi Reza, Thank you for this video! May I know if Modern Controls can be used in Production?
Modern controls are in preview. Wait until GA.
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
You would need to add the column in SharePoint first.
Then edit power app and add that column to form.
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?
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
Thank you so much for your video! Do you have a video where you explain how to make Formscreens for different "Views" in the SharePoint list? That would be very helpful!
Most welcome!
I do not have a video reference on that.
@@RezaDorrani Do you know if this is possible to create?
@@Le.K457 Not sure as I have not tried this scenario
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...
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.
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.
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.
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.
You cannot hide the OOTB save button as far as I know.
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.
Modern controls don’t support person and managed metadata fields completely as of now
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!!
Group headers is not an option. You would need to create 2 separate columns.
@@RezaDorrani Thanks so much for your reply!!
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?
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
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?
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.
@@RezaDorrani Thank you Reza for your invaluable help ( as always)
Hi Reza, I'm using this SharePoint form customization using PowerApps, my list view has already exceeded the look up column threshold. I wanted to add another People picker column in my form. Do we any work around to add people picker column in the list and use in my form?
I don't think there is a workaround apart from not using more complex type columns
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?
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 :)
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
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.
Thank you for the reply😊
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.
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.
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?
Item level permissions ua-cam.com/video/EJyZfYMi4n0/v-deo.html
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.
I made a video on it months ago
ua-cam.com/video/-AQ_lcpaRec/v-deo.htmlsi=AQBXOITpEdQHiRr_
Thanks Reza! Does users need power apps license for this?
An office license that includes power apps will suffice
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.
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
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
An update on this, it takes like a day for sharepoint to reflect display changes.
@@PowerUserJ I have not come across this issue so no updates from my side
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) ?
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
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?
Have not tried this so not sure.
Hi, thanks for a amazing content. I'm having an error "onsuccess" with this formula. ResetForm(SharePointForm1);RequestHide() RequestHide() is not accepted.
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
Hello, I’m new to sharepoint lists and power apps. Can I ask if it’s possible to only share the power apps form to users without letting them see the sharepoint list? I wish to pre populate the list and allow users to amend the data using power apps form. Any changes should be saved back to the list.
No. Users would need access to the list.
You could show and hide things but the user would need permissions granted on list.
Thanks Reeza
can you take full session on power platform basic to adwance on live
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.
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?
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
Hi Reza. I completed my first customised form after watching this video and one or two others you did. Thanks for sharing your knowledge. Unfortunately, after publishing the form and trying to load it as a user, I got an error message saying I don't have a Power Apps plan and need to ask my admin for one or start a free trial!
This didn't make sense to me so I looked on the MS Forums and apparently it is a known issue, only standalone apps need licensing but customised forms for SharePoint lists don't. I wondered if you had encountered this yourself (or know others who have) and how it got resolved? Thanks
All apps need a license depending upon connectors used. Premium if premium connectors, basic if standard connectors.
@@RezaDorrani Thanks Reza. That should be the case but the app doesn't contain any premium connectors. It's a simple form to replace the standard SharePoint list form, which I made from the list by clicking Integrate > Power Apps > Customise Form. It doesn't link to any outside programmes. It seems that users require a special licence even to just view a form made with Power Apps.
@@RShand-je1rl I have not experienced this hence not sure whats the special license needed in your case.
I will recommend posting your issue on forums in case someone has experienced something similar powerusers.microsoft.com
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??
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
@@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...
@@UndeniableLogic Not sure what options are there apart from securing the data but SharePoint does not offer column level security
@@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? 😅
@@UndeniableLogic maybe
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?
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.
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?
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
@@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.
@@gberosh Ok. Thanks for sharing
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.
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
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.
Thats right. Always best to test things out first.
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.
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.
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!
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.
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?
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
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
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
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
There is no ALM with SP custom forms.
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.
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.
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.
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".
Thats only to open it in a dialog format where chrome is stripped out.
I have explained entire url in video.
@@RezaDorrani Thank you! If found the issue and it is working now :)
@@path_ethics I recommend posting your issue on forums at powerusers.microsoft.com
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.
I have not faced this issue so not sure.
Hi Reza,
I created the custom form, however when multiple items are selected, it doesn't display the form I modified in PowerApps.
Form only works for single item. This is by design.
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
Possible but not something I have tried
@@RezaDorrani Maybe an idea for a video haha? Need to do it at my studentjob:)
@@nightwalker7723 No plans for this one as I have hardly got any requests on this topic.
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
Whats a standard version? Is that power apps or out of the box sharepoint.
Attachments in power apps download by default.
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.
I think its possible but not something I have done. I will recommend checking on forums at powerusers.microsoft.com/
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.
Possible! I have done several videos on form control where I have shown that.
@@RezaDorrani Thank you so much I will surely check them out
Did they remove the modern controls and themes option? I don't see the toggle when I search for it under upcoming features. 🤔
Its now in General Tab
@@RezaDorrani thanks! I don't know why I didn't check there. 🤦♂😆
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
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.
How do we get the Audit History of the Dataverse Table in the Canvas Power App? is it possible?
I have not tried it so not sure. But definitely possible as audit history can be obtained via api.
@@RezaDorrani Thanks for your quick response 💗
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.
Templates for SP lists do not support SP custom list forms.
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.
@@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.
@@RezaDorrani I am also not talking about the standalone apps. I do the hacks and it's working fine for me.
@@raslaankhan5146 Its a hack at the end of the day and not a recommended approach.
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?
There is only 1 versions page per list. Im not sure how to I can help u find it.
@@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.
check if version history is turned on for your list in settings
@@RezaDorrani Yes, it is turned on, I have checked it. It was my first idea too.
@@worxart Ok. Im not sure how I can help though.
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
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.
@@RezaDorrani thank you so much.
Hi Reza, Thanks for making this wonderful video. there is only one error I am getting. I have created one column called Approval Info where we capturing all approval comments coming via flow. It was working well in SharePoint form, but when we changed to Power apps form, I am getting response comment along with format coding also.
Example : Approval started by &#AB; Bapun Choudhary
Would you please advise, how to fixed this.
Many Thanks..
That column is probably a rich text column in SharePoint. Try using the html control in power apps to show the data.
I don’t have a specific video on that type of column.
@@RezaDorrani : Thanks for your quick Inputs, however i could not succeed. The reason I was try using power apps form so that I can increase the width of the Approval Info column to capture the approvers comments for better view. Would you please guide me how to increase the column width in SharePoint forms. please note, I am using your Style HTML output which is working fine & I only wanted to increase the Approval info box size, That will also solve my query. thanks in advance.
@@BapunChoudhary My best guidance are my videos.
I would recommend posting your issue on forums in case someone has tried or experienced something similar
powerusers.microsoft.com
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.
Modern form control is in preview.
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.
Power apps is not a data source. Ideally you should be saving and retrieving data from a data source. Check my videos on delegation.
@@RezaDorrani if you could send the specific link for that video, will highly appreciate it. thank you.
@@j.bagalay1623 Search for “power apps delegation reza” and you will get the videos
Hello sir, why is it when I click "+New" in SP, it doesn't display the design that I made in Power Apps?
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)
@@RezaDorrani thank you sir
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?
Sir I answered this question here
ua-cam.com/users/liveoSPw6WJdPoA?si=D9yeMrKRUBn585We
Is it as well to use a canvas app so you have better ALM?
Yes but this is an experience for SP specific scenarios.
@@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.
@@disturbedcarrot Its a choice. Pros and cons are there. I do not plan a video on it though :)
Can you do this with content types enabled on the list?
Power Apps does not understand content types
@@RezaDorrani thanks for the quick reply, but not the answer I was hoping for!
@@Ploplox I dont think its a feature in power apps. Try checking on forums in case someone has done something similar powerusers.microsoft.com
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?
You need to have owner or edit list permissions + may be your admin has disabled this option for list/library
Is there a way to print a created custom form that has data entered?
I dont think print function is supported for SP custom forms.
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!!
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
I ran into a problem which is error messages card are not working properly. Any hints?
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
"Sir, can you please tell me how to add the modified date with the current date and time?
Where to add?
You simply add those data cards to form (they are system fields though)
@@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."
@@shrutichavan3404 Change the view to include those columns.
@@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.
@@shrutichavan3404 I will recommend posting your query on forums
powerusers.microsoft.com
Modern Controls are moved Under General tab in Settings🙂
Yes and as time progresses will move out from there completely.
How to move same customized app into new environment
aka.ms/movespforms
@@RezaDorraniHi Reza, how to get the inventory of custom sp forms like in the second last slide?
@@raslaankhan5146 that slide shows a gif.
Its from CoE power bi report.
@@RezaDorrani How to get it or generate for a tenant?
@@raslaankhan5146 Check documentation on CoE Toolkit. It has all details on how to install.
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
That size is fixed for the panel. Landscape or portrait. Not much can be done there.
Okay thank you, yes cause the out of box sharepoint has a comment section we found useful. Appreciate your help! Thanks
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...
This is not an app. Its form customization using low code toolset.
Try creating a cascading dropdown for your sharepoint form.
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.
Hi Reza, I've done everything you shown up to 7:55, but for any reason, some of my choice column are now displaying
[{"@odata.type":"#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference","Id":4,"Value":"Devices"}]
and so the patching is in trouble when I try to save the modification
any advice ? thanks
Video description has link to download entire solution (members only - check description for details)
I would suggest giving that a try.
As for the issue mentioned, i have not experienced the mentioned 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
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?
Not experienced that so not sure.