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!
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.
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!😊
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.
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!
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.
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. :)
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.
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.
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!😄
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.
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
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
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! 👍
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, 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
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.
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!!
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
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.
Hi Reza, Great video, just like your other video's. They have helped me and my colleagues a lot! I hope you can help me with an issue I have with the modern date picker. Example: I have record in my list (let's call it record 1) for which I have left the date picker field deliberately empty. Then, I open another record (record 2) for which the date picker has been populated with a date. Then, I close record 2 and open record 1 again. Now, instead of showing the date picker field to be empty, record 1 actually shows the date that was in the date picker field for record 2. (When I then edit record 1, the field will actually show empty, as it's supposed to be. How can I ensure that empty date picker fields will also really show as empty in the view mode?
I would have to recreate this scenario to know the cause or recommend a solution. I suggest posting your issue with screenshots on forums at powerusers.microsoft.com/
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
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
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?
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 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.
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.
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.
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.
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?
Hi reze great video , i have a small doubt after watching your video i tried creating a similar app but my onnew and onedit is not at all working as expected
I have not experienced the mentioned issue, hence not sure whats the cause for your issue. You can try downloading the solution shown in video (members only - check video description for details)
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
how does the item description history work? Should it display the past version's values for that column. It is always blank even when we have versioning turned on and edit the item description
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
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.
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
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.
@RezaDorrani thanks for your answer. I've come accross the API limitations recently and I'm concerned about surpassing those limits. Would be great if you can do a video going into detail for what counts as API call in a power app.
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 been using sharepoint custom forms for a while. Today, octobert 8th, I noticed Microsoft changed the screen/form settings. When clicking on the 'new' button, the form opens in a different window size in the middle of my screen in stead of on the side. Consequence is that I have to scroll from left to right to edit my form. Of course I could resize my form and adjust the layout, but I was wondering if there are any better solutions than this. Kind regards, Eric
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.
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, 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
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
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?
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.
@@Rich-hm9ux I was having the same issue. I reverted the "Item" property back to SharePointIntegration.Selected, then adjusted the DefaultMode to If(varFormType = "View", FormMode.View, varFormType = "Edit", FormMode.Edit, varFormType = "New", FormMode.New) and that seems to be working. For now anyway. Modern form is definitely still buggy.
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.
Hello Reza, the latest update of SharePoint lists makes the new and edit form appear in a dialog box, so the form is quite limited in its dimensions. How can I prevent this?
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.
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 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
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
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
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? 😅
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.
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".
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.
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.
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.
Hi Reza, I've built a Sharepoint list form using Power Apps. However, When i click on edit(to edit a line item), the details vanish when the form window opens. Please help.
@@RezaDorrani 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.
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.
Hi Reza I have created a custom sharepoint form. It's doesn't load at all. If I clear the cache it loads. But if I refresh my sharepoint list then I get "app refused to connect error". If I clear cache then again it works. I don't understand why this happening. Every time I can't clear the cache to make app work. Do you have any idea why this issue occurring?
I have not experienced the mentioned issue, hence not sure. I will recommend checking or posting your issue on forums in case someone has experienced something similar community.powerplatform.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.
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.
Wow, in 30 minutes you covered 100% of the most important parts of form customization. Impressive.
Thanks so much and very happy to hear the 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 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.
I built a modern SharePoint List form last week. This video is right on time!
Great!
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, 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!
Reza's videos creates magic of learning to everyone with enjoyment 😄
Thanks
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.
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
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.
As always..reza will come out with a great tutorial to learn..keep the good work❤
Thank you so much
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!
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
Clean and very understandable tutorial. Thx for that
You're welcome!
Very clear , thank you for this sharing
You're most welcome
Excellent video Reza, as always.
Thanks
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.
Thanks for share you knowledge, you are the best
Thank You so much
Great video, Reza
Thanks for the visit
Great Content!
Thank You
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.
Cool stuff!
Thanks
Thats a very good Video Thanks a lot !
You are most welcome!
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
Amazing!
Thanks!
This is amazing. Thank you Reza!
Thanks for watching
Fantastic 🎉🎉🎉
Thank you! Cheers!
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.
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!
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😊
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.
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
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
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!
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 😊
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
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.
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. 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!!
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
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.
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, Great video, just like your other video's. They have helped me and my colleagues a lot!
I hope you can help me with an issue I have with the modern date picker. Example: I have record in my list (let's call it record 1) for which I have left the date picker field deliberately empty. Then, I open another record (record 2) for which the date picker has been populated with a date. Then, I close record 2 and open record 1 again. Now, instead of showing the date picker field to be empty, record 1 actually shows the date that was in the date picker field for record 2. (When I then edit record 1, the field will actually show empty, as it's supposed to be.
How can I ensure that empty date picker fields will also really show as empty in the view mode?
I would have to recreate this scenario to know the cause or recommend a solution. I suggest posting your issue with screenshots on forums at powerusers.microsoft.com/
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, 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
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
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 :)
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 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.
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
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.
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.
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
Hi reze great video , i have a small doubt after watching your video i tried creating a similar app but my onnew and onedit is not at all working as expected
I have not experienced the mentioned issue, hence not sure whats the cause for your issue.
You can try downloading the solution shown in video (members only - check video description for details)
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
how does the item description history work? Should it display the past version's values for that column. It is always blank even when we have versioning turned on and edit the item description
It's an out of the box feature. Not sure why you would be getting blank
Thanks Reza! Does users need power apps license for this?
An office license that includes power apps will suffice
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
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.
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, 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
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.
Hi Reza, saving and updating fields with this app will make API calls to the SP list?
Yes. It will be the case with any app.
@RezaDorrani thanks for your answer. I've come accross the API limitations recently and I'm concerned about surpassing those limits. Would be great if you can do a video going into detail for what counts as API call in a power app.
I have no plans for a video on that topic.
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
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
Hi Reza, I've been using sharepoint custom forms for a while. Today, octobert 8th, I noticed Microsoft changed the screen/form settings. When clicking on the 'new' button, the form opens in a different window size in the middle of my screen in stead of on the side. Consequence is that I have to scroll from left to right to edit my form. Of course I could resize my form and adjust the layout, but I was wondering if there are any better solutions than this. Kind regards, Eric
I am not aware of any better solutions at the moment
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_
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, 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
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
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.
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
@@Rich-hm9ux I was having the same issue. I reverted the "Item" property back to SharePointIntegration.Selected, then adjusted the DefaultMode to If(varFormType = "View", FormMode.View, varFormType = "Edit", FormMode.Edit, varFormType = "New", FormMode.New) and that seems to be working. For now anyway. Modern form is definitely still buggy.
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.
Hello Reza, the latest update of SharePoint lists makes the new and edit form appear in a dialog box, so the form is quite limited in its dimensions. How can I prevent this?
I have not explored the options on this since the update
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.
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 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.
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
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
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.
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
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,
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.
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 💗
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
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.
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.
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.
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
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.
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 :)
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. 🤦♂😆
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/
Hi Reza
I have created a custom sharepoint form. It's doesn't load at all. If I clear the cache it loads. But if I refresh my sharepoint list then I get "app refused to connect error". If I clear cache then again it works. I don't understand why this happening. Every time I can't clear the cache to make app work.
Do you have any idea why this issue occurring?
I have not experienced the mentioned issue, hence not sure.
I will recommend checking or posting your issue on forums in case someone has experienced something similar
community.powerplatform.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.
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