I have been using InfoPath then Nintex to create SharePoint forms...but have really struggled to get to grips with PowerApps...for months! Until I saw your videos and now I am off and running. Thanks again for your easy to follow videos!
I know this is an older video, but it has been SUPER Helpful. PowerApps forms seem much more difficult to use than InfoPath. A simple drag and drop of a field is ridiculously hard. I'm used to easily out of the box grabbing a field and moving it without hardly any effort. BUT...I am a new comer to this. Lots of people are used to and desire forms that look similar to most forms throughout applications and websites. PowerApps forms don't appear to be designed with type of concept in mind.
I'm just beginning to work with PowerApp Forms -- thank you for the suggestion of using the SETTINGS page. Great idea that I will be implementing. Thank you Shane. Keep these videos coming.
Thanks a lot Shane, you are helping a lot to understand the underneath functionality of PowerApps. It really helps to create cool interfaces for normal users and users with different tasks in a company!!!! Very helpful and those funny comments makes the videos nicer!!!! A big hug bro
Excellent videos, Shane! Please do a video on repeating tables in PowerApps (similar to those in InfoPath). Interested to see how to do those in PowerApps with SharePoint as a data source.
It is on the list. There is one little issue that I haven't perfected. There are other examples on the internet already if you need it sooner than I get my issue resolved.
First comment would be THANKS!!! I have blasted through many of your vids, and they are excellent - As a newbie to all this, I have learned TONS from them - so thanks! Ok, 2 questions. 1. You see how you have a notes field right beside the yes/no fields - do they have to be the same height? What if you wanted to put 3 yes/no fields above each other right beside the notes field? 2. Is there a way to select multiple fields and change them all at once - like select all the fields and change text size or colour or width/height?p Oh, and the custom field trick = brilliant!!!!
Glad they are helping 1. I haven't tried that with a form and I don't have a quick way to test. I feel like the answer is no but not 100%. If you just added the controls yourself you should be able to create that. Honestly, I rarely use forms. I like to just setup all the controls myself. I am weird. 2. More bad news. Nope. The only thing you consider try is to make them a group (it is on the Home tab) and then there are a few settings, like Visible you can set on the group. Honestly, I haven't found a lot of great ways to work with fonts and such app wide.
Yes, repeating tables would be VERY helpful. I have a pretty complex InfoPath form which uses a SharePoint Form Library, and a number of repeating tables. If you could do a video on those, that would be extremely helpful.
I hope soon that they will update where the Text Boxes can accept rich text format instead of just multiline, single, password. I know they are working on it. Also, I love the tip about a screen for documentation
Also, I rewatched this Vid because I was am working on a contract form. I realized you used "FillKawasakiGreen.color", just an extra tidbit I found throughout all of my app builds I have been lately. On the settings screen for theme properties, you can also do the same for a background fill, text, font & size of named style. You simple change all of the properties on the names Style, then the dot word to either fill, font, size, etc., etc.. This way you only need to change the property you want to change on the setting screen and it cascades throughout the whole app for all of the style settings.
Hi Shane! Thanks a lot for your very useful videos! It helps a lot! I got a quick question if i may.. Is there a way to add multiple datacards in a single "section" and then hide only that "section" instead of having to hide each individual datacards one by one ? Like we can do with infopath section actually. thanks !
Awesome vid. Would love to see some solutions for repeating tables, and for filtered drop down selections. For example, a drop down that is a lookup column that displays all the items from that list whos status = X.
Shane, first of all, great videos. I'm having to learn PowerApps in the scope of a week and your videos have been insanely helpful. Something I'm having an issue with that's been really frustrating is choosing which fields appear on my form. In your videos, you just click on the form properties, go to the layout and either check or uncheck boxes for the fields that you want. That would be great, but my PowerApps doesn't do that. I'm sure it's something that has changed, but do you have any recommendations if there's a way to get that back, or do I just have to use the ellipse to remove each one?
Just brilliant. Can you demonstrate conditional display (i.e. if gender = female then show field for 'maiden name') and the equivalent of Excel VlookUp (select item in list 1 => list 2 is updated/filtered). Thanks
Hello Shane, Thankyou for your videos. Really helpful. I am trying to make a infopath like request form for a work request. I want to have the user be able to add multiple part requests by clicking add more option within the same form. Is there any video where you have demonstrated these capabilities? Its the same fields like part name, part number, part format etc., but just populated multiple times as user click "add more" for multiple part requests inside one single form. Please provide any guidance or references. Thanks.
Hi Shane, I'm really enjoying your videos. I'm new to PowerApps and have learned a lot from them. Although I can't find a video around creating tabs in a form if you have a lot of fields for the user to fill out. Is that something that you've created? Thanks in advance
Excellent work, thank you very much Shane! Is it possible to have 2 fragments of the form in 2 different parts of the screen that are related and stored them in the same line of the database? I ask this because I would like to make more dynamic the fields that the user must completel as the application progresses
Hi Shane, great video. I've been trying to find how to group datacards together to apply visibility or other forms of logic. My use case is I have 3 main options within the same form, and depending on the choice, I want to display group of fields A B or C. While I write this I now realize maybe the use case is better for using multiple screens. But anyway, I was wondering why it was so difficult to move a data card onto a container (actually looks like it's not possible so I will try to implement this another way). Many thanks for the great content
Hi Shane, really helpful videos thanks. Is there one on for example hiding a data card based on an adjacent data cards selection of a yes or no in a drop-down list? I can't seem to find one on YT.
I don't have exactly that. This video on doing Tabs shows the concept of setting the visible property in a form dynamically, which is what you want to do. ruclips.net/video/if_mFIfi5PM/видео.html In the video I show using variables, you will have it based on tglControl.Value = true or the likes.
No components exist in their own bubble that can't see inside a specific app. You would need ot use Input and Output properties to pass data between the app and the component.
Hi Shane, your videos are really fantastic. Do you have any videos on how to create Accordians? i.e. when a user selects "Yes" the field options for this section or area displays.
No video. I would try to apply some of the concepts in this video though. PowerApps flyout menus, floating buttons, and X Y Controls ruclips.net/video/D_Kb7AXSE0s/видео.html
Hi Shane, excellent video! Thanks for sharing. I would like to know is there is a way to customize the sub section to allow it to expand and collapse all the items below
Hi Shane, could you share the blog link to advanced/complicated way of validate with data connection property /ID group, mentioned at 12:40? For example, I want a form to be editable by its owner or certain role.
I have just watched this and it's great. I have learnt a lot from your video's, however one thing happened when I was trying to set the displaymode for only specific people to edit, when the statement was false (only view) the entire dropdown box disappeared and I can't figure out why or how to fix so that it view the details.
Hi Shane, Absolutely great videos. How would you use 'branch' if you were to create a form like above using 'breadcrumbs' with one home screen and depending on the choice you make, it branches you to two sub-home pages. Say you have multiple pages and the user branches off depending on what selection choice they make, but then they want to come back to the sub-home screen of that branch? I've tried 'if' statements, 'navigate'.... but without success. Hope the above makes sense and would welcome your feedback. Thanks
Thanks sir for this very useful videos, but i have question sometimes we have some variable need to update into the list while clicked submit button(some additional column value which is not showing in the form or according to the condition we changed some value) so how we can do this?. for example we have approver form where we have Approve and Reject button, in the click of both buttons, we want to change the status field value either Approve or Reject, THANKS IN ADVANCE
Hi Shane, Is it possible to set the Height of a Form DataCardValue (and parent DataCard.Height) dependent on the number of rows of text within DataCardValue? So the text box adjusts to the rows of text within it automatically and scrolling with multi line is not required? The same way a cell in Excel adjusts its height to its contents with Wrap text turned on. Keep up the good work ;)
Shane One thing I am having trouble with on transitioning my InfoPath forms over to powerapps is rules that kick off actions that fill out other fields. Example: I have 2 fields one is a drop menu for the status of the item (New, work in progress, Complete) Then I have a Date completed field. I have a rule that runs on click of the save button, If Status = Complete then Date completed = today. I have the date completed field hidden on the form. This acts like a time stamp for when these items are completed.
Hi Daniel - I had to learn something new for this. :) You want to use the Switch function. Set the Text property for Date Completed field to something like this. Switch(Dropdown1.Selected.Value,"1","One","2","Two","3","Three") Now, if I pick 1 in the dropdown the words in the Date Completed field would be One. I think that is enough to get you close.
Thanks Shant. You are adding more values to emergin market users. Question: you put submit button in the form. But couldn't catch where those form data goes. Can I transfer submitted data of form to sharepoint or onedrive excel table?
Question for you Shane, related to putting that color field into display mode.....how can Active Directory groups be used to test user access to fields or functionality? That’s probably a whole topic unto itself, so maybe you’ve already done a video about it?
Best I know there isn't a way to print a PowerApps. One of my customers he selects the text on the screen and prints from Chrome. Another customer creates a screen print and prints that out. What are you thinking about?
Hi Shane, thanks for quick response! I am customizing SharePoint list form which needs to be printed. I do see option to print from web browser though it brings buttons and other unwanted elements in print view. Do you know if there is an ETA on print feature provided by powerapps?
Loving all these videos about power apps. Question I'm trying to find an elegant answer too: What about branded backgrounds? I have a branded background, to a screen, and I have fields riding over it. (Datacardvalues) I've set the opacity low so that you can still see the background when scrolling but would like a way to have the opacity set more solid when that field has focus, especially for fields that have drop downs, or multiple choices. Can you help?
Hello Shane. Thank you for all your videos! They are extremely helpful 🤗. I have a question: I’m building an app in tablet landscape format for calculating ROI, so I have a screen with the Edit Form, but I’m having a lot o problems trying to arrange the data cards. See, I have 3 groups of data that need to be registered (all belonging to one table source), so the logical thing to do would be to have 3 columns of cards, but I need to group them vertically, and by default, every time I add a card, they get added from left to right, top to bottom. Inserting a card just to separate the data cards in this case won’t be helpful, since you can’t push all the cards to one side or the other, just up or down. Do you have an idea how I could solve this? I would really appreciate your help!! Thanks 😊
Hi, Shane, Great videos!! Thanks a lot. is there a way to set the font and font size in my apps so that i do not have to change every field and label? I would also like to change the size of the actual data card. And, do you have a video yet on repeating tables?
Thank Ruth - Sadly you have found one of the challenges at the moment. No global font changes. I am pretty sure templates/theme type settings are coming sooner than later. Repeating tables. I haven't done a video yet. Do you have an example of a form with one that you could send me? I would love to have the right example to build a video around. shane at PowerApps911.com That has been part of the problem getting started.
Hi - great video thanks. I'm keen to know how to set the permissions based on SharePoint permissions, rather than email. Specifically I have a group of Quality Owners, any of which might complete the restricted fields. In my situation, we have a site shared with external customers. I want them to fill in most of the form, but only our Quality team to fill in the approval fields. I thought I would combine this with the Tabbed Form approach to simplify the external user's experience.
Thanks for the video Shane. It's been very helpful. I really look forward to your videos. I am working on a project at the moment. looking for a solution. I need some help. I have a list in SharePoint with the names of employees and some information of the employee. In my PowerApps I have an app that allows you to Add a new employee and edit an existing employee (which I 've successfully been able to do with the help of your video). Here's where I need help: When the user clicks on Edit instead of updating the existing record, I want to be able to create a copy of the record , allow the user to make the change and when the user hits save, the updated record adds another row to SharePoint list with a new version number.
Interesting. I follow but haven’t thought about it before. First idea would be to have a button that did a patch instead of submit form. Have that button take the fields from the form and use them to patch a new record. Interesting
Hi Shane, I have in mind to make an app for audit. What im doing now is printing paper, going to she shop floor and making 5S audit, to check that workplace is set in order and clean. On the paper I have 25 questions, and the answer is rating (1-5 stars). Could you please make quick overview (video) how to make it, i`ll appreciate that. By the way, you making very useful videos! Thanks for Sharing! =)
Yes, i do have other requirement) i want to make it with Action Items and attached photo. For example when i do walk around (making an audit), if some areas are not compliance, i want to make an Action Item (free text, what should be done) to corresponding person and attach photo of that area. By the way, Thanks for reply =)
Good day Shane. Is it possible to make a button/field visable to users that are part of a distribution group instead of specific user by email address?
@@ShanesCows I've watched so many of your videos and they've helped me so much that if I hadn't stumbled upon you, I would still be stuck on the idea instead of a working app. Thank you!
Great video! One question... how do I open the form directly in edit mode, skipping the part where I need to click on the edit button to edit the form?
Can you do the same with a library using say parent folders that has its own content type and then child metadata associated with a document upload to the folder?
@@ShanesCows Thats the dilemma I am having. I am able to create a folder by way of a Power Automate action linking Power Apps. From a timer function in Power Apps I call the Power Automate action using CreateSPFolderButton.Run(DataCardValue13.Text) but I am only able to create the folder using DataCardValue13, which is the Title field. That particular function expects only one argument so I am not able to add any associated metadata fields associated with the folder. The user can go into the folder properties and update them after the folder is created but that seems to me to be very inefficient.
Hi Shane, could You explore the subject of customizing Sharepoint forms in PowerApps (not creating PowerApps for Sharepoint)? Specially how to create forms similar to new Sharepoint design, handle multi-line fields, lookups, MMS fields, multi tab forms :) Would really appreciate.
To be honest i came here thinking we'd be customizing the SharePoint From, this solution is great and all but no one is going to do this, especially "Power Users" who are the intended recipient of this this. I personally enjoyed it but thats mainly because i enjoy this type of work. However this solution is tedious for normal users.
once you create your power app form. how do you tie it back to SharePoint list. Normally you can create power app from sharepoint and just publish but, seems like feature isn't there when you save.
When you add a form you need to connect it to a datasource like SharePoint before you start customizing it. If you did individual controls then you will need to Patch those controls back to SharePoint. Look for my video called Save Data for An example of thet
Hi Shane. I am very new to app building and I am finding your videos so helpful with lots of "aha" moments :) I am working on a client sign-in app, which is coming together nicely. Is there a way that we can get the app to remember information that has been entered before i.e. if a client has signed-in before, then the next time they sign-in, the info (company name and phone number) will auto-generate when they enter their name.
Hi Shane, This is Great.. Can you please tell us how we can edit the all gallery tabs .. right you have configured only one ..so as i configured only one ..haha
Hi Shane your videos have been EXTREMELY helpful. I do have a request, I have to build a form and I'm not interested in InfoPath. Is there an easy way to build a custom form for SharePoint where users can complete the form for a specific request? I will also need to create a FLOW for it so I'm hoping you might be able to help me build a form that works sort of like InfoPath but is not InfoPath if that makes sense. Thank you!
Hi Jason - Glad they help. :) I 100% agree you should not be doing things in InfoPath. :) I am not sure I follow exactly what you are looking for though. I think this video is what you are asking for but maybe not. Do you have pictures of an existing form or things you have tried that are not working? Maybe it would be easier to just email me? Happy to help or point you in the right direction. shane.young at boldzebras.com
Great Video!! I have a question: I'm building forms for SharePoint lists which will be the same across 3 or 4 sites, with just the drop down choices in the form being different. Is there any way to copy the whole form from a list in one site to another, and then simply change the drop down options.?? If so this would save me so much time!
The only thing that comes to mind Dan is you can use Ctrl + C and Ctrl + V to copy controls from one screen to the other. You could try doing a save as on the app and seeing if you could trick things. I haven't tried so not sure. Let me know what you come up with.
Thanks Shane. Its a tricky one. Looks like the answer is to have one full app, instead of just PowerApps customized forms. You can right click and copy / paste in the left hand panel which make things a lot faster. Together with your label color tips, its speeding things up. Cheers
Hi, Shane: Is it possible to lock the certain field based on Approval process workflow value. Example disable birthday in edit mode, if workflow approval status is Approved Hope you will guide me..
Like InfoPath the form will be displayed in the SharePoint itself (when you click new), are this will display the same or we have to open powerapp application to view the form?
Hi Shane,I am stuck as I'm trying to list shared (generic) mailboxes in a field but it seems only users are possible to list as they are active. Shared Mailbox objects have isabled accounts by default. have you met thins and did you get around it??Cheers
My one question would be, once you have finished creating the Blank PowerApp form, how would I publish this form to a SharePoint Online List and make that form the default?
Hi Shane, great video and thank you for sharing! I found your video to be very helpful in my transition from InfoPath to PowerApps. I followed your video and was wondering if there is a way to create a screen based on the ItemDetails screen that defaults to all fields being blank? My test form is currently synced to an existing SP List with some dummy data. Ideally, I was looking to have 2 screens. One screen for new submissions and a second for reviewing existing submissions. Any help that you can provide is appreciated. Thanks again!
I have a problem when adding the subsection headers, I follow your instrutions but when i update something on the SharePoint list and refresh the data of the connection of the form, it changes the size of the header back to half part of the column, is there a trick to avoid this from happening? Thanks!
@@ShanesCows Thanks, once i can that barcode and some number pops up. Is it possible to use that number as a trigger to pull all data associated with that number from SQL?
Great video Shane, You covered almost every question i have asked for. One thing i would like to know though how do we load different forms based on a field like Status?. is it possible to increase the height of the form created using tablet layout?
When you say "is it possible to increase the height of the form created using tablet layout?" do you mean to say screen? and yes you can use an If statement based on Status to make different forms Visible. :) So put the two forms on top of each other and only make one visible based on the value of Status.
yes i have a very big form with around 18 field to fill, i was wondering if it's possible to increase the default form size . I will try as advised with regards to loading different forms. is there a form load event where i can try use the if statement.
i think it is already scrollable by default, as i was adding up more field the scrollbar automatically appears. Just wondering is there a way in powerapps to add more than one attachment?. i know sharepoint list only allows one attachment. There are some cases this is required.or any alternative technique to achieve this?
This was excellent Shane and what I needed to know, do you have an email address to contact you about other design tricks, thank you for making it so easy ☺️
I am Asking Parent Child Form, in this form child list is on repeating section, when i submit form repeating section data store on child list dynamically ?
Hi Jonathan. There are a bunch of angles to go after this from. Rough code coming: The easiest would be to set the fields displaymode to edit if the user().email = one of the managers emails. Not the most elegant but the frame work of a solution for sure. Hope that helps.
Hi, I am a newbie when it comes to PowerApps... is there a way to auto populate some fields based on the value on one of the fields. For example, if I type the employee number in the Employee Number Field, the Name Field and the Department Field will automatically populate - information will be coming from another SharePoint Site. In InfoPath, I can do this but in PowerApps, I am a bit confused. Hope someone can provide some help or assistance...
Tito you can. You can set the default value of your other fields to either use a variable that you set or a LookUp based onyour other functions. Not sure I have a great video on this. Probably should. 😑
@@ShanesCows thanks man, your videos are very helpful... I have no background with PowerApps and our company suddenly stopped using InfoPath in designing forms... I have some projects or tools that I need to develop to pull the data from one sharepoint list then save them in another list... I am going through your videos... Very helpful, just getting used to the terminologies and the "syntax" or commands used in PowerApps...
Shane, thanks for your videos, the tool/form that i am working on is now perfectly working... Looking forward watching all of your videos... Now i feel more confident working with PowerApps because of your tutorials... You rock!!!!
Your videos are life. thanks! I had a tab in my edit form. I want to enable that tab for multiple people in a particular field of the current item being edited. Is it possible? Please help if possible.
Hello, I have several email users account use my powerapp, I want to set a screen view for one exactly email user and different views for each user that i want. How can i do that, can i set conditional, fomular visible.... Hope your respone soon
@@ShanesCows Thanks, I added in the Advanced tab for my "submit" button, for Action- OnSelect, I put- SubmitForm(Form1)&ResetForm(Form1). This seems to work.
![Megan Thee Stallion - Neva Play (feat. RM) [Official Video]](http://i.ytimg.com/vi/TpYTyAaTRts/mqdefault.jpg)
I have been using InfoPath then Nintex to create SharePoint forms...but have really struggled to get to grips with PowerApps...for months! Until I saw your videos and now I am off and running. Thanks again for your easy to follow videos!
That is awesome Michael. Thanks for sharing 😀
I know this is an older video, but it has been SUPER Helpful. PowerApps forms seem much more difficult to use than InfoPath. A simple drag and drop of a field is ridiculously hard. I'm used to easily out of the box grabbing a field and moving it without hardly any effort. BUT...I am a new comer to this.
Lots of people are used to and desire forms that look similar to most forms throughout applications and websites. PowerApps forms don't appear to be designed with type of concept in mind.
I'm just beginning to work with PowerApp Forms -- thank you for the suggestion of using the SETTINGS page. Great idea that I will be implementing. Thank you Shane. Keep these videos coming.
Glad to help. 😀
Hey Shane, I was trying to figure out to move data cards, adding custom data cards is a works a dream! Thanks so much yet again 😊
Happy to help!
Thank you, saved me a lot of time. Specially I was having a hard time getting that section in middle of edit form. Big THANK YOU!!!
Great to hear!
Thanks a lot Shane, you are helping a lot to understand the underneath functionality of PowerApps. It really helps to create cool interfaces for normal users and users with different tasks in a company!!!! Very helpful and those funny comments makes the videos nicer!!!! A big hug bro
Thank you for the comment. I am glad it is helping you.
I learnt so much from this session. Thank you very much.
Glad it was helpful!
Excellent videos, Shane! Please do a video on repeating tables in PowerApps (similar to those in InfoPath). Interested to see how to do those in PowerApps with SharePoint as a data source.
It is on the list. There is one little issue that I haven't perfected. There are other examples on the internet already if you need it sooner than I get my issue resolved.
First comment would be THANKS!!! I have blasted through many of your vids, and they are excellent - As a newbie to all this, I have learned TONS from them - so thanks!
Ok, 2 questions. 1. You see how you have a notes field right beside the yes/no fields - do they have to be the same height? What if you wanted to put 3 yes/no fields above each other right beside the notes field?
2. Is there a way to select multiple fields and change them all at once - like select all the fields and change text size or colour or width/height?p
Oh, and the custom field trick = brilliant!!!!
Glad they are helping
1. I haven't tried that with a form and I don't have a quick way to test. I feel like the answer is no but not 100%. If you just added the controls yourself you should be able to create that. Honestly, I rarely use forms. I like to just setup all the controls myself. I am weird.
2. More bad news. Nope. The only thing you consider try is to make them a group (it is on the Home tab) and then there are a few settings, like Visible you can set on the group. Honestly, I haven't found a lot of great ways to work with fonts and such app wide.
Excellent videos ,Shane ! please do a video on adding javascript related stuff in powerApps
Not possible. Sorry
This is such a helpful video to get started in Power Apps. Thank you!
Glad it was helpful!
Awesome! This has been really helpful. A great video on learning PowerApps.. Thank you!
You're very welcome!
Yes, repeating tables would be VERY helpful. I have a pretty complex InfoPath form which uses a SharePoint Form Library, and a number of repeating tables. If you could do a video on those, that would be extremely helpful.
Check out the video called repeating tables like InfoPath ruclips.net/video/xgznk4XlPCo/видео.html
This tips shared are so helpful. Thank you Shane.
Happy to help.
Extremely useful video! Thanks!
😀
I hope soon that they will update where the Text Boxes can accept rich text format instead of just multiline, single, password. I know they are working on it. Also, I love the tip about a screen for documentation
FYI, Adobe color also has the hex values, and with this you can even build a theme of colors based on a picture you like.
Good to know. Thanks
Also, I rewatched this Vid because I was am working on a contract form. I realized you used "FillKawasakiGreen.color", just an extra tidbit I found throughout all of my app builds I have been lately. On the settings screen for theme properties, you can also do the same for a background fill, text, font & size of named style. You simple change all of the properties on the names Style, then the dot word to either fill, font, size, etc., etc.. This way you only need to change the property you want to change on the setting screen and it cascades throughout the whole app for all of the style settings.
Hi Shane! Thanks a lot for your very useful videos! It helps a lot! I got a quick question if i may.. Is there a way to add multiple datacards in a single "section" and then hide only that "section" instead of having to hide each individual datacards one by one ? Like we can do with infopath section actually. thanks !
love you, love custom card.
Thanks so much!
Awesome vid. Would love to see some solutions for repeating tables, and for filtered drop down selections. For example, a drop down that is a lookup column that displays all the items from that list whos status = X.
Try this for repeating tables ruclips.net/video/xgznk4XlPCo/видео.html
Thanks Shane, this is really good.
Awesome. Glad it helped.
Extremely helpful. Happy new year Shane.
Thank you and happy new year to you.
Fantastic!!!!!!!!!!!! :)
Thanks
Shane, first of all, great videos. I'm having to learn PowerApps in the scope of a week and your videos have been insanely helpful.
Something I'm having an issue with that's been really frustrating is choosing which fields appear on my form. In your videos, you just click on the form properties, go to the layout and either check or uncheck boxes for the fields that you want. That would be great, but my PowerApps doesn't do that. I'm sure it's something that has changed, but do you have any recommendations if there's a way to get that back, or do I just have to use the ellipse to remove each one?
THe form control is a tad different but should be very similar. Clicking edit fields lets you add or delete fields.
Multiline for the win.
😎
Just brilliant. Can you demonstrate conditional display (i.e. if gender = female then show field for 'maiden name') and the equivalent of Excel VlookUp (select item in list 1 => list 2 is updated/filtered). Thanks
This video should help ruclips.net/video/s85i8UWw2QM/видео.html
Fantastic video! Made my day so much easier :)
Awesome!
Great video. Thank you.
You are welcome. 😀
Hello Shane, Thankyou for your videos. Really helpful. I am trying to make a infopath like request form for a work request. I want to have the user be able to add multiple part requests by clicking add more option within the same form. Is there any video where you have demonstrated these capabilities? Its the same fields like part name, part number, part format etc., but just populated multiple times as user click "add more" for multiple part requests inside one single form. Please provide any guidance or references. Thanks.
Hi Shane,
I'm really enjoying your videos. I'm new to PowerApps and have learned a lot from them. Although I can't find a video around creating tabs in a form if you have a lot of fields for the user to fill out. Is that something that you've created?
Thanks in advance
Jimmy you were 100% correct. So I made this video because you left this comment. :)
PowerApps Tabbed Forms ruclips.net/video/if_mFIfi5PM/видео.html
Excellent work, thank you very much Shane!
Is it possible to have 2 fragments of the form in 2 different parts of the screen that are related and stored them in the same line of the database?
I ask this because I would like to make more dynamic the fields that the user must completel as the application progresses
How about this idea of tabs ruclips.net/video/if_mFIfi5PM/видео.html
Hi Shane, great video. I've been trying to find how to group datacards together to apply visibility or other forms of logic.
My use case is I have 3 main options within the same form, and depending on the choice, I want to display group of fields A B or C.
While I write this I now realize maybe the use case is better for using multiple screens. But anyway, I was wondering why it was so difficult to move a data card onto a container (actually looks like it's not possible so I will try to implement this another way). Many thanks for the great content
Excellent Video! very helpful. Thank you :)
Glad to help. 😻
You are amazing. Thank you
You are welcome. Glad it helped. :)
Hi Shane, really helpful videos thanks. Is there one on for example hiding a data card based on an adjacent data cards selection of a yes or no in a drop-down list? I can't seem to find one on YT.
I don't have exactly that. This video on doing Tabs shows the concept of setting the visible property in a form dynamically, which is what you want to do. ruclips.net/video/if_mFIfi5PM/видео.html In the video I show using variables, you will have it based on tglControl.Value = true or the likes.
@@ShanesCows Thanks fo rthe quick repsonse and help Shane 👌
Hi Shane, great video, thank you! The Settings page is really useful.... but is it possible to reference the colors in components?
No components exist in their own bubble that can't see inside a specific app. You would need ot use Input and Output properties to pass data between the app and the component.
Hi Shane, your videos are really fantastic. Do you have any videos on how to create Accordians? i.e. when a user selects "Yes" the field options for this section or area displays.
No video. I would try to apply some of the concepts in this video though. PowerApps flyout menus, floating buttons, and X Y Controls ruclips.net/video/D_Kb7AXSE0s/видео.html
1000 x thanks. Just what I needed
Cool! Thanks for sharing. Getting rid of InfoPath makes me happy. :)
Hi Shane, excellent video! Thanks for sharing. I would like to know is there is a way to customize the sub section to allow it to expand and collapse all the items below
Not that I know of. Sorry
Hi Shane, could you share the blog link to advanced/complicated way of validate with data connection property /ID group, mentioned at 12:40? For example, I want a form to be editable by its owner or certain role.
Sorry I couldn’t find them again. Boo me. 😔
I have just watched this and it's great. I have learnt a lot from your video's, however one thing happened when I was trying to set the displaymode for only specific people to edit, when the statement was false (only view) the entire dropdown box disappeared and I can't figure out why or how to fix so that it view the details.
Display mode View makes a dropdown control look like a label only showing the selected value. There is no way in View to use it as a dropdown.
@@ShanesCows When I set the dropdown to View only the entire details are not visible, not even getting the selected value showing.
Hi Shane,
Absolutely great videos. How would you use 'branch' if you were to create a form like above using 'breadcrumbs' with one home screen and depending on the choice you make, it branches you to two sub-home pages. Say you have multiple pages and the user branches off depending on what selection choice they make, but then they want to come back to the sub-home screen of that branch? I've tried 'if' statements, 'navigate'.... but without success. Hope the above makes sense and would welcome your feedback. Thanks
If and navigate is correct. We do it a lot. What didn’t work?
Thanks sir for this very useful videos, but i have question sometimes we have some variable need to update into the list while clicked submit button(some additional column value which is not showing in the form or according to the condition we changed some value) so how we can do this?. for example we have approver form where we have Approve and Reject button, in the click of both buttons, we want to change the status field value either Approve or Reject, THANKS IN ADVANCE
Look for my video on patch
Hi Shane,
Is it possible to set the Height of a Form DataCardValue (and parent DataCard.Height) dependent on the number of rows of text within DataCardValue?
So the text box adjusts to the rows of text within it automatically and scrolling with multi line is not required? The same way a cell in Excel adjusts its height to its contents with Wrap text turned on.
Keep up the good work ;)
There is an auto height property for labels. Use that then build the rest based off the height of that label?
Shane One thing I am having trouble with on transitioning my InfoPath forms over to powerapps is rules that kick off actions that fill out other fields.
Example: I have 2 fields one is a drop menu for the status of the item (New, work in progress, Complete) Then I have a Date completed field.
I have a rule that runs on click of the save button, If Status = Complete then Date completed = today.
I have the date completed field hidden on the form. This acts like a time stamp for when these items are completed.
Hi Daniel - I had to learn something new for this. :) You want to use the Switch function. Set the Text property for Date Completed field to something like this. Switch(Dropdown1.Selected.Value,"1","One","2","Two","3","Three") Now, if I pick 1 in the dropdown the words in the Date Completed field would be One. I think that is enough to get you close.
Thanks Shant. You are adding more values to emergin market users. Question: you put submit button in the form. But couldn't catch where those form data goes. Can I transfer submitted data of form to sharepoint or onedrive excel table?
Question for you Shane, related to putting that color field into display mode.....how can Active Directory groups be used to test user access to fields or functionality? That’s probably a whole topic unto itself, so maybe you’ve already done a video about it?
I haven’t done it. Maybe this blog post will help. powerapps.microsoft.com/en-us/blog/implementing-role-based-permission/
Good video Shane! Very helpful. Are you planning to make a video on how to print a power apps form?
Best I know there isn't a way to print a PowerApps. One of my customers he selects the text on the screen and prints from Chrome. Another customer creates a screen print and prints that out. What are you thinking about?
Hi Shane, thanks for quick response!
I am customizing SharePoint list form which needs to be printed. I do see option to print from web browser though it brings buttons and other unwanted elements in print view.
Do you know if there is an ETA on print feature provided by powerapps?
I don't but I will ask around. :)
How do you layout the list in 3 colums like that ? Vertical or Horizontal layout just produces a single column list
Loving all these videos about power apps. Question I'm trying to find an elegant answer too: What about branded backgrounds? I have a branded background, to a screen, and I have fields riding over it. (Datacardvalues) I've set the opacity low so that you can still see the background when scrolling but would like a way to have the opacity set more solid when that field has focus, especially for fields that have drop downs, or multiple choices. Can you help?
Sorry. I haven’t done much with such fancy branding. Can you use and If in the opacity setting?
@@ShanesCows maybe? I was thinking the answer might lay with the fade function... Plus 20% rather than - 20.... Something like that maybe?
Worth a shot. I have done so little here. Love to hear what you figure out.
Hello Shane. Thank you for all your videos! They are extremely helpful 🤗. I have a question: I’m building an app in tablet landscape format for calculating ROI, so I have a screen with the Edit Form, but I’m having a lot o problems trying to arrange the data cards. See, I have 3 groups of data that need to be registered (all belonging to one table source), so the logical thing to do would be to have 3 columns of cards, but I need to group them vertically, and by default, every time I add a card, they get added from left to right, top to bottom. Inserting a card just to separate the data cards in this case won’t be helpful, since you can’t push all the cards to one side or the other, just up or down. Do you have an idea how I could solve this? I would really appreciate your help!! Thanks 😊
Just as I was reading what I just posted, I thought maybe I could just split the table into 3 separate tables... maybe I’ll give it a try 🤞🏻
You can also drag the data cards to different locations or I have a video on Tabs that would be another way to do it.
Hi, Shane, Great videos!! Thanks a lot. is there a way to set the font and font size in my apps so that i do not have to change every field and label? I would also like to change the size of the actual data card. And, do you have a video yet on repeating tables?
Thank Ruth - Sadly you have found one of the challenges at the moment. No global font changes. I am pretty sure templates/theme type settings are coming sooner than later.
Repeating tables. I haven't done a video yet. Do you have an example of a form with one that you could send me? I would love to have the right example to build a video around. shane at PowerApps911.com That has been part of the problem getting started.
Thanks, that is helpful. So SharePoint lists?
Hi. Good video. Is it possible to change the toggle to a yes or no option.Thank you
Yes. You can change the true text property to Yes and the same for the false text.
Hi - great video thanks. I'm keen to know how to set the permissions based on SharePoint permissions, rather than email. Specifically I have a group of Quality Owners, any of which might complete the restricted fields.
In my situation, we have a site shared with external customers. I want them to fill in most of the form, but only our Quality team to fill in the approval fields. I thought I would combine this with the Tabbed Form approach to simplify the external user's experience.
Thanks for the video Shane. It's been very helpful. I really look forward to your videos.
I am working on a project at the moment. looking for a solution. I need some help.
I have a list in SharePoint with the names of employees and some information of the employee. In my PowerApps I have an app that allows you to Add a new employee and edit an existing employee (which I 've successfully been able to do with the help of your video). Here's where I need help: When the user clicks on Edit instead of updating the existing record, I want to be able to create a copy of the record , allow the user to make the change and when the user hits save, the updated record adds another row to SharePoint list with a new version number.
Interesting. I follow but haven’t thought about it before. First idea would be to have a button that did a patch instead of submit form. Have that button take the fields from the form and use them to patch a new record. Interesting
I was unable to find the blog about doing field restriction based on AD groups as discussed at 12:39, are you able to provide any more info at all?
I have a video in mind but haven’t done it yet. Sorry
Hi Shane,
I have in mind to make an app for audit. What im doing now is printing paper, going to she shop floor and making 5S audit, to check that workplace is set in order and clean.
On the paper I have 25 questions, and the answer is rating (1-5 stars).
Could you please make quick overview (video) how to make it, i`ll appreciate that.
By the way, you making very useful videos! Thanks for Sharing! =)
Do you just want to recreate the piece of paper? That is straightforward. Do you have other requirements?
Yes, i do have other requirement) i want to make it with Action Items and attached photo. For example when i do walk around (making an audit), if some areas are not compliance, i want to make an Action Item (free text, what should be done) to corresponding person and attach photo of that area. By the way, Thanks for reply =)
Good day Shane. Is it possible to make a button/field visable to users that are part of a distribution group instead of specific user by email address?
Get some ideas from this video but yes, as long as you can get the list of people you can filter by it. ruclips.net/video/0MB-z9cyFCQ/видео.html
@@ShanesCows I've watched so many of your videos and they've helped me so much that if I hadn't stumbled upon you, I would still be stuck on the idea instead of a working app. Thank you!
Great video! One question... how do I open the form directly in edit mode, skipping the part where I need to click on the edit button to edit the form?
But the edit button formula on the button that navigated you to the screen.
@@ShanesCows Put? :^)
Can you do the same with a library using say parent folders that has its own content type and then child metadata associated with a document upload to the folder?
I am not sure Chris. 😐
@@ShanesCows Thats the dilemma I am having.
I am able to create a folder by way of a Power Automate action linking Power Apps.
From a timer function in Power Apps I call the Power Automate action using CreateSPFolderButton.Run(DataCardValue13.Text) but I am only able to create the folder using DataCardValue13, which is the Title field. That particular function expects only one argument so I am not able to add any associated metadata fields associated with the folder.
The user can go into the folder properties and update them after the folder is created but that seems to me to be very inefficient.
Hi Shane, could You explore the subject of customizing Sharepoint forms in PowerApps (not creating PowerApps for Sharepoint)? Specially how to create forms similar to new Sharepoint design, handle multi-line fields, lookups, MMS fields, multi tab forms :) Would really appreciate.
Great idea! Added to my list. Thank You.
To be honest i came here thinking we'd be customizing the SharePoint From, this solution is great and all but no one is going to do this, especially "Power Users" who are the intended recipient of this this. I personally enjoyed it but thats mainly because i enjoy this type of work. However this solution is tedious for normal users.
once you create your power app form. how do you tie it back to SharePoint list. Normally you can create power app from sharepoint and just publish but, seems like feature isn't there when you save.
When you add a form you need to connect it to a datasource like SharePoint before you start customizing it. If you did individual controls then you will need to Patch those controls back to SharePoint. Look for my video called Save Data for An example of thet
Hi Shane. I am very new to app building and I am finding your videos so helpful with lots of "aha" moments :) I am working on a client sign-in app, which is coming together nicely. Is there a way that we can get the app to remember information that has been entered before i.e. if a client has signed-in before, then the next time they sign-in, the info (company name and phone number) will auto-generate when they enter their name.
Hi Shane, This is Great.. Can you please tell us how we can edit the all gallery tabs .. right you have configured only one ..so as i configured only one ..haha
Look for my video on Tabs for some ideas
Hi Shane your videos have been EXTREMELY helpful. I do have a request, I have to build a form and I'm not interested in InfoPath. Is there an easy way to build a custom form for SharePoint where users can complete the form for a specific request? I will also need to create a FLOW for it so I'm hoping you might be able to help me build a form that works sort of like InfoPath but is not InfoPath if that makes sense. Thank you!
Hi Jason - Glad they help. :)
I 100% agree you should not be doing things in InfoPath. :)
I am not sure I follow exactly what you are looking for though. I think this video is what you are asking for but maybe not. Do you have pictures of an existing form or things you have tried that are not working? Maybe it would be easier to just email me? Happy to help or point you in the right direction. shane.young at boldzebras.com
Great video. Is there function to close power apps/browser after clicking on submit? I have knowledge of the Exit() but it doesn’t close the browser.
I have never had that requirement. I did some quick searches and I think the answer is no. If you find anything let me know.
Great Video!!
I have a question: I'm building forms for SharePoint lists which will be the same across 3 or 4 sites, with just the drop down choices in the form being different. Is there any way to copy the whole form from a list in one site to another, and then simply change the drop down options.?? If so this would save me so much time!
The only thing that comes to mind Dan is you can use Ctrl + C and Ctrl + V to copy controls from one screen to the other. You could try doing a save as on the app and seeing if you could trick things. I haven't tried so not sure. Let me know what you come up with.
Thanks Shane. Its a tricky one. Looks like the answer is to have one full app, instead of just PowerApps customized forms. You can right click and copy / paste in the left hand panel which make things a lot faster. Together with your label color tips, its speeding things up. Cheers
Hi, Shane: Is it possible to lock the certain field based on Approval process workflow value. Example disable birthday in edit mode, if workflow approval status is Approved
Hope you will guide me..
Yes. Try this video for that topic. PowerApps Conditional Formatting and Popups ruclips.net/video/IvapIsBbM-U/видео.html
Like InfoPath the form will be displayed in the SharePoint itself (when you click new), are this will display the same or we have to open powerapp application to view the form?
PowerApps lets you do either. This video will help. ruclips.net/video/Badj3_T8zAw/видео.html
Hi Shane,I am stuck as I'm trying to list shared (generic) mailboxes in a field but it seems only users are possible to list as they are active. Shared Mailbox objects have isabled accounts by default. have you met thins and did you get around it??Cheers
Hi Dan - I haven't tried this before. :( Could you maybe just hard code the addresses of the shared mailboxes as a work around?
Can we restrict the People picker to filter the users from a specific SP groups ?
I have never done SharePoint groups 😑 I don’t think so.
My one question would be, once you have finished creating the Blank PowerApp form, how would I publish this form to a SharePoint Online List and make that form the default?
Luke I think this is what you are looking for. ruclips.net/video/Badj3_T8zAw/видео.html
Hi Shane, great video and thank you for sharing!
I found your video to be very helpful in my transition from InfoPath to PowerApps. I followed your video and was wondering if there is a way to create a screen based on the ItemDetails screen that defaults to all fields being blank? My test form is currently synced to an existing SP List with some dummy data. Ideally, I was looking to have 2 screens. One screen for new submissions and a second for reviewing existing submissions. Any help that you can provide is appreciated. Thanks again!
Never mind, just found it. Set default mode of the Form to "NEW".
I have a problem when adding the subsection headers, I follow your instrutions but when i update something on the SharePoint list and refresh the data of the connection of the form, it changes the size of the header back to half part of the column, is there a trick to avoid this from happening?
Thanks!
I am not sure. I have not ran into that.
Hi
Is it possible to scan an existing bar code to populate the form?
Yes. I have videos on bar code scanning.
@@ShanesCows Thanks, once i can that barcode and some number pops up. Is it possible to use that number as a trigger to pull all data associated with that number from SQL?
Thank you. can we give group name in place of mail id for display mode property? if yes how?
Yea but it is trickier. Not sure If I show it in this video or not ruclips.net/video/0MB-z9cyFCQ/видео.html
Great video Shane, You covered almost every question i have asked for. One thing i would like to know though how do we load different forms based on a field like Status?. is it possible to increase the height of the form created using tablet layout?
When you say "is it possible to increase the height of the form created using tablet layout?" do you mean to say screen? and yes you can use an If statement based on Status to make different forms Visible. :) So put the two forms on top of each other and only make one visible based on the value of Status.
yes i have a very big form with around 18 field to fill, i was wondering if it's possible to increase the default form size . I will try as advised with regards to loading different forms. is there a form load event where i can try use the if statement.
What about just making it scrollable?
i think it is already scrollable by default, as i was adding up more field the scrollbar automatically appears.
Just wondering is there a way in powerapps to add more than one attachment?. i know sharepoint list only allows one attachment. There are some cases this is required.or any alternative technique to achieve this?
I don't have a quick answer to that one. Sorry.
This was excellent Shane and what I needed to know, do you have an email address to contact you about other design tricks, thank you for making it so easy ☺️
can you make video on repeating section in powerapps ??
Yes, it is on the list. It needs to be higher on the list. Thanks for the nudge.
I am Asking Parent Child Form, in this form child list is on repeating section, when i submit form repeating section data store on child list dynamically ?
How would you make a field editable by a group? Let's say any one of 15 managers could edit a specific field.
Hi Jonathan. There are a bunch of angles to go after this from. Rough code coming: The easiest would be to set the fields displaymode to edit if the user().email = one of the managers emails. Not the most elegant but the frame work of a solution for sure. Hope that helps.
A nested if statement with 14 ifs ? My concern is if I leave the company, no one else is going to know what to do.
Yeah, I get it. You could make the screen password protected? What is your data source?
Hi, I am a newbie when it comes to PowerApps... is there a way to auto populate some fields based on the value on one of the fields. For example, if I type the employee number in the Employee Number Field, the Name Field and the Department Field will automatically populate - information will be coming from another SharePoint Site. In InfoPath, I can do this but in PowerApps, I am a bit confused. Hope someone can provide some help or assistance...
Tito you can. You can set the default value of your other fields to either use a variable that you set or a LookUp based onyour other functions. Not sure I have a great video on this. Probably should. 😑
@@ShanesCows thanks man, your videos are very helpful... I have no background with PowerApps and our company suddenly stopped using InfoPath in designing forms... I have some projects or tools that I need to develop to pull the data from one sharepoint list then save them in another list... I am going through your videos... Very helpful, just getting used to the terminologies and the "syntax" or commands used in PowerApps...
Shane, thanks for your videos, the tool/form that i am working on is now perfectly working... Looking forward watching all of your videos... Now i feel more confident working with PowerApps because of your tutorials... You rock!!!!
Your videos are life. thanks! I had a tab in my edit form. I want to enable that tab for multiple people in a particular field of the current item being edited. Is it possible? Please help if possible.
I responded to the other comment.
Hello, I have several email users account use my powerapp, I want to set a screen view for one exactly email user and different views for each user that i want. How can i do that, can i set conditional, fomular visible.... Hope your respone soon
The next video I am going to post covers using the user() function which should help.
I try to add user().Email condition to navigate button, it worked, thank u
How to reset the form after submit?
In the OnSuccess property you can use ResetForm or ViewForm functions. 😎
@@ShanesCows Thanks, I added in the Advanced tab for my "submit" button, for Action- OnSelect, I put- SubmitForm(Form1)&ResetForm(Form1). This seems to work.
How would you get the code to post on SharePoint so that users can submit the form and then edit if needed
I don’t understand your question? Happy to help just not sure what you are asking? Are you still trying to connect to SharePoint from PowerApps?