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.
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 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.
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.
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
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!😄
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! 👍
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
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.
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.
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.
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!!
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
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.
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.
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.
Reza once again thank you for a fantastic video. When following the video 2 issues occur: - When testing the app after setting Item property formType - New and so on the Form becomes invisible running in app test. (Ok from the SharePoint interface) - Combobox/multi select picks up an empty value in brackets and makes it a default choice. Any idea how to slove these 2 issues? 😁
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 it 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
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?
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 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
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
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.
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?
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?
Hello Reza. My version customized form do not saves a new item. I already tried to used the sharepoint built in save button, created a save button and applying patch function, but all of them resulted to patch function network error. Do you have any idea that is the reason?
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
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.
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 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.
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
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
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
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.
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
@@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
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.
Hello thank you for the video. Question: is it possible to open the customized sharepoint form on the mobile phone? I have downloaded the sharepoint application on my phone but when I click on (+) it opens the classis sharepoint form.
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
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, 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
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?
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".
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 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 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? 😅
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.
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)
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.
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
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 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.
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.
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
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 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.
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.
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 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 "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 Good morning, I checked & found the one in which you have shown it with example on ‘Discount’ . But it a text/number. I am trying to change the ‘mail id’ and the choice name is ‘Assigned to’ with Person option. If you have specific video on this, please let me know. Thanks🙏
@@DEEPAK-cf7rz I probably dont have a specific video on that. Il recommend checking or posting your query on forums in case someone has done something similar powerusers.microsoft.com/
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...
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.
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.
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!😊
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.
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 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!
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. :)
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
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.
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.
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.
Hi Reza, thank you for the excelent video. I am facing somethink like "maybe caching issue" with choice column values, but I am not sure by the reason. I did everything according your recommendation around caching issue, but my form does not work properly. At the moment when the form is published, everything works fine, all selections are avalaible, even opened existing item are shown OK. However, when the sharepoint list is refreshed in browser, values from all choice columns dissappear, i.e. no choice on new form, now values shown on existing items. Tested on several computers and still the same behavior. Do you have any advice to fix this please? Thank you
@@RezaDorrani Thank you for quick answer. I will keep searching. I noticed, than more and more people are comlaining about this issue, because this stops their application development in reality.(just like mine 😕)
@@RezaDorrani Hi Reza, one more observation. I found out a moment, when "colapsed" choice columns are restored and form works properly again properly. I did no changes on my form, I played with refreshing the list (page) only. As I mentioned above, the form colapsed when the item is shown (clicking on the item) and after that the the list (page) is refreshed. At this moment every choice collumns stop working or showing the data. Does not matter on the state (new, view, edit). But, if the page is refrehed again and I click to new item the first, the form is reloaded in proper way and everting works fien (viewing existing items or editing) ... until next page refresh after viewing the item. Sorry for comlicated description, but it seems to be some loading issuie of the form (mabye some kind of getting data issue). I tested this on different web browsers and still the same behavior. Moreover, if the form is "broken" in one browser, it does not work on the second one also (even between computers). My conclusion is, that it should not be a problem of caching, but maybe of power apps form as such ... but I do not know. (or something in list settings 🤔) If you have any ideas, I would appreciate it so much. Thank you
@@lukashora_cz I have no idea on this. I will recommend posting your issues with screenshots on the forums at powerusers.microsoft.com/ in case others have experienced something similar
I really appreciate your content and I have learned a lot. At 12:31, you explain the technique for preventing browser caching issues. I have applied this to two different forms and it doesn't appear to work. I keep having to refresh my browser or open the most recent version of the form in a new incognito window to see the new form updates. Just wondering if something has changed with Power Apps where this solution no longer works?
@@RezaDorrani For me, it doesn't show the newly updated form right away but I think will show it on the second or third refresh without me having to open in incognito mode. Thanks.
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
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.
I built a modern SharePoint List form last week. This video is right on time!
Great!
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's videos creates magic of learning to everyone with enjoyment 😄
Thanks
As always..reza will come out with a great tutorial to learn..keep the good work❤
Thank you so much
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
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!
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.
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.
Clean and very understandable tutorial. Thx for that
You're welcome!
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
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!
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!
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
Thanks for share you knowledge, you are the best
Thank You so much
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
Amazing!
Thanks!
Thats a very good Video Thanks a lot !
You are most welcome!
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. 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.
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, 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!!
This is amazing. Thank you Reza!
Thanks for watching
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.
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.
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.
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.
Reza once again thank you for a fantastic video. When following the video 2 issues occur:
- When testing the app after setting Item property formType - New and so on the Form becomes invisible running in app test. (Ok from the SharePoint interface)
- Combobox/multi select picks up an empty value in brackets and makes it a default choice.
Any idea how to slove these 2 issues?
😁
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 it 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
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, 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. Would it be possible to disable the display mode of the submitted form when viewing even if the edit button is selected?
You could write some logic in the display mode property of form to do that
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
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
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.
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 th-cam.com/video/EJyZfYMi4n0/w-d-xo.html
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 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
Hello Reza. My version customized form do not saves a new item. I already tried to used the sharepoint built in save button, created a save button and applying patch function, but all of them resulted to patch function network error. Do you have any idea that is the reason?
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 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
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.
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
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
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
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!
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. 🤦♂😆
Thanks Reza! Does users need power apps license for this?
An office license that includes power apps will suffice
Is it possible to display the form and the list on a PBI dashboard?
Not sure why you would want to do that.
Pbi can connect to SharePoint and you could add power apps visual in power bi.
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
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 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
Hello thank you for the video. Question: is it possible to open the customized sharepoint form on the mobile phone? I have downloaded the sharepoint application on my phone but when I click on (+) it opens the classis sharepoint form.
It does not work from SharePoint mobile app. That’s a documented limitation.
@@RezaDorrani ok , can I replicate the customized form in power app then?
@@fabrizioorlando-nk7gs You can create a standalone power app.
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
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
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, 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.
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
th-cam.com/users/liveoSPw6WJdPoA?si=D9yeMrKRUBn585We
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
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'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.
Fantastic 🎉🎉🎉
Thank you! Cheers!
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.
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
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
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 💗
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
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 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.
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/
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
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 :)
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.
"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
I reqd u r help regarding wait & approval with text. I want to change the Assigned to mail id. Please let me know, how it is possible
Check my playlist on approvals. I have done various videos showing different techniques.
@@RezaDorrani Good morning, I checked & found the one in which you have shown it with example on ‘Discount’ . But it a text/number. I am trying to change the ‘mail id’ and the choice name is ‘Assigned to’ with Person option. If you have specific video on this, please let me know. Thanks🙏
@@DEEPAK-cf7rz I probably dont have a specific video on that. Il recommend checking or posting your query on forums in case someone has done something similar powerusers.microsoft.com/
@@RezaDorrani Hello, can you please try this for me. I want to change ‘emai’ in approval form using wait & approval of text. Pl help
@@DEEPAK-cf7rz I would have to try it out to know the steps. Im working on my next set of video ideas. Forums would be your best bet.
Modern Controls are moved Under General tab in Settings🙂
Yes and as time progresses will move out from there completely.
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
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.
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.
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.
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.
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.
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!
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
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.
Great Content!
Thank You
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
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.
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
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.
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 😊
Very nice! Thanks for the insights!
Is it possible to create a PowerApps Form which can populate two different SharePoint Lists?
Welcome!
Not sure if same form can populate 2 lists.
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.
Cool stuff!
Thanks
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.
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.
Excellent video Reza, as always.
Thanks
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.
Hi Reza, thank you for the excelent video.
I am facing somethink like "maybe caching issue" with choice column values, but I am not sure by the reason. I did everything according your recommendation around caching issue, but my form does not work properly. At the moment when the form is published, everything works fine, all selections are avalaible, even opened existing item are shown OK. However, when the sharepoint list is refreshed in browser, values from all choice columns dissappear, i.e. no choice on new form, now values shown on existing items. Tested on several computers and still the same behavior.
Do you have any advice to fix this please?
Thank you
I have not experienced this issue beyond the first refresh. Im not sure what the fix would be.
@@RezaDorrani Thank you for quick answer. I will keep searching. I noticed, than more and more people are comlaining about this issue, because this stops their application development in reality.(just like mine 😕)
@@lukashora_cz I understand the challenge but not sure how I can assist
@@RezaDorrani Hi Reza, one more observation. I found out a moment, when "colapsed" choice columns are restored and form works properly again properly. I did no changes on my form, I played with refreshing the list (page) only. As I mentioned above, the form colapsed when the item is shown (clicking on the item) and after that the the list (page) is refreshed. At this moment every choice collumns stop working or showing the data. Does not matter on the state (new, view, edit).
But, if the page is refrehed again and I click to new item the first, the form is reloaded in proper way and everting works fien (viewing existing items or editing) ... until next page refresh after viewing the item. Sorry for comlicated description, but it seems to be some loading issuie of the form (mabye some kind of getting data issue).
I tested this on different web browsers and still the same behavior. Moreover, if the form is "broken" in one browser, it does not work on the second one also (even between computers). My conclusion is, that it should not be a problem of caching, but maybe of power apps form as such ... but I do not know. (or something in list settings 🤔)
If you have any ideas, I would appreciate it so much. Thank you
@@lukashora_cz I have no idea on this. I will recommend posting your issues with screenshots on the forums at powerusers.microsoft.com/ in case others have experienced something similar
I really appreciate your content and I have learned a lot. At 12:31, you explain the technique for preventing browser caching issues. I have applied this to two different forms and it doesn't appear to work. I keep having to refresh my browser or open the most recent version of the form in a new incognito window to see the new form updates. Just wondering if something has changed with Power Apps where this solution no longer works?
Im not aware if anything has changed since.
@@RezaDorrani For me, it doesn't show the newly updated form right away but I think will show it on the second or third refresh without me having to open in incognito mode. Thanks.
@@Rich-hm9ux ok
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