YOU ARE THE MVP. I was in tutorial hell and SHANE YOU ARE THE FIRST ONE THAT CLICKED FOR ME! either that, or my coffee is stronger than steel this morning. Im going to go with the former. I will be watching a whole lot more. I am one of those people that needs to get wheels spinning from watching small examples here and there.
@@ShanesCows I do have a question though. So can I have a button that says add, much like a job application does with your work history experience, that adds the same columns over again for the user to fill out? I have form where they may need to identify several people responsible for a project. They'd need to add each person's name and email, but the number of people may vary. Does that make sense?
I seriously LOVE YOU for making these vids. I have 3 different large scale projects at work, all of which I need to create PowerApps for data intake... I have absolutely no background in this so your content will be a lifesaver.
whenever i see your video, i know i am gonna learn many new thing in an easy and fun way. Thanks for all the information you share. Keep up the good work !
I HAVE to mention this....I wanted to hid something on a form. I was on the right path but was thinking to hard at it. SO...when I need an answer I go to Shane because who doesn't right? I jumped to just what I needed. Thank you again for making these videos. They are fantastic resources and you are always great to listen to! Have a great 2020!!
Thank you thank you!!!! I was running into the cache of cache thing!! It was making me mental, I could not figure out why my latest version was not showing!!! Your versioning label is a great idea, kudos!
Shane, just a quick thank you. Most helpful. Your quick videos are alway on topic and full of lots of tips and trick that get me thinking. Thanks and keep up with the “awesome” work. You can tell Todd that he needs to up his game now ;-)
@@ShanesCows I did, and I used the video to and it works in preview but it does not work from the sharepoint list. When I looked at other resources, they say that the print function has a known limitation with sharepoint custom forms
Hi Shane, all of your videos are great. I'm looking for a video with combo box on how to update items moving from one screen to another. I'm using 2nd screen where I add items in the library and when I go back to the combo box the items are not updated. Is any related video? Thanks Michael
@@ShanesCows Thanks for the reply. I have finally managed it. The combo box source is updating using on the first screen's OnVisible property and typing Refresh(firstscreensource).
Hi Shane, been loving your vids all day and learning lots!! I need to create a form that the user will submit which is then submitted to an admin team that will then need to complete a different form. Both forms will write to the same SP list. It so sounds possible but just unsure of how it will work.. (Form is to log a call with a maintenance team, flow will send notification to the team, once the team has completed they will then update the item to say complete and other items)
Thanks, it is very helpful. I am facing a problem, the (link) property does not pop up after I SharepointIntegration.selected. ? What should I do in this case? I tried copying the syntax you have shown but it does not work. has sharepoint changed something and link is called something else now? Thanks
Hey Shane, I don't know if this has been asked already but is there a way to backup the PowerApps List Form to be used as a template on multiple lists and on multiple sites, etc? I don't want to have to create the same design template over and over again so I thought I'd ask before I do that. Thanks.
I can't understand why there is a demonstration to email people when there isn't even a button to save the data which one would think is absolutely essential. It looks like there's videos specifically catered to saving however, and your material is always amazing so I should stop grumbling.
The save button in this scenario comes from the SharePoint Integration. You don't need on in your app. You set the OnSave property and that is how it is controlled. :)
Hi Shane..Your videos are always helpful! Can you suggest, Is it okay to use power app for customizing SharePoint forms if I have just taken trial of power app for 1 month for form customization, later I wont be able to update any changes in that form if required, as trial version will end. We are not going to buy power app license .Also after using power app & going back to Default form it is also rolling back all the formatting done tooltip etc.
Hi Shane! Thanks for your series, I saw all of them by now and its a LOT of info.. I have a 'nice to have' suggestion: Could you edit your description texts so that they include a sort of content table, preferably by function and/or best practice tips? I sometimes spend an hour just trying to find what you said about something because I just know I heard you say it at some point somewhere.. :)
Hi Shane - I see how you added a label on a blank form, but how do you add a label at the top of your new or edit form (i.e. I want to provide a short paragraph of instructions at the top of the customized list form. I can add the label but after an hour of trying I cannot see how to "push" the columns down. My label just overlaps the form columns. Please tell me there is an easy way. Thanks! Appreciate your videos
Excellent Video Shane. One basic question, can i reuse a custom form created on a list in one site in a similar list on another site instead of customizing the list from scratch?
Shane - Your videos are SUPER Helpful, thank you for the time you put in! I have a question I am hoping you can direct me to a solution. I created a power app form from scratch. Now that I have the form functioning the way I created a sharepoint list and liked it. The problem I have is that the SharePOint list does not have all the columns that the form is capturing. How do I set up the app to powerapp to populate the sharepoint list columns? Do I need to now build out the sharepoint list to match the Powerapp, and how do I tell the PowerApp what data goes in what column? TIA for any help or resources you can point me to!
@@ShanesCows Thanks for the tip - I have went ahead and added all the columns to my sharepoint list. I then refreshed the list in my power app. The newly added columns did not show up! Do you have a video about how to "Patch to them".
@@bradleygriese5375 if you click on the form and then click Fields you can add them to your form. If you still want to use Patch then check out this video ruclips.net/video/gX5q_V3U8-s/видео.html
Hi Shane, thanks for the great form. Sheet building beautiful and working forms, I have up because I couldn't find a solution for double scroll bars. When I open the SharePoint form in a full screen, there are two scrollbar shown, one of the screen and another of form. Changing the size of form is making the entire form scattered. Can you advise of a solution? I would be really thankful.
Hi Shane, great videos! I have a question about the forms. I created a custom form using powerapps fine and all the functionality is correct. However, if a user was to use the sharepoint mobile app to browse to the list the add new item form on that mobile app does not grab the powerapp form. Do you know where the settings to point the mobile sharepoint app to the powerapp form would be?
Closest thing I have is SharePoint Lookup column video I kind of show this. You cannot have one form write to two lists without a lot of custom cards. Possible but not easy.
Thanks for showing the tip for reverting back to the default sharepoint edit screen. I followed your steps and it worked great. Now, however, I want to go back to using the sharepoint form I created. I reversed the steps, selecting "Use custom form created in PowerApps." However, whenever I try to edit an item on my sharepoint list, the default edit screen appears instead of my custom form. I have tried opening and closing my browsers, using the default list again, and nothing works to show my form. Any ideas on what happened here?
Hey Shane, This is a good content! i know it has been 2 years but it helped me a lot. My question is if the employee left the company and he is the owner of this. Will the app deleted? How can i co-share this with my team?
Hi! Your videos are really helpful and clear. Thanks for creating valuable content! :) Quick question, when I click on one of my items, I get the options to edit but there is no option to customize, so I'm unable to launch my form in Powerapps. Is there an alternative way of doing this? Will appreciate your input TIA
@@ShanesCows On my sharepoint interface, I have to click on a dropdown on edit form and then an option to customize with power Apps shows up. Another question, right at the beginning of the video you shared your app, where does it get saved? I saved my app but didn't publish it, it's not showing up in my apps.
Hi Shane, is there a way to create a Form that has a default the current user? I included into the DefaultSelctedItem of the combobox the code "Ofice365Users.MyProfile()" this shows the user contact by default but does not submit when I submit the form. Any solution?
Very helpful and great video. I have one question; when I put the formula under Button, I couldn't find the link property. Could you help with that please? Thank you.
I have been following your channel for a while and learned a lot. Thnak you. Is there way to add customised form to a sharepoint page? I have several forms created in infopath and need to move to powerapps. Could you also do a video on validation, sections and layout design. Keep up the good work.
Hi Shane, love your videos. Quick question: Have you ever found a way to open the PowerApp modal window from a custom web page within SharePoint?, I mean not directly from the "Edit" button on the list, but in a web part page with a custom button? (I was able to open the custom SharePoint list form in the SP.ModalDialog, but, of course, that modal doesn`t give you the toolbar at the top (with Save and Cancel buttons), so, even if I can add those buttons to the app directly, obviously I`m not able to close the SP.ModalDialog from the app itself, so that`s why I`m looking for a way to use the default modal. Any thoughts? Thanks in advance.
Thank you Shane for the video....Do you know how to get the check boxes from SharePoint to show up like multi-choice check boxes and not a drop-down in Powerapps?
Just found your channel, the video helped a lot. I also watched your video on making the form look more like InfoPath. When customizing a SharePoint list, how do you make the list pop out bigger? I would like the New, Edit & Display to be the hole screen like InfoPath does. We have forms that are filled out and then printed most of the time with Logo’s addresses… Thanks keep it up.
Hi Shane. Once you have created a Custom SharePoint List Form with PowerApps can you then create a connection to an SQL Azure table to use in a ComboBox on that SharePoint form? Do you have a RUclips video for this?
@@ShanesCows Thanks for your reply. Refining my question because I have completed some more research, I worked out how to add an SQL Azure connection to the PowerApp but this will mean my client will need Premium Powerapp licenses. I would like to create a SharePoint External List which connects to SQL Azure which requires the creation of External Content Types within SharePoint Online. I have researched how to do this for the past two weeks. Where I come unstuck is when Microsoft documents tell me to now use Sharepoint Designer 2013 to connect to my SharePoint Online site to create External Content Types. I can not find a way to connect Sharepoint Designer 2013 or 2010 to SharePoint Online or any other ways to create External Content Types. I know this is not a PowerApps question, but you're my last hope.
Great video! Thx alot! But I have a huge problem: My listform is white and empty. Even when I simply change the background color of my form. After saving and publishing the "New Entry" form is white and empty. Any clue for that?
@@ShanesCows By default it is this: If(IsBlank(SharePointIntegration.Selected) || IsEmpty(SharePointIntegration.Selected);First([@MyTestlist]);SharePointIntegration.Selected)
Is there a way to make the form a part of a different sharepoint page? For example. I have a list of different products. There is a sharepoint page for each product type (the list has several products of each product type). I would like the form for populating the list to appear as a part of each product type page, so that a user can go to a product type page and add a product to the main list without having to go to the product list.
Hi Shane ! I LOVE your Videos, they really make my moving from Infopath to PowerApps to fun and easy but still there are some issues that I miss like the Easy designing (few controls at once) and aligning, guess I'll have to get use to that.. In my organization I need to create forms in hebrew (RTL alignment) but I can't find a way to right align text inside drop down control.. I hope you can help me that.. 10X :)
Is it possible to create a series of forms for a site list on SharePoint? Ex. Within a site list there would be multiple steps, meaning multiple form edits, but all need to be within the site list. Step 1. Info Fill In Step 2. Review and Edit Step 3. Next person reviews and approves Step 4. Review and Edit Step 5. Approve and Review Final Entries Step 6. Indivdual Approves and Marks Form as Closed
Shane, thanks for this great work. Do you have any ideas as to why my Sharepoint list forms customized in PowerApps are appearing all blank when I publish them back to Sharepoint as well as in Preview mode in PowerApps?
Is there any way to mix regular labels or controls in with controls/cards for a SharePoint form? You alluded to a warning concerning this around 13:30 so I'm thinking maybe not. But for example, add a text box that provides explanatory text (more than what you would include in a tooltip) alongside or beneath a data entry control.
hey Shane i love your videos and you have thought me a lot is there any chance you could do a video that will show how we would look up other colleagues on office 365 so we can send them the form ?
Hi, Great tutorial video. I would like to ask if there is a way to edit the list by opening the app instead of editing using the "pop up"? Thank you very much
@@ShanesCows Hi Shane, I am wondering if I build an app instead of using customize form because I don't like the "pop up", is there a way for users still connect the form from the SharePoint list?
Hi, I have read that PowerApps has delegation limit with SharePoint List in the case where Standalone App are build. But can you explain what are the limitations of using PowerApps Form in SharePoint rather than custom SharePoint.? Thanks
Hi Shane, This video is awesome! I am having trouble scrolling down to the other fields in my list when I try to add by clicking "new." It only will allow me to go down if I use the down arrow or tab key. I don't want other users to miss any of the fields. Any suggestions?
Thanks, Shane for your prompt response! I actually figured it out and thought I deleted this comment. But I also thought I added my newest concern which is that I am receiving an error message when I try to save my "test" entry. The error is "There was a problem saving your changes. The data source may be invalid." Any idea what I am doing wrong here?
Can you customize SP List Forms based on List Views? As in, have different New/Edit list item forms depending on the view you're currently using in the List?
I have a customized Powerapps form. I want to know if I can connect the new button of a list to a preexisting form or I would have to start from scratch?
@@ShanesCows Hi Shane - thank you so much for your videos. They are great - learning a lot every time I watch them. I have the same question as Madhavi. I would be great if it is possible. Thanks - best regards Hasse
Hello Shane, I have one question please. I did a custom sharepoint list form in power apps, and I have some data cards imported from another sharepoint list, based on column that is found in both sharepoint lists, let's call it the connector. Based on the connector, I have different label data cards (I mean data cards that only show information) from the imported sharepoint list. The things work fine if I'm using Edit or View form, though when I'm New Form, after selecting something (choice data card) the label data cards who populate from connector don't update in real time. They update only after submitting the form. Is there a way to update them on real time ?
Look at your connected data. Are you possible referencing the field value for the lookup instead of the control? In that case the field would be blank for new items but not for existing.
Hi. Nice vid. My Sharepoint list when i click on an item, transfers me to a non form view. I do not get the form popping out from the right like your does in 1:51 of the vid. How do i solve this?
Hey Shane, thanks for the great videos. Question about PowerApps security management. For users to use the form they need to PowerApps license with that they also get the ability to customize the form or create new apps. We are using PowerApps for O365 license which comes with the default environment and does not give the option to manage security for environments. Is there any way to give users 'Can use' permission?
You can give a user the permissions to only use the app. In SharePoint take away their ability to customize the list and they cannot customize the form.
Hi Shane, your videos are very helpful for me. Just one question; how can I create different types of form for multiple views of a single list? Thanks..
Great videos! I am trying to create a powerapp form for a task list created by a SP 2013 Workflow. I don't get the same behavior as with a standard SP list ie the edit screen on the right side. Is there something special about task lists created from a SP 2013 WF and powerapps?
Shane - I am sure so much has changed since this video - I have created the form and the new form is fine. When I click on the title of one of the records, it is having a hissy fit - sometimes, it tries to go into edit mode and then hangs up on "Getting Data" or, it opens to the new form and I have to click the Edit all Button. Please Help!
Toni nothing has really changed from this video. Little things but it should all work. I wonder if SharePoint is just having a bad day? Or have you tried doing it with another list to see if the problem follows.
Hello, First thanks for this video! I have created a customized form with PowerApp for my sharepoint list. It all works well except for the dates! I cannot delete/blank a date from the powerapp app form, are you able to blank a date ?
hi Shane, How to submit a new record(new row of record in sharepoint list)every time on click sumbit button from powerapps form? I am using submitform function and it is like editing previous first record of sharepoint list.
Thanks for your video,Shane.Just a question, about the hire date field in your video, when you apply the custom form, it looks a little different from the originial one. Is there a way to make it display as before while applying the custom form?
Hi Shane! I am trying to find a way to increase file attachment size so people can attach a 1gb video file to the form that is a PowerApps form feeding a SharePoint List. Is that even possible? Currently, what we have is a text field where they share a link to a shared file on their OneDrive folder...
hey, Shane i want to create student registration list in sharepoint list for new enrollment. can you please help in your video how to create the list with different categories e.g. students details, parents details, subject choice etc..
How can we create responsive Forms using Power APPS? I mean when user open the Form in Desktop at that time they can view Desktop form and while they access the form from mobile, they can view mobile layout?
I have 2 tabs for Sharepoint: main page and another one with powerapp AskAndShare where people can ask questions. To the main page I wanted to add 2 last questions from AskAndShare, so people can in easy way see if something was updated, without switching the screens. I managed to add it, however it is showing all questions that have been asked, not only 2 last ones. Is there some easy fix for it?
Hello Shane, How i can link a new field in my form to a column on my list? I see your video about the cascading downdrop and i would like to link my new field with a column in my list. How can i perform this? Thanks a lot for your answer
Sharepoint lets you navigate away from a form without saving it and it does not warn the user. Is there anyway to autosave on every change or warn the user they are exiting without saving changes?
Got a question: when using the Sharepoint Integration and you change the background fill for the form it doesn't fill the bottom of the browser screen. I know we can go in and adjust the overall length of the page in settings, but is there a more dynamic way? One which allows for when people have different browser sizes? Thank you :)
Hi Shane! I was wondering if there is a way to add a quantity field next to a checkbox so if someone selects the item, they can add how many they would want. Thanks
Hello. Thank you for the video. I have created a Calender with a list in SharePoint 2013. Now I need to customize the form to create new element on the calender. I am not able to find a way to customize the list items with PowerApps if they are items of a calender. I can find the PowerApp option only if the items are part of a simple list. Do you have any advice? Thank you :)
I made a new version of this video in February 2022. Same content, just 4 years newer!
ruclips.net/video/2J9h8dqQlg8/видео.html
YOU ARE THE MVP. I was in tutorial hell and SHANE YOU ARE THE FIRST ONE THAT CLICKED FOR ME! either that, or my coffee is stronger than steel this morning. Im going to go with the former.
I will be watching a whole lot more. I am one of those people that needs to get wheels spinning from watching small examples here and there.
Glad that it helped. Don't drink too much of that coffee, you may never sleep. 😂
@@ShanesCows I do have a question though. So can I have a button that says add, much like a job application does with your work history experience, that adds the same columns over again for the user to fill out? I have form where they may need to identify several people responsible for a project. They'd need to add each person's name and email, but the number of people may vary. Does that make sense?
I seriously LOVE YOU for making these vids. I have 3 different large scale projects at work, all of which I need to create PowerApps for data intake... I have absolutely no background in this so your content will be a lifesaver.
Good luck Ashley 😻
whenever i see your video, i know i am gonna learn many new thing in an easy and fun way. Thanks for all the information you share. Keep up the good work !
Glad to hear that!
I HAVE to mention this....I wanted to hid something on a form. I was on the right path but was thinking to hard at it. SO...when I need an answer I go to Shane because who doesn't right? I jumped to just what I needed. Thank you again for making these videos. They are fantastic resources and you are always great to listen to! Have a great 2020!!
Thanks Kory and Happy New Year to you
Shane... you are amazing... your videos are amazing... i really learn a lot from them... wow!!! keep up the fantastic work
Thanks 😊
I feel the touch of God when i see your vidoes Shane. You 120% deserve your MVP sign. Respect.
Thank you Frank. 😊
i love this guy. give this man a raise
Thanks Jake. 🐶
Thank you thank you!!!! I was running into the cache of cache thing!! It was making me mental, I could not figure out why my latest version was not showing!!! Your versioning label is a great idea, kudos!
Glad it helped
Hi Shane, I've watched a few of your vids now and they are all awesome. Thank you for the time and detail you put into them.
Happy to help my lord. 😄
Shane, your videos are invaluable! Thank you for recording them and demonstrating real-life scenarios in a simple to follow way with practical tips.
Happy to help 😀
Shane, just a quick thank you. Most helpful. Your quick videos are alway on topic and full of lots of tips and trick that get me thinking. Thanks and keep up with the “awesome” work. You can tell Todd that he needs to up his game now ;-)
😂 thanks. That Todd guy needs to get it together. 😂
You're the real MVP Shane.
Thanks
Thank you Shane, the video is what I needed right now... Priceless info about power apps..!!
I am glad i came across your channel in the right time..
Glad to help. 😀
I love how you say it: “boo InfoPath!”
Keep up the good work! I always love your videos!
Thanks and 👻 to InfoPath 😉
@@ShanesCows this is just infopath in the cloud has same GUI and annoying form design behavior
@@ShanesCows ¹
So many cool tips and tricks right here. Thanks for the great video. Subscribed! I can’t wait to go through the rest of your vids!
Almost 100 so enjoy. 😎
Bro you're a damn angel. Most helpful powerapps information I have come across.
Glad it helped. 😀
Am I an angel?
Great video, For a beginner like me it helped a lot and saved ample time.
Glad to help. 😀
Thanks for all of your videos, they really help! I still have questions though. How do you print this form?
Did you see this video on printing? ruclips.net/video/JMhVtII5hQs/видео.html
@@ShanesCows I did, and I used the video to and it works in preview but it does not work from the sharepoint list. When I looked at other resources, they say that the print function has a known limitation with sharepoint custom forms
Could not find the next video on this topic you announced at the end of your awesome video
I never did go any further on this topic on RUclips. 😐 Boo me. I did cover tabs here though ruclips.net/video/if_mFIfi5PM/видео.html
when he threw the cash in the air and said "wooooooo" . I felt that
🤑 Sometimes I get too excited.
Thanks Shane, looking forward to the next video in the series.
Glad you liked it. I need to get back to work. 😀
Thank you for this. Very helpful.
You are so welcome!
Ahhh Sharepoint Integration thing. Exactly what I was missing. Thanks!
They tried to hide it. 😁
Hi Shane, all of your videos are great. I'm looking for a video with combo box on how to update items moving from one screen to another. I'm using 2nd screen where I add items in the library and when I go back to the combo box the items are not updated. Is any related video?
Thanks
Michael
I don't think I have a video with that. Maybe save the value in a Variable?
@@ShanesCows Thanks for the reply.
I have finally managed it. The combo box source is updating using on the first screen's OnVisible property and typing Refresh(firstscreensource).
Absolutely love using the screens for documentation. If I had a nickle for every time I wished for documentation! LOL
Me too, me too.
Hi Shane, great video. Where this app is saved, into Sharepoint? If you open PowerApps I think it doesn't show in Apps list.
SharePoint owns the app and you cannot access it outside of this interface. It is only a custom form for SharePoint
These are fantastic trainings. Thank you so much!
Happy to help
Your videos are awesome and exactly what I needed!
Thanks for sharing. :) Hope they are easier to find than Big Foot.
Shane Young LOL!
Hi Shane, been loving your vids all day and learning lots!! I need to create a form that the user will submit which is then submitted to an admin team that will then need to complete a different form. Both forms will write to the same SP list. It so sounds possible but just unsure of how it will work.. (Form is to log a call with a maintenance team, flow will send notification to the team, once the team has completed they will then update the item to say complete and other items)
Look at the deep linking video for an idea of how to send an email that has a link.
Man, you are the best!
Thanks 😁
Thanks, it is very helpful. I am facing a problem, the (link) property does not pop up after I SharepointIntegration.selected. ? What should I do in this case? I tried copying the syntax you have shown but it does not work. has sharepoint changed something and link is called something else now?
Thanks
I just opened an app and this still works for me? SharePointIntegration.Selected.'{Link}'
Hey Shane, I don't know if this has been asked already but is there a way to backup the PowerApps List Form to be used as a template on multiple lists and on multiple sites, etc? I don't want to have to create the same design template over and over again so I thought I'd ask before I do that. Thanks.
I don’t think there is. This is a stellar question
I can't understand why there is a demonstration to email people when there isn't even a button to save the data which one would think is absolutely essential. It looks like there's videos specifically catered to saving however, and your material is always amazing so I should stop grumbling.
The save button in this scenario comes from the SharePoint Integration. You don't need on in your app. You set the OnSave property and that is how it is controlled. :)
Hi Shane..Your videos are always helpful!
Can you suggest, Is it okay to use power app for customizing SharePoint forms if I have just taken trial of power app for 1 month for form customization, later I wont be able to update any changes in that form if required, as trial version will end. We are not going to buy power app license .Also after using power app & going back to Default form it is also rolling back all the formatting done tooltip etc.
Hi Shane! Thanks for your series, I saw all of them by now and its a LOT of info.. I have a 'nice to have' suggestion: Could you edit your description texts so that they include a sort of content table, preferably by function and/or best practice tips? I sometimes spend an hour just trying to find what you said about something because I just know I heard you say it at some point somewhere.. :)
That is fair. I need to do it better.
Great video, is there a way to make the form wider or change it to landscape?
I haven’t tried. Will have to look tomorrow if the settings for size work. I doubt it though.
I think you can go to File > App Settings and adjust the screen sie and Oritentation from there.
Great educational value!
Great Work. You have amazing teaching skills. What software you use to screen record , edit the videos before upload to RUclips :) thanks a lot.
Can’t Asia from TechSmith. Love it!
Thank you man, this video helped me a lot !!!!
Glad it helped!
Hi Shane - I see how you added a label on a blank form, but how do you add a label at the top of your new or edit form (i.e. I want to provide a short paragraph of instructions at the top of the customized list form. I can add the label but after an hour of trying I cannot see how to "push" the columns down. My label just overlaps the form columns. Please tell me there is an easy way. Thanks! Appreciate your videos
Add a custom card first. Then put the label in the custom card. I think I show it here. ruclips.net/video/5vVFgaEBYuM/видео.html
Excellent Video Shane. One basic question, can i reuse a custom form created on a list in one site in a similar list on another site instead of customizing the list from scratch?
Nope, sorry
Nice work. Can we have these forms accessed by anonymous viewers? if so, where would the settings be for that?
No, Power Apps have to be authenticated and licensed
Shane - Your videos are SUPER Helpful, thank you for the time you put in! I have a question I am hoping you can direct me to a solution. I created a power app form from scratch. Now that I have the form functioning the way I created a sharepoint list and liked it. The problem I have is that the SharePOint list does not have all the columns that the form is capturing. How do I set up the app to powerapp to populate the sharepoint list columns? Do I need to now build out the sharepoint list to match the Powerapp, and how do I tell the PowerApp what data goes in what column? TIA for any help or resources you can point me to!
Start by adding the columns to the SharePoint list. Then your form can have all those fields. Or you can use Patch to do it.
@@ShanesCows Thanks for the tip - I have went ahead and added all the columns to my sharepoint list. I then refreshed the list in my power app. The newly added columns did not show up! Do you have a video about how to "Patch to them".
@@bradleygriese5375 if you click on the form and then click Fields you can add them to your form. If you still want to use Patch then check out this video ruclips.net/video/gX5q_V3U8-s/видео.html
Hi Shane, thanks for the great form. Sheet building beautiful and working forms, I have up because I couldn't find a solution for double scroll bars. When I open the SharePoint form in a full screen, there are two scrollbar shown, one of the screen and another of form. Changing the size of form is making the entire form scattered. Can you advise of a solution? I would be really thankful.
Not sure, sorry.
Nice One. @
Shane Young - Do you have any tutorial for "PCF - Reading SharePoint List" ? Thanks
Hi Shane, great videos! I have a question about the forms. I created a custom form using powerapps fine and all the functionality is correct. However, if a user was to use the sharepoint mobile app to browse to the list the add new item form on that mobile app does not grab the powerapp form. Do you know where the settings to point the mobile sharepoint app to the powerapp form would be?
I haven’t encountered that before. Great question 😑
Hi Shane, thanks for the video, are you able to do video for combine multiple SharePoint lists into one form ??
Thanks
Sunny
Closest thing I have is SharePoint Lookup column video I kind of show this. You cannot have one form write to two lists without a lot of custom cards. Possible but not easy.
Thanks Shane
Thanks for showing the tip for reverting back to the default sharepoint edit screen. I followed your steps and it worked great. Now, however, I want to go back to using the sharepoint form I created. I reversed the steps, selecting "Use custom form created in PowerApps." However, whenever I try to edit an item on my sharepoint list, the default edit screen appears instead of my custom form. I have tried opening and closing my browsers, using the default list again, and nothing works to show my form. Any ideas on what happened here?
Hey Shane, This is a good content! i know it has been 2 years but it helped me a lot. My question is if the employee left the company and he is the owner of this. Will the app deleted? How can i co-share this with my team?
The form is actually owned by SharePoint. So it isn’t leaving you so you are safe.
@@ShanesCows thanks man!
G’day Shane, you mention that the users need to have a PowerApps license. Which license - a ‘P1 license’? Thanks, and great show. Rob
The free license that comes with O365 should work.
Hi! Your videos are really helpful and clear. Thanks for creating valuable content! :) Quick question, when I click on one of my items, I get the options to edit but there is no option to customize, so I'm unable to launch my form in Powerapps. Is there an alternative way of doing this? Will appreciate your input TIA
There is not. Is your list maybe not a modem list?
Shane Young i think it is, as I have the powerapp option at the top
@@ShanesCows On my sharepoint interface, I have to click on a dropdown on edit form and then an option to customize with power Apps shows up. Another question, right at the beginning of the video you shared your app, where does it get saved? I saved my app but didn't publish it, it's not showing up in my apps.
This was SOOO helpful. thank you! Is there a way to branch fields?
Thanks. You could branch fields by showing and hiding them (visible property) based on other values
Hi Shane, is there a way to create a Form that has a default the current user? I included into the DefaultSelctedItem of the combobox the code "Ofice365Users.MyProfile()" this shows the user contact by default but does not submit when I submit the form. Any solution?
Not sure. What is your items property and what type of column are you sending it to?
Very helpful and great video. I have one question; when I put the formula under Button, I couldn't find the link property. Could you help with that please?
Thank you.
Did you use the SharePoint integrated object? If so then not sure why you wouldn’t see it.
I have been following your channel for a while and learned a lot. Thnak you. Is there way to add customised form to a sharepoint page? I have several forms created in infopath and need to move to powerapps. Could you also do a video on validation, sections and layout design. Keep up the good work.
Start with this video. ruclips.net/video/5vVFgaEBYuM/видео.html there are a bunch of others that help also.
Hi Shane, love your videos. Quick question: Have you ever found a way to open the PowerApp modal window from a custom web page within SharePoint?, I mean not directly from the "Edit" button on the list, but in a web part page with a custom button? (I was able to open the custom SharePoint list form in the SP.ModalDialog, but, of course, that modal doesn`t give you the toolbar at the top (with Save and Cancel buttons), so, even if I can add those buttons to the app directly, obviously I`m not able to close the SP.ModalDialog from the app itself, so that`s why I`m looking for a way to use the default modal. Any thoughts? Thanks in advance.
Yikes. Sorry I haven’t done that
Thank you Shane for the video....Do you know how to get the check boxes from SharePoint to show up like multi-choice check boxes and not a drop-down in Powerapps?
You would have to manually create it. 😐
Just found your channel, the video helped a lot. I also watched your video on making the form look more like InfoPath. When customizing a SharePoint list, how do you make the list pop out bigger? I would like the New, Edit & Display to be the hole screen like InfoPath does. We have forms that are filled out and then printed most of the time with Logo’s addresses… Thanks keep it up.
Click app settings and you can change the size
Hi Shane. Once you have created a Custom SharePoint List Form with PowerApps can you then create a connection to an SQL Azure table to use in a ComboBox on that SharePoint form? Do you have a RUclips video for this?
Stephen I am pretty sure I show that in this old video. ruclips.net/video/fqH1U0_TanI/видео.html :)
@@ShanesCows Thanks for your reply. Refining my question because I have completed some more research, I worked out how to add an SQL Azure connection to the PowerApp but this will mean my client will need Premium Powerapp licenses. I would like to create a SharePoint External List which connects to SQL Azure which requires the creation of External Content Types within SharePoint Online. I have researched how to do this for the past two weeks. Where I come unstuck is when Microsoft documents tell me to now use Sharepoint Designer 2013 to connect to my SharePoint Online site to create External Content Types. I can not find a way to connect Sharepoint Designer 2013 or 2010 to SharePoint Online or any other ways to create External Content Types. I know this is not a PowerApps question, but you're my last hope.
Great video! Thx alot! But I have a huge problem: My listform is white and empty. Even when I simply change the background color of my form. After saving and publishing the "New Entry" form is white and empty. Any clue for that?
Check the item property of the form to make sure you have a record specified.
@@ShanesCows By default it is this: If(IsBlank(SharePointIntegration.Selected) || IsEmpty(SharePointIntegration.Selected);First([@MyTestlist]);SharePointIntegration.Selected)
Is there a way to make the form a part of a different sharepoint page? For example. I have a list of different products. There is a sharepoint page for each product type (the list has several products of each product type). I would like the form for populating the list to appear as a part of each product type page, so that a user can go to a product type page and add a product to the main list without having to go to the product list.
Easier to make a stand-alone app and then embed it on the home page of the site
Hi Shane ! I LOVE your Videos, they really make my moving from Infopath to PowerApps to fun and easy but still there are some issues that I miss like the Easy designing (few controls at once) and aligning, guess I'll have to get use to that.. In my organization I need to create forms in hebrew (RTL alignment) but I can't find a way to right align text inside drop down control.. I hope you can help me that.. 10X :)
Hey Rachel - I don't know how to make a dropdown align right. 😐
Is it possible to create a series of forms for a site list on SharePoint?
Ex. Within a site list there would be multiple steps, meaning multiple form edits, but all need to be within the site list.
Step 1. Info Fill In
Step 2. Review and Edit
Step 3. Next person reviews and approves
Step 4. Review and Edit
Step 5. Approve and Review Final Entries
Step 6. Indivdual Approves and Marks Form as Closed
Yes that is possible. Each form needs to have the same item property and display the fields you want them editing.
Shane, thanks for this great work.
Do you have any ideas as to why my Sharepoint list forms customized in PowerApps are appearing all blank when I publish them back to Sharepoint as well as in Preview mode in PowerApps?
Check the Items property of the form and the form mode. One of those two is off causing your issue.
@@ShanesCows Thanks!
Great video again !!
Thanks
Is there any way to mix regular labels or controls in with controls/cards for a SharePoint form? You alluded to a warning concerning this around 13:30 so I'm thinking maybe not. But for example, add a text box that provides explanatory text (more than what you would include in a tooltip) alongside or beneath a data entry control.
Yes. You can throw a custom card on there and then just add a label with your info. No problem.
hey Shane i love your videos and you have thought me a lot is there any chance you could do a video that will show how we would look up other colleagues on office 365 so we can send them the form ?
Nice, thank you some tips for Custom SharePoint List for newbie like me.
Glad it helped. 😻
Hi,
Great tutorial video.
I would like to ask if there is a way to edit the list by opening the app instead of editing using the "pop up"?
Thank you very much
Yes. Build an app and use your SharePoint list as the data source. ruclips.net/video/BnYe_7fpZRM/видео.html
@@ShanesCows Hi Shane, I am wondering if I build an app instead of using customize form because I don't like the "pop up", is there a way for users still connect the form from the SharePoint list?
Hi,
I have read that PowerApps has delegation limit with SharePoint List in the case where Standalone App are build. But can you explain what are the limitations of using PowerApps Form in SharePoint rather than custom SharePoint.?
Thanks
Did you see this video on Delegation for context? ruclips.net/video/UaBmVUQx_Fk/видео.html
Hi Shane,
This video is awesome! I am having trouble scrolling down to the other fields in my list when I try to add by clicking "new." It only will allow me to go down if I use the down arrow or tab key. I don't want other users to miss any of the fields. Any suggestions?
How about tabs instead of scrolling? ruclips.net/video/kWUvttbYpu4/видео.html
Thanks, Shane for your prompt response! I actually figured it out and thought I deleted this comment.
But I also thought I added my newest concern which is that I am receiving an error message when I try to save my "test" entry. The error is "There was a problem saving your changes. The data source may be invalid." Any idea what I am doing wrong here?
Hi Shane, How do resize data card from Sharepoint in PowerApp. Thanks
Thanks Shane, how you deal with Pictures, I can't even see that column on the customization.
Can you customize SP List Forms based on List Views? As in, have different New/Edit list item forms depending on the view you're currently using in the List?
I don't think that you can.
@@ShanesCows
I didn't think so either but figured it was worth an ask. Thanks for all your videos!
I have a customized Powerapps form. I want to know if I can connect the new button of a list to a preexisting form or I would have to start from scratch?
I replied to your email.
@@ShanesCows Hi Shane - thank you so much for your videos. They are great - learning a lot every time I watch them. I have the same question as Madhavi. I would be great if it is possible. Thanks - best regards Hasse
Hello Shane, I have one question please. I did a custom sharepoint list form in power apps, and I have some data cards imported from another sharepoint list, based on column that is found in both sharepoint lists, let's call it the connector. Based on the connector, I have different label data cards (I mean data cards that only show information) from the imported sharepoint list. The things work fine if I'm using Edit or View form, though when I'm New Form, after selecting something (choice data card) the label data cards who populate from connector don't update in real time. They update only after submitting the form. Is there a way to update them on real time ?
Look at your connected data. Are you possible referencing the field value for the lookup instead of the control? In that case the field would be blank for new items but not for existing.
Hi. Nice vid. My Sharepoint list when i click on an item, transfers me to a non form view. I do not get the form popping out from the right like your does in 1:51 of the vid. How do i solve this?
You are not using a modern SharePoint list.
Hey Shane, thanks for the great videos. Question about PowerApps security management. For users to use the form they need to PowerApps license with that they also get the ability to customize the form or create new apps. We are using PowerApps for O365 license which comes with the default environment and does not give the option to manage security for environments. Is there any way to give users 'Can use' permission?
You can give a user the permissions to only use the app. In SharePoint take away their ability to customize the list and they cannot customize the form.
Shane Young Awesome thanks for replying 😊
please can you point me to the first videos to start learning power apps with you on this channel?
Start here. PowerApps with a SharePoint List - Learn PowerApps ruclips.net/video/BnYe_7fpZRM/видео.html
Hi Shane, your videos are very helpful for me. Just one question; how can I create different types of form for multiple views of a single list? Thanks..
Try this video on PowerApps Form modes ruclips.net/video/BnzaSDYl8mA/видео.html
Great videos! I am trying to create a powerapp form for a task list created by a SP 2013 Workflow. I don't get the same behavior as with a standard SP list ie the edit screen on the right side. Is there something special about task lists created from a SP 2013 WF and powerapps?
Yeah. The list is to be a modern list and I think tasks are not.
Shane - I am sure so much has changed since this video - I have created the form and the new form is fine. When I click on the title of one of the records, it is having a hissy fit - sometimes, it tries to go into edit mode and then hangs up on "Getting Data" or, it opens to the new form and I have to click the Edit all Button. Please Help!
Toni nothing has really changed from this video. Little things but it should all work. I wonder if SharePoint is just having a bad day? Or have you tried doing it with another list to see if the problem follows.
Hello, First thanks for this video! I have created a customized form with PowerApp for my sharepoint list. It all works well except for the dates! I cannot delete/blank a date from the powerapp app form, are you able to blank a date ?
I still haven’t figured this out. 😑
Can I do this with the properties of a document set as well?
I have never tried. Sorry
Can I use a link to this power app form in a webpart? If so, how would I get the link to add to the webpart?
hi Shane, How to submit a new record(new row of record in sharepoint list)every time on click sumbit button from powerapps form?
I am using submitform function and it is like editing previous first record of sharepoint list.
i got it, i added new button and used newform function.
Glad you got it. 😀
Thanks for your video,Shane.Just a question, about the hire date field in your video, when you apply the custom form, it looks a little different from the originial one. Is there a way to make it display as before while applying the custom form?
Hi Shane! I am trying to find a way to increase file attachment size so people can attach a 1gb video file to the form that is a PowerApps form feeding a SharePoint List. Is that even possible? Currently, what we have is a text field where they share a link to a shared file on their OneDrive folder...
Nope. As far as I know 50 mb is the hard limit for files.
hey, Shane i want to create student registration list in sharepoint list for new enrollment. can you please help in your video how to create the list with different categories e.g. students details, parents details, subject choice etc..
This video should help. ruclips.net/video/MclJ_O9HvJQ/видео.html
How can we create responsive Forms using Power APPS? I mean when user open the Form in Desktop at that time they can view Desktop form and while they access the form from mobile, they can view mobile layout?
Not possible today. Sorry.
i'm kinda smiling here in office watching this video ahah
Awesome 😎
I have 2 tabs for Sharepoint: main page and another one with powerapp AskAndShare where people can ask questions. To the main page I wanted to add 2 last questions from AskAndShare, so people can in easy way see if something was updated, without switching the screens. I managed to add it, however it is showing all questions that have been asked, not only 2 last ones. Is there some easy fix for it?
Maybe this concept will help? ruclips.net/video/if_mFIfi5PM/видео.html
Hello Shane,
How i can link a new field in my form to a column on my list? I see your video about the cascading downdrop and i would like to link my new field with a column in my list.
How can i perform this?
Thanks a lot for your answer
Maybe this video will help? ruclips.net/video/fqH1U0_TanI/видео.html
Shane Young Unfortenaly no... i’m looking for the formuka in order to write in the xolumns on sharepoint when i click on save on the form
Sharepoint lets you navigate away from a form without saving it and it does not warn the user. Is there anyway to autosave on every change or warn the user they are exiting without saving changes?
You can build logic OnChange of the inputs but it gets a little complex. 😑
Got a question: when using the Sharepoint Integration and you change the background fill for the form it doesn't fill the bottom of the browser screen. I know we can go in and adjust the overall length of the page in settings, but is there a more dynamic way? One which allows for when people have different browser sizes? Thank you :)
Make it responsive ruclips.net/video/GrtzAqqDgN8/видео.html
Hi Shane!
I was wondering if there is a way to add a quantity field next to a checkbox so if someone selects the item, they can add how many they would want.
Thanks
Yes. Then have a button that saves (patch) the input of the two controls.
Thanks for another really nice video! By the way, would you know if there´s any way to use JavaScript code in this context?
Not possible. Sorry
Hello. Thank you for the video. I have created a Calender with a list in SharePoint 2013. Now I need to customize the form to create new element on the calender. I am not able to find a way to customize the list items with PowerApps if they are items of a calender. I can find the PowerApp option only if the items are part of a simple list. Do you have any advice? Thank you :)
Customize list forms only works on modern lists. I don’t think calendars are modern
@@ShanesCows Thank you for your answer. How would you do this? I mean, edit forms in sharepoint designer. Is infopath the only way?
Can approval flow reference an attachment that’s on SharePoint list when the flow is sent?
Yes, in your flow you should be able to retrieve the file from SharePoint with one of the actions.