Customize SharePoint list forms with Power Apps

Рет қаралды 29,837

Күн бұрын

Пікірлер: 73

@RegalEase 11 ай бұрын

Something worth mentioning (and you touched on it by saying the more complicated it gets...beware) is that OnStart and the first screen's OnVisible only gets called when the SharePoint page is loaded in the browser. It does not get called when the form is opened. So if you use variables, collections, etc. they need to be cleared or reinitialized in the OnSave, OnCancel, etc. functions.

@ShanesCows 2 ай бұрын

This is a nice tip that I missed when you orginally shared. Thanks!

@stefancochrane2723 11 ай бұрын

Thanks, Shane! In our case, 95% of the PowerApps forms we have done the past 3-4 years has been for customizing SharePoint lists, like you do here. Many times, we create these when there is extra functionality (e.g., hide-when's, conditional dropdowns, calling flows directly). Also, for internal clients, the system they want is usually very specific, and they prefer not to see it in the list of PowerApps and ensure the security is inside the SPO site. Caching is a mess, and I usually put a "v1", "v2", etc., too, to make sure changes take.

@andrewsmalley 11 ай бұрын

Great video Shane! 🎥🐕My first ever Power App I built in 2018 was a Custom Form in SharePoint! I generally don't use these anymore as I prefer building apps to provide a better UI/UX. However, you taught me something new today as I had no idea that the Custom Form 'Edit' & 'Save' buttons were editable via the OnEdit & OnSave properties in Power Apps. I loved the fact that you could trigger a flow by customizing these buttons in SharePoint lists!! 💖 Thanks a lot!!

@ShanesCows 11 ай бұрын

Happy to help Andrew! Hope you are having a great day.

@sdrtyu 11 ай бұрын

Thank you for this video! One caviat with this is that the testing becomes diffficult, especially UAT. Once the form live it's difficult to make changes in the future. What are your thoughts on that? Could of course create another identical sharepoint list and try to copy paste elements across the apps but this way seems prone to human errors 😢

@ShanesCows 11 ай бұрын

Yeah. I think this is why I am not a fan of advanced custom forms. Just the basics, that way if you do have to make a change it is minor and you aren’t overly afraid of it.

@2007pradipta 4 ай бұрын

thanks Shane for nice info video. If I add this list to a different page with help of *List Webpart* the Forms (New/Edit/View) are opening in a different page itself not like Side Dialoge.

@ShanesCows 4 ай бұрын

Yeah, not surprising. They only do the side car on the native page as far as I know.

@andynglmable Ай бұрын

Hi Shane, I love your Tutorials and helps me a LOT!!!! So BIG Shout out to you and THANK YOU. I need to display ID on default forms which could not solve, so I was trying custom forms but I need the new OOTB Comments section where @ sents notification to user. Is this possible?😅

@ShanesCows Ай бұрын

The Comments stuff is available via the SharePoint Rest API. Someone did a video on it recently but I have not.

@chriseiserbeck9000 9 ай бұрын

Another really helpful video Shane - is the functionality you describe also available if you are accessing the Sharepoint list via the MS Lists App?

@ShanesCows 9 ай бұрын

I don’t believe so.

@mblherry 6 ай бұрын

Thanks Shane, great video! Can you add a button on the SharePoint Custom form to save the item?

@ShanesCows 6 ай бұрын

Yes, look at the logic in the OnSave property of the sharepoint integration and add that same logic to the button. :)

@paulrockliffe2378 11 ай бұрын

Great timing, I was building a form earlier today! Do you know if its possible to do a save and open the next record and to filter to only records with a null in a particular column? I'm adding data to a List that gets created from Power BI data and want to cycle through just the ones that need extra info adding without having to open, edit, close, open, edit, close etc etc

@mariocesena2277 9 ай бұрын

Thank you, Shane! Is there a way to have this form appear on my SharePoint home site as a web part, so users are not redirected to the list site when they want to add a new item to the list?

@ShanesCows 9 ай бұрын

YOu would have to make a standalone app. Then you could add it to the homepage, there is a Power Apps web part on modern sites.

@kenpennuto2590 8 ай бұрын

Ok. Shane, I get that it’s a thinned down version just for SharePoint. That being said, when you go to customize your list form, it’s not actually doing a customization of the original form, it is in essence creating a new form with that data connection. In fact a strangely narrow and almost unusable variant. How can we actually Edit “customize” the actual SharePoint form we started with? I’ve done a lot of customizing of the layout and dynamic hiding of fields with json code, none of which is in the “new” form power apps wants me to customize. So id have to redo all that work. I just want to add some check boxes to some multiple choice fields instead of the default check and go lists it presents to me. Thoughts??

@q2l867 5 ай бұрын

How to do I cancle this and go back to editing the list just from sharepoint as it causing me issues with choices columns

@sandramcgechan5817 4 ай бұрын

Another great video, thank you! I'd like to take a three month sabatical off work just so I can watch all your videos and finally get up to speed on Power Apps! :D I've got a lot of legacy lists that aren't suitable for 'app-ifying' but would benefit from a PowerApp form. BUT some of these lists are quite lengthy and I find that the SharePointForm1 is SO PAINFUL to work with. I have just spent several hours this morning trying to convince it to lay a form out as I wanted, those darned datacards just didn't want to move! If I delete SharePointForm1, I lose the ability to get a scrolling form, don't I? Or can I add a new (scrollable) screen and then delete FormScreen1 (and update the SharePointIntegration properties to point to the new form)? Do I still have to use datacards or can I just put labels and input controls into the screen as I wish?

@ShanesCows 4 ай бұрын

You could build your own scrollable screen, you don't have to use a form at all kzbin.info/www/bejne/Zp2xfGx4rZmEgac

@sandramcgechan5817 4 ай бұрын

@@ShanesCows Brilliant, thank you!

@CircusBrain 9 ай бұрын

What if I only wanted a form for New, but the sharepoint list standard edit experience for editing? Is it all PowerApp in SharePointIntegration or can OnEdit be set to the Sharepoint List DispForm.aspx?

@ShanesCows 9 ай бұрын

It is all or nothing. Sorry.

@steventhawe1598 11 ай бұрын

Thanks Shane!

@ShanesCows 11 ай бұрын

Happy to help. Have a great day. 🐶

@gillessylvestre9443 6 ай бұрын

Hi Shane. What about migrating customized forms from dev to prod?

@ShanesCows 6 ай бұрын

No real way to do it that I know of.

@gillessylvestre9443 6 ай бұрын

@@ShanesCows Hi Shane. Thank you for the fast response. I found this very good tutorial on how to do it. kzbin.info/www/bejne/g3SroXmtlq2Bjrs My next challenge? Script the whole process because I have 85 of them....

@jeffsimmons9373 4 ай бұрын

So I don't really understand the logic of restricting sharing on Microsoft's part. If you make an independent Power App, don't users have to have access to the Sharepoint List datasource anyway? Seems arbitrary... Also, I noticed they changed the layout recently and it made me think that this power app "locked" to a List wasn't a thing anymore, but oh boy was I wrong... I tried to copy it as a separate Power App using "Save As", and then even tried to export and import it as new, and it still didn't work. I feel like there has to be a way to do this, even if it means I need to make a new list for the datasource. Any ideas? I'm not looking forward to rebuilding from scratch but so far that looks like what I'll need to do. Thanks for all your videos, they've been very helpful!

@Burnsez 2 ай бұрын

Can one use a custom app build outside of SharePoint in SharePoint?

@ShanesCows 2 ай бұрын

Not this way. In modern SharePoint sites there is a Power Apps web part you can use to embed that app into a page.

@Burnsez 2 ай бұрын

Did you already make a video for that? And I am getting way too excited about building user experience…. Thank you

@ShanesCows 2 ай бұрын

@@Burnsez It is in another video (don't remember which of the 500) I will have to ponder if there is enough for a whole video on this. Hmmm.

@praveenkoyyalamudi4768 3 ай бұрын

Hello Shane! Qucik question recently SharePoint Online list had new look of MS list, From that time the list customized with Powerapps were acting wiered, Click on Add new item button press for first time, giving the Form in new mode for first time fine and once you submit the form and click add new item button again without refreshing the browser it open the form in Edit mode with first Item data in the list. How do we resolve this issue. All i did create a sharePoint list with 3 text columns and customized with PowerApp from integration and Published it, no change, Added ResetForm(sharePointform1);NewForm(SharePointForm1) on the Newaction, still did not work, added Resetform on Success & also On Submit after submit function, nothing seems to be working.

@ShanesCows 3 ай бұрын

I am not sure. Maybe try creating a new list and don't edit anythign. Does it have the same issues?

@praveenkoyyalamudi4768 3 ай бұрын

@@ShanesCows yes it i did tried that, I have create a New list with 3 text columns, and went to integrations and select Powerapps and then Customize the form option, Once the Form Render, I just save and Published the Form without making any changes, It has same behaviour. 1 time worked fine, second new item creation picked the First item in the list.

@karrisrisatyavenkatakishor4770 19 күн бұрын

@@praveenkoyyalamudi4768does this resolved. ? My on new on edit is not working as expected

@kanwalsingh2802 10 ай бұрын

Hi Shane, I am facing a challenge. I have customer a form in power app and saved & Published but still can not see the customized form in SharePoint list. I have done the basic troubleshooting like refreshing data source in power app, republished, refreshed SharePoint list multiple times, tried different browser but still no luck. Any tip please?

@cristinaminami2162 6 ай бұрын

I had the same issue ... On the SharePointForm properties, you should change the "Default mode" to New. After changing this, it worked for me.

@oluwatobiyusuf 8 ай бұрын

Thank you Shane for this video

@ShanesCows 8 ай бұрын

Thanks for watching.

@spen2431 11 ай бұрын

As always thanks for sharing Shane 👍👍. One for the future? When you create an app, as the owner you get notified for app requests. Is there anyway to change this (as you can with Power BI reports/datasets). Although the app creator, I may not want to decide who should/should not have access. I have got around this with a Flow to forward the app request email - but its not as good as the Power BI way. 💥💥💥💥

@ShanesCows 11 ай бұрын

You could use this video to change the owner of the app? kzbin.info/www/bejne/j3KTepeFj9OAbZo

@spen2431 11 ай бұрын

Thanks for the reply. I don't want to make a business process owner (non technical) an owner of the app. The Power BI way to manage these notifications is much better and as its all part of the "Power Platform", could bring some shared functionality. @@ShanesCows

@shaikhrijwan9322 10 ай бұрын

sir... is it good to learn a sharepoint, power apps and power automate to get a job this year ?

@ShanesCows 10 ай бұрын

Yes, there are lots of jobs to be had in the Power Platform. 😎

@shaikhrijwan9322 10 ай бұрын

@@ShanesCows thanks 👍

@cassidionline2002 11 ай бұрын

I've been trying to implement this all day. I made a new entry form for one of my lists, but after countless refreshes, it's still using the default SP form. Any ideas?

@ShanesCows 11 ай бұрын

Did you save and Publish it? I have not ever seen it not show up at all like that.

@cassidionline2002 11 ай бұрын

@ShanesCows yep. I think it might have something to do with the SP site permissions. I tried a custom form on a less restricted SP site, and it worked.

@stefancochrane2723 11 ай бұрын

@@cassidionline2002 Ideally, you will have site collection admin rights to the site. If your list has lookups in other lists or sites, make sure your account has access there, too.

@MelissaReed-jb4ii 5 ай бұрын

@ShanesCows @Cassidionline2002 I'm having the same problem. I've tried changing Default mode to .New in the P/App form as someone suggested earlier. The list KNOWS it's there - when I click "customize" it pulls up my customized form to edit. The List just refuses to use it!

@MelissaReed-jb4ii 5 ай бұрын

And suddenly a few hours later it magically starts recognizing my custom form. Maybe an extreme version of the publishing delay Shane was talking about? I'd already given up and banged out a Q&D Canvas App for it. go to edit a value on the list item, and boom -- my custom Canvas app form finally shows up!

@shevatasaggar6036 21 күн бұрын

How to hide sharepoint buttons of the form while customizing new form

@ShanesCows 21 күн бұрын

Not possible as far as I know but I have never tried.

@abuotecho3963 9 ай бұрын

Thanks Young :)

@lowcodemastermindclub8337 10 ай бұрын

Any chance to add SharePoint PowerApps form into solution?

@ShanesCows 10 ай бұрын

Not that I know of.

@parranoic 5 ай бұрын

It worked so much better last year, I don't know what they did but sharepoint and powerbi integration are a nightmare to work with. 2 minutes it takes to rename a control, values show up as blank but they appear correctly in labels, 2 weeks to get the app to be shown in sharepoint and what's even worse even the support team from microsoft has no idea how to fix those issues (it's been 3 weeks since we open an incident)

@ShanesCows 5 ай бұрын

Yuck, I hope they find a fix for you. Slow editing it the worst.

@parranoic 5 ай бұрын

@@ShanesCows Managed to fix it myself by removing all the data sources and data cards that were buggy.

@jeffsimmons9373 4 ай бұрын

@@parranoic I was having a similar issue. Was it showing the DataField values for the datacards as "field_1", "field_2", etc, instead of the actual column names?

@parranoic 4 ай бұрын

@@jeffsimmons9373 that is normal, you need to check your sp list settings, if you don't manually create the columns by default they are named like that.