Great video, thank you! As a quicker workaround for the "rectangle dilemma", I set my Button padding to be 0 at the top, which put the button text a bit higher up, then I could just have a single solid rectangle going all the way across all the buttons at the front.
@@ShanesCows , is the video for multi-screen forms available? Primarily running the App on a phone so the limited space makes the tab format not work well. Thank you for all you do! Great Videos!!!
Your videos are great!!! I'm just starting to move away from infopath and making myself learn powerapps and your videos have been so helpful! Thank you so much!
Thanks so much, Shane! This is great temporarily solution for what I'm looking for right now! But, I would LOVE to see the multi-screen version that you mentioned. Love your vids, I'm learning so much from you. :)
Great walkthrough! Heavy data models with more than 150-200 columns in the content type are not uncommon for big organizations and using multiple screens for model-driven apps is much more complicated. All users should pay special attention to the remark at 23:41 - watch out for those required fields!
Hi Shane, I am a fan of all your training modules. Your teaching style is amazing and instructions are clear and very easy to follow. So, thank you. Here is my question regarding the Tabbed design. I am creating an employee profile app where employees can fill out the form and insert their information. The data source/capture is a SharePoint List. I am following your instruction for creating a Tabbed Form. However, this app has two major requirements: 1) The employee skill sets (a multi-choice field) have nested Tabs meaning, the main skill Tabs include Software, Research, Fields, and Project management. These four branches of skills each have nested sub-skills. For example, Software includes at least 10 choices. Same patterns for Research, Fields, and Project Management. I have a problem assigning different skills to nested skills tabs. For example, I want to assign all employee's software skills to Software Tab and all his/her skills in research to the Research tab. How do I assign a software skill that is both under Skills (main tab) and under Software Skills (nested tab)?. The second requirement is if the employee selects "Ohters, please specify" option from each tab, then there should be an associated Free Text Box so they can insert text and then data be stored in SharePoint list. By the way, I did post this question in PowerApps community a while back and have yet to receive any guidance. I appreciate any guidance or reference. Thank you
You must be psychic, because I literally have 2 projects I'll be starting next week that will benefit from a tabbed UI. One note, though, on the way you made the "tab" buttons: there is an easier way. Buttons are one of the few (maybe only? wait, no...images have it too) objects in PowerApps that have a "radius" property. You can set the radius for each corner of the button separately, so just set "RadiusBottomLeft" and "RadiusBottomRight" to 0 and they'll be square.
One of my favourite videos...as it just worked, even for me. Wondering whether it is possible to add a Tab which says "All" so all fields are displayed. I'm thinking that this might make it easier to do a screen grab or Print().
Hi Shane! Did you make any Model driven power App video. I searched but couldn’t find. I am not a coder and so I thought that would be easier for me. Love your videos. Thank you.
Another wow! Like others who've commented here, I needed this RIGHT NOW. How did you know? And, like others, I would like to see the multi-screen version. I have some SharePoint lists with dozens of columns. I had trouble getting these few columns to line up properly on only three tabs, so I'm guessing I'd lose my mind trying to do the big list on one screen. And as Dan Quayle (remember him?) once said, "A mind is a terrible thing to lose."
Another great video Shane. I have been watching (and rewatching) lots of them. I would like to know if there is a video where you use data from several sharepoint lists and create a new record in another sharepoint list using that data. ie a customer DB, a bill of materials etc being used for a final output. It limits the ability for materials which are not available being allocated to a client job order or can allow for incremental information to be added to a contract. ie if we are going to concrete a carpark for a client, it will take 20 loads and 5 days we can collect the contract details, customer details from 1 or 2 sharepoint lists, then have a list of consumed items (ie load of concrete @ 8 yds, some labour items, other costs selected from another SP list ( to limit the options ), allocate amounts such as hour units of labour, then save these records to a new SP list. This list would grow each day by one or more rows, but each row has a common contract number or client number to allow for aggregating the data for billing later???
I think you are looking to build relationships? I cover those in several different videos but not this exact scenario. Maybe try this series to learn more about relationships th-cam.com/video/xgznk4XlPCo/w-d-xo.html
@@ShanesCows Thanks Shane. I'll have a look at the links. I used to do SQL stuff "back in the day" but I struggle to find the "flow version". Your video on CONCAT vs CONCATENATE for example was a real slap the forehead moment :-)
Hi Shane, As always, excellent video - really helpful! Is there any news from the PowerApps guys as to when they might have a better solution for laying out datacard's in a form? The solution you have demonstrated is exactly what I need and works really well apart from the layout issues mentioned in a few of the comments here. I think I may end up using multiple forms on the same page with only the datacards I want to show for each section and then making the form visible depending on the button clicked. Is there any reason you can think of why this wouldnt be a good idea?
Hi Shane! Thank you for one more amazing video 😊 I have a question regarding the forms. I have 7 user groups defined in my sharepoint and I already defined their permissions for a certain list in sharepoint. I created a power app where I have an edit form for that list. What I want to do now is make some fields editable by certain user groups and others only readable by other certain user groups. How can I do that?
You would need to apply the concept in this video to find out who is in the group or not. Then show only people are in the group. th-cam.com/video/rRnbe1CfQ30/w-d-xo.html
Hi Shane, very good video thank you. This is exactly what I needed for my sharepoint. Just one question, I have applied your tutorial for the 2 buttons that I have but when I open an item on my share point list, none of the button are selected and I have to click on one button two see the fields. Can we force the selection of a button on power app when we open a item on sharepoint?
Hi Shane, This video was hugely helpful to understand the basics of tabs in PowerApp Forms. I've created great Tabbed views that are working. However, I try to arrange the datacards in the form for each tab views and it's driving me crazy - when I get on tabbed form view correct the rest are screwed up. Any advice on how I can lock the items in the form for that tab view?
Hi Shane, As usual, great video and I'm learning so much everyday about PowerApps from you. I got this working, the only this is, my gallery is on one screen and multi tabs on another screen. How can I default the landing page of the multi tabs screen to one of the tabs? Please let me know, thank you!!!
Great video as always! :D A little feedback: It would be nice if you'd reference mentioned videos in the description (which is better on newer videos ;o) )
Hi Shane! Your videos are so informative! Love them. I'm currently working on a three tabbed form. I have a Reset Form icon and a Home icon. I'm having trouble programming the home button. My first tab and what's considered the Home screen is Employee Details. So I've tried NewForm(frmEmployeeDetails) for OnSelect of the Home button, but it's not working. I have also tried Navigate(frmEmployeeDetails). Any ideas? Thanks!
Hey Shane, I’ve been watching you’re tutorials for awhile now and I’ve been wondering on how you could scan a barcode that is multiple lines (PDF417, that code does work) and have each line in its own text label. Ex: you scan it and the first line goes in 1 label and the second goes in 2 label. Any idea on how you would do it?
I haven't tried. What I would recommend messing with is the Split function. It is what I used to split comma separated values, not sure but it may also work for you.
@@ShanesCows Can we change default scroll bar color, width in PowerApps? Gallery, SharePoint Forms all contain scroll bar with default theme. Can we customize that? Any help/ input on this topic ? Thank you
I am brand new to this and was waiting for the part when you showed how to make the first tab disabled upon load. My form is a sharepoint list form. I have 5 tabs. On my first tab, I altered the displaymode formula to make it disable when you create a new list item or open a list item. My first tab is named "Details". If(Or(varTab = "Contacts", varTab = "Attachments", varTab = "Comments", varTab = "History"), DisplayMode.Edit, DisplayMode.Disabled)
hi Shane, this is cool, thank you. Question: if I've got mandatory fields in the Form, and on submitting there is an error because mandatory fields were not populated, the User is taken to a created FailureScreen, can I list field names there that cause an error?
Karolina I think you would have to create logic to show them the field names. 😑 Try something like making a label that says you forget "Dog name" and set it to visible if IsBlank(inpDogName.Text)
I would be interesting in seeing the multi-screen version. I have a SharePoint list which is used to store data from multiple people/disciplines and i want them to have their own screen for their discipline.
Nice video Shane. One question... If I have required field validation enabled on a control which is on tab 2 and is empty but I am on tab 1 and I press submit, the validation will fail. But how the user will visually know about the required field validation of that contorl which is hidden in tab 2?
Fab video! I tried this once and it worked a treat, I'm now using it in a different app and I can't get the other 'tabs' to show their contents!! I've looked at the button OnSelect and DisplayMode and they are correct, then double checked the Visible setting for the field and -again- it all appears to be correct. The first tab works, and if I select another tab the first tabs fields disappear as they should... what on earth is going on?! Thanks for any help you can give :)
Hi! This video was very helpful. How do I get the "tabs" to work in View Mode also? At the moment the tabs are only working when I have the form in New or Edit mode. Thanks!
Shane, are you able to display a field on 2 different "tabs"? For example, I have a form that has a reason field. I have a 3 tabs, but users don't have to enter data on every tab if its not necessary. But I need the reason field to show if if they click tab 1 or tab 2. Is this possible?
Hey Shane, Can we build Survey Questionnaire based on Dabaverse tables. Means Questions and Answers will be load from tables or entities and Answers should be display as radio type and final data will be saved to Employee Survey table. and if you want to edit then they can change the Answers as well. Also, It will be show % out of 100 score.
Hi Shane, Thanks for another very helpful video! I am going to use the Tabs set up in conjunction with a Gallery of Machines. For each device in the Gallery, I want to map an assigned tab,:3-5 different machines per Canvas/Gallery In each tab will be a close up image of the machine I plan to use Tooltip for a lot of mouse over inf0. Additionally there will be one "Card" form with a collection of links to technical manuals and operating work instructions in the quality system "documentum" database So my question to you is........ Instead of having Thingies (too technical?) visible based upon DisplayMode I have made them visible according to the Global Variable assigned on clicking the button. Is this wrong or just different? To code for Visible for all the "Thingies" that I want to show up when Button A is Selected Button: OnSelect Set(View, "ButtonA") Thingy: Visible View = "ButtonA". Am I missing something as this seem simpler to code and would rather type less..and do less in general, especially if one can get the same results...LAZY I guess...
Shane, Thanks for the video, and the many others on PowerApps! Do you have any demos on how to utilize scrolling Screens and Fluid Grids? I'm interested in making a simple, but interactive, leaning module. Something that would take a user 3 to 5 minutes to complete that uses screen shots from web sites with overlaid buttons made to look like the clickable links on the site, so that I could interactively step a user through the demo. I think I've got most of how I want it to function worked out, and probably could do it using the tabbed form method you described here, but I"m super interested in using the scroll-able screen with fluid grids. - Its the option just to the right when you add a new screen, or if you look in the list of templates there is a PowerApps tutorial that uses what looks to be a complicated version of what I'm trying to do. - perhaps you could dumb it down and help your adoring public better understand the basics of how that method would work/look like.
The print button just prints what you see on the screen. So you probably have to make a view where everything is on the screen to get print to do what you want. But I have never tried.
you don't need to type in the enum's name before the value (talking about DisplayMode, FormMode and such) the "Disabled" one was actually in the dropdown
Hi Shane, Do you know when "Developing Business Applications with Microsoft PowerApps, CDS, and Flow" course on edX is going to be updated? I wanted to pursue verified certification. Unfortunately, the course is archived and not no longer active to get a certification. Regards, Gogi
This is really really helpful, but I am having the issue that unless you are on that tab, you wont see the fields. I would like to show the fields when they first go in
Hmmmm...This is great if your form is not long, but my app form is 2.5 screens long from SP. If I set the visible like this , then I have tons of spaces between the datacards. If you move the datacards that need to be visible for associated tab (to the top for instance), they move due to over lapping datacards from the remaining not visible tabs or the remaining datacards move to justify your command. What I have done to overcome this (and most likely the long way of a fix) I selected the number of columns to be 24. This allows all of the datacards to be on one screen without scrolling. I then added a rectangle for each section of my form and Set the varTab to each rectangle. I added the controls needed for the Tabbed section of the form. The controls are set to populate the text box of the datacard to update SharePoint upon saving. This method just covers the screen with a box to allow flexibility of the controls and getting rid of the overlapping of datacards.
@@ShanesCows I did not mention that alot of the functionality came from your X and Y fly out menus, I just did not use the timer and set the varTab to open the appropriate section. Thanks for the continuous learning experiences - I have learned so much from you and find all your information valuable at some phase or another. Also, my tabs are along the left side of the page instead of the top. I have 7 sections and the buttons just fit and look better.
Hey Shane, thanks for sharing such videos. I have one query wherein I need 'Edit Button' to appear once I select any item from the 'ListBox" and then by clicking on 'Edit Button' it would enable user to navigate to page where details can be edited. Thanks in advance
Thanks for the tips in the video Shane! Question, any considerations to using a context variable instead of setting global variable? Since here is one page, wouldn't affect it, but I imagine for the multi-page one would?
Oh boy, I have 99% set out what I achieved to do! I've got 5 lovely tabs across the top, and I've updated all the datacard visible properties to show them in the right tab... but I'm working in a PowerApps Form on a SharePoint list rather than an app, so there's no gallery. As a result, when I edit an item in the list, the form is blank until I click on the first tab. I'm thinking I need to update the DisplayMode there, but if nothing has been selected so far, there is no varTab set, so I'm not sure if I can reference it,? I tried If(varTab = "", DisplayModeEdit, If(varTab = "Info", DisplayMode.Disabled, DisplayMode.Edit)) but it wasn't a happy bunny. I would be so grateful if you could help me get this final 1% done!
Hi Shane . Thanks for the tutorial. How to fix my data that go to different row in the sharepoint list for different tabs. As example, tab info is one row and tab job is another row . How to fix thats ? Thank you
Hey Shane, this video has helped me in implementing tabs layout for my app. I have an app with both view screen and edit screen having 3 tabs each(same tab name but controlled with different set of variables on each screen). Everything worked fine until I tried to set variables to make users remain on same tab name when navigating between view and edit screen. Say, if a user selects tab B of view screen and navigates to edit screen, it should open tab B on edit screen. This functionality seemed working in app studio. But when opened through web link, no items were loading, and on relaunch of studio, I found incompatible type errors for the context variables set for controlling tabs(varTab). Any help regarding the fix would be much appreciated. Thanks, you are doing great job.
Hi Shane, thank you for your videos. They are very helpful. In regards to this method of a tabbed interface, is there a way to control who can see each tab? I'm building a SharePoint site feedback form. One tab would be for the user to submit their idea (they would only see that tab) and the other would be for those of us doing the backend work, assigning tasks to site owners, setting the priority level, updating the status, etc). We administrators would have access to both tabs. I'm pretty new to all of this so if there is a better way of doing this/switching between content types, can you let me know? I've seen your video on how to email a link from PowerApps. Maybe in this case, site administrators would just prefer to update a standard SharePoint list than toggle between tabs? Any advice on how you would handle it is appreciated. Thank you- Teresa
Teresa, you can validate the current user based on a list of users who are allowed to view certain areas. So it would be an iF statement. "If the current user is in this list then whatever is visable". Does that make sense?
Gerfervonbob thank you for the response. Where do I go to set app level permissions? If you know of a good tutorial link, please send it my way. Like I said, I’m new to this so I’m still trying to learn the basics. Thanks again!
great stuff Shane! I had created 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.
@@ShanesCows appreciate your response. I have a sharepoint list. I was creating an edit form. In the edit form, I had created 4 tabs and assigned different fields to them separately. I want to manage the access as per the current user. I have made a list of some users (managers) for editing who should have access to all the tabs. Managers enter persons email IDs in the people's field in the selected item. Whoever is available in that field must see 2 particular tabs. Is it possible?
Hi Shane, Thanks for the video but I'm having a bit of an issue. When I launch the app, the arrows will only show the items record if I save a new form. It's a very weird thing. Any idea what I've done wrong?
Shonda look at your form Mode. It should probably default to View. Also, make sure if the Item property of your form is a variable that you are setting that variable when you click the arrow.
@@ShanesCows the weirdest thing is that it works momentarily when I preview it, but when I publish it and run the app the form will not display the records of the gallery selection. The form is set to View and the Item property contains the galleryname.selelected. The OnSelect property of the arrow is set to a variable so that it reflects the data under the General Tab as shownn in the video. Thanks so much for responding!
Hi Shane can you make a demo on how to connect an External List to powerapps? I successfully created a external list (External Content Types) in SharePoint Designer that was connected to Windows Azure. I am frustrated with my work because their is no powerapps supported on the external list. Hope you can help. Thank you so much. God Bless and continue to make video tutorials on powerapps.
Hey Shane , thanks for your videos ! I got a question , i got a Sharepoint List which i connected with my Gallery in PowerApps. In my Sharepoint list i got different products with a column for the pictures. The pictures are on my OneDrive and in the sharepoint list is the link to each picture. On the PC you can see everything completely normal. On the app on the phone, the pictures are unfortunately not displayed. How could this be solved alternatively? Would be very glad if you could help me!
Hi Shane, I have fully developed mobile application which I need to convert it to a tablet applications (tablet layout). Is this conversion of Mobile app to tablet app or vice versa possible?
Hi How do I make the users go to the tab by default depending on the status column of the form. At the moment a user is having to select Part A, Part B, Etc, if there a way for the app to default the users to the tab rather than having to select them?
@@ShanesCows Hi, thanks for the response. Apologies, I'm new to PowerApps, I've set the variable on the OnSelect property of the button, I get that, but what property do I set it to to set the variable when the form loads? I've tried various properties on the form and the screen and none seem to work. Any help is really appreciated.
@@ShanesCows No, that doesn't seem to work. I read somewhere else to use the ClearCollect function on the Visible property of the screen to create an array of the tabs (buttons). And then set the Default property to First(Tabs), problem is, I can't see a Default property. This is becoming a real head scratcher.
Hi Shane can you make a demo on how to connect an External List to powerapps? I successfully created a external list (External Content Types) in SharePoint Designer that was connected to Windows Azure. I am frustrated with my work because their is no powerapps supported on the external list. Hope you can help. Thank you so much. God Bless and continue to make video tutorials on powerapps.
@@ShanesCows thank you for your response. If your question is can PowerApps connect to the data directly to SQL, the answer is YES. My SharePoint app was designed to get data from SQL. I successfully created a external list (External Content Types) in SharePoint Designer that was connected to SQL. May i request if you could demonstrate on how to work with PowerApps via external list? or what is the best practice if you have a data in SQL ang you want to make it as a SharePoint List and then editing or viewing it on PowerApps. Hope you can help me on my problem. Thanks you so much and God Bless.
Thanks Shane. I am looking out a way to make tabs within PowerApps and now have a solution to it.
Awesome 😎
Great video, thank you! As a quicker workaround for the "rectangle dilemma", I set my Button padding to be 0 at the top, which put the button text a bit higher up, then I could just have a single solid rectangle going all the way across all the buttons at the front.
Great tip!
I have been struggling to create this for the last couple of days, you are really a live saver!
Thank you so much!
Glad to help. 😀
"Hey, it'd be nice to see the different screens version of that, right, the multi-screen" ;-)
And thank you, sir, for another great video.
On the list. Thanks
@@ShanesCows Hey do you have this on the different screen yet ? Thanks
@@ShanesCows , is the video for multi-screen forms available? Primarily running the App on a phone so the limited space makes the tab format not work well. Thank you for all you do! Great Videos!!!
Hello, I also would like to see multi screen solution, thanks
@@ShanesCows I would also like the multi screen video, thank you
I wanted to make a tabbed form and I knew right where to go for a quick tutorial! Thanks Shane.
Thanks Shane. I am literally working on powerapps with over 300 cards. This is great way to reduce user scrolling up and down :)
Perfect!
Your videos are great!!! I'm just starting to move away from infopath and making myself learn powerapps and your videos have been so helpful! Thank you so much!
Awesome
Great Stuff Shane!. Your videos helps stimulate ideas and also helps me to think outside the box.
Glad it helped. :) Stay outside that box.
Keep it going! can't count how many times you helped clarify things for me thank you!
Will do. 😎
Great video Shane - much appreciated. It's really helpied me out with an app I'm working on at the minute. I'd love to see the multi screen app too.
Cool. I will add it to the list.
Thanks so much, Shane! This is great temporarily solution for what I'm looking for right now! But, I would LOVE to see the multi-screen version that you mentioned. Love your vids, I'm learning so much from you. :)
Glad it helped. I need to make that video, and about 5 others, one day. :)
As always, great content! Thanks for sharing it with us!
Happy to help. Have a great day. 🐶
Great walkthrough! Heavy data models with more than 150-200 columns in the content type are not uncommon for big organizations and using multiple screens for model-driven apps is much more complicated. All users should pay special attention to the remark at 23:41 - watch out for those required fields!
Thank you for the kudos.
Thanks Shane. I am a big fan of yours. Your tutorials really help me.
Thanks Chan!
Another upvote for a multi-screen version too. Another great vid, thanks for sharing. Also, please change your curated library to allow paypal :)
Fido that is an easy change. If you email me Training @powerapps911.com I can get that setup for you. 😍
Just made this. Used a horizontal gallery instead with search, sort & filter. Thanks!!
Cool! 😎
Hi Shane,
I am a fan of all your training modules. Your teaching style is amazing and instructions are clear and very easy to follow. So, thank you. Here is my question regarding the Tabbed design. I am creating an employee profile app where employees can fill out the form and insert their information. The data source/capture is a SharePoint List. I am following your instruction for creating a Tabbed Form. However, this app has two major requirements: 1) The employee skill sets (a multi-choice field) have nested Tabs meaning, the main skill Tabs include Software, Research, Fields, and Project management. These four branches of skills each have nested sub-skills. For example, Software includes at least 10 choices. Same patterns for Research, Fields, and Project Management. I have a problem assigning different skills to nested skills tabs. For example, I want to assign all employee's software skills to Software Tab and all his/her skills in research to the Research tab. How do I assign a software skill that is both under Skills (main tab) and under Software Skills (nested tab)?.
The second requirement is if the employee selects "Ohters, please specify" option from each tab, then there should be an associated Free Text Box so they can insert text and then data be stored in SharePoint list. By the way, I did post this question in PowerApps community a while back and have yet to receive any guidance. I appreciate any guidance or reference.
Thank you
You must be psychic, because I literally have 2 projects I'll be starting next week that will benefit from a tabbed UI. One note, though, on the way you made the "tab" buttons: there is an easier way. Buttons are one of the few (maybe only? wait, no...images have it too) objects in PowerApps that have a "radius" property. You can set the radius for each corner of the button separately, so just set "RadiusBottomLeft" and "RadiusBottomRight" to 0 and they'll be square.
Good call Chad. I was going to do that and then I got distracted with the whole rectangle thing because... I don't know why. :)
One of my favourite videos...as it just worked, even for me. Wondering whether it is possible to add a Tab which says "All" so all fields are displayed. I'm thinking that this might make it easier to do a screen grab or Print().
This is incredibly helpful. Is there a reason that you call on the displaymode vs. just the var?
Lo habia realizado con swicth es u algo mas tedioso estar programando cada lado, con esta solucion es mucho mas facil, mil gracias por el video.
I think I answered your other comment on this. :)
Hi, Shane! Love your videos and trainings. Did you ever make a "different screens" version of this concept? That would be extremely helpful!
I ahven't. I should. 😑
Great video, Shane! It was very useful for my projects!!!
Awesome 😎
Hi Shane! Did you make any Model driven power App video. I searched but couldn’t find. I am not a coder and so I thought that would be easier for me. Love your videos. Thank you.
Yeah your taking to me
I haven’t yet. One day for sure.
Another wow! Like others who've commented here, I needed this RIGHT NOW. How did you know? And, like others, I would like to see the multi-screen version. I have some SharePoint lists with dozens of columns. I had trouble getting these few columns to line up properly on only three tabs, so I'm guessing I'd lose my mind trying to do the big list on one screen. And as Dan Quayle (remember him?) once said, "A mind is a terrible thing to lose."
Potato? The video is on the list. :)
Another great video Shane. I have been watching (and rewatching) lots of them. I would like to know if there is a video where you use data from several sharepoint lists and create a new record in another sharepoint list using that data. ie a customer DB, a bill of materials etc being used for a final output. It limits the ability for materials which are not available being allocated to a client job order or can allow for incremental information to be added to a contract. ie if we are going to concrete a carpark for a client, it will take 20 loads and 5 days we can collect the contract details, customer details from 1 or 2 sharepoint lists, then have a list of consumed items (ie load of concrete @ 8 yds, some labour items, other costs selected from another SP list ( to limit the options ), allocate amounts such as hour units of labour, then save these records to a new SP list. This list would grow each day by one or more rows, but each row has a common contract number or client number to allow for aggregating the data for billing later???
I think you are looking to build relationships? I cover those in several different videos but not this exact scenario. Maybe try this series to learn more about relationships th-cam.com/video/xgznk4XlPCo/w-d-xo.html
@@ShanesCows Thanks Shane. I'll have a look at the links. I used to do SQL stuff "back in the day" but I struggle to find the "flow version". Your video on CONCAT vs CONCATENATE for example was a real slap the forehead moment :-)
Hi Shane,
As always, excellent video - really helpful! Is there any news from the PowerApps guys as to when they might have a better solution for laying out datacard's in a form? The solution you have demonstrated is exactly what I need and works really well apart from the layout issues mentioned in a few of the comments here. I think I may end up using multiple forms on the same page with only the datacards I want to show for each section and then making the form visible depending on the button clicked. Is there any reason you can think of why this wouldnt be a good idea?
I am sure they have plans to make it better. Just not sure what or when. 😑
Hi Shane, thank you for this tutorial! This is a very big help for me as a beginner in PowerApps and Development World :D Stay safe!
You're very welcome!
Hi Shane! Thank you for one more amazing video 😊 I have a question regarding the forms. I have 7 user groups defined in my sharepoint and I already defined their permissions for a certain list in sharepoint. I created a power app where I have an edit form for that list. What I want to do now is make some fields editable by certain user groups and others only readable by other certain user groups. How can I do that?
You would need to apply the concept in this video to find out who is in the group or not. Then show only people are in the group. th-cam.com/video/rRnbe1CfQ30/w-d-xo.html
Hi Shane, very good video thank you. This is exactly what I needed for my sharepoint. Just one question, I have applied your tutorial for the 2 buttons that I have but when I open an item on my share point list, none of the button are selected and I have to click on one button two see the fields. Can we force the selection of a button on power app when we open a item on sharepoint?
OnVisible Select(YourButton)
Hi Shane, This video was hugely helpful to understand the basics of tabs in PowerApp Forms. I've created great Tabbed views that are working. However, I try to arrange the datacards in the form for each tab views and it's driving me crazy - when I get on tabbed form view correct the rest are screwed up. Any advice on how I can lock the items in the form for that tab view?
It is just a pain in the backside you have to struggle through. Sorry, forms get grumpy.
Hi Shane, As usual, great video and I'm learning so much everyday about PowerApps from you. I got this working, the only this is, my gallery is on one screen and multi tabs on another screen. How can I default the landing page of the multi tabs screen to one of the tabs? Please let me know, thank you!!!
I just figured. Set the screen visible property to set(vartab,"tabname") :)
Glad you got it.
Great video as always! :D
A little feedback: It would be nice if you'd reference mentioned videos in the description (which is better on newer videos ;o) )
Agree. Sometimes I forget to. Boo me. If you ever can't find one leave a comment and I will get it added. Thanks
Hi Shane! Your videos are so informative! Love them. I'm currently working on a three tabbed form. I have a Reset Form icon and a Home icon. I'm having trouble programming the home button. My first tab and what's considered the Home screen is Employee Details. So I've tried NewForm(frmEmployeeDetails) for OnSelect of the Home button, but it's not working. I have also tried Navigate(frmEmployeeDetails). Any ideas? Thanks!
I love these videos... and I love Power Apps... so much fun developing apps that I wish I could do it more often :-)
Hey Shane, I’ve been watching you’re tutorials for awhile now and I’ve been wondering on how you could scan a barcode that is multiple lines (PDF417, that code does work) and have each line in its own text label. Ex: you scan it and the first line goes in 1 label and the second goes in 2 label. Any idea on how you would do it?
I haven't tried. What I would recommend messing with is the Split function. It is what I used to split comma separated values, not sure but it may also work for you.
Another great post Shane !!!! Thank you..
Glad to help. 😀
@@ShanesCows
Can we change default scroll bar color, width in PowerApps?
Gallery, SharePoint Forms all contain scroll bar with default theme.
Can we customize that?
Any help/ input on this topic ?
Thank you
I am brand new to this and was waiting for the part when you showed how to make the first tab disabled upon load. My form is a sharepoint list form. I have 5 tabs. On my first tab, I altered the displaymode formula to make it disable when you create a new list item or open a list item. My first tab is named "Details". If(Or(varTab = "Contacts", varTab = "Attachments", varTab = "Comments", varTab = "History"), DisplayMode.Edit, DisplayMode.Disabled)
Thanks for sharing
Thank you for this tutorial🙂 how to navigate from one tab to another using "Next" and "Prev" Buttons at the bottom of the screen.
Have the next button set the variable to the new value. 😀
hi Shane, this is cool, thank you. Question: if I've got mandatory fields in the Form, and on submitting there is an error because mandatory fields were not populated, the User is taken to a created FailureScreen, can I list field names there that cause an error?
Karolina I think you would have to create logic to show them the field names. 😑 Try something like making a label that says you forget "Dog name" and set it to visible if IsBlank(inpDogName.Text)
Great video, Shane, as always! Now I'm waiting for a better UI for arranging the datacards. This is getting on my nerves.
It ain't great for sure.
I would be interesting in seeing the multi-screen version. I have a SharePoint list which is used to store data from multiple people/disciplines and i want them to have their own screen for their discipline.
Noted. 😀
Nice video Shane. One question...
If I have required field validation enabled on a control which is on tab 2 and is empty but I am on tab 1 and I press submit, the validation will fail. But how the user will visually know about the required field validation of that contorl which is hidden in tab 2?
Hi Oli you would have to build that into your design. Sorry no magic bullet. Maybe on Failure you could show all fields instead of tabs?
Fab video! I tried this once and it worked a treat, I'm now using it in a different app and I can't get the other 'tabs' to show their contents!! I've looked at the button OnSelect and DisplayMode and they are correct, then double checked the Visible setting for the field and -again- it all appears to be correct.
The first tab works, and if I select another tab the first tabs fields disappear as they should... what on earth is going on?! Thanks for any help you can give :)
Check for typos in your variable maybe?
great video!, question, how do you do to show the fields clicking on the buttons if the form is not running (f5)
Hold down the ALT key. 😊
Hi Shane.. great video! Could you do one with multiple screens?
I need to do that. Man I need to do that. Making sure it is on the list.
Hi! This video was very helpful. How do I get the "tabs" to work in View Mode also? At the moment the tabs are only working when I have the form in New or Edit mode. Thanks!
Buttons don’t work inside the form but should if they are outside. Though I have never confirmed
Very Nice! Thanks Shane!
You are welcome.
I'm your big fan now.
Thanks 😊
Hi Shane, great video, how do you make it that when the form opens the first tab fields are showing?
Set the value of the variable to the first tabs value OnVisible for the screen
Obrigado Shane, from Brazil.
De nada Robson 😎
Thank you Shane, loving your videos, they have helped me learn about PowerApps. Please don't stop! :)
Your welcome
Shane, are you able to display a field on 2 different "tabs"?
For example, I have a form that has a reason field. I have a 3 tabs, but users don't have to enter data on every tab if its not necessary. But I need the reason field to show if if they click tab 1 or tab 2.
Is this possible?
Yes for visible use an Or. var = “red” Or var = “blue”
Hey Shane, Can we build Survey Questionnaire based on Dabaverse tables. Means Questions and Answers will be load from tables or entities and Answers should be display as radio type and final data will be saved to Employee Survey table. and if you want to edit then they can change the Answers as well. Also, It will be show % out of 100 score.
How to set VarVideo default value to "Info"? Because unless we click the button, it shows blank screen.
App OnStart set the variable. Then it will be defaulted 😎
Hi Shane,
Thanks for another very helpful video! I am going to use the Tabs set up in conjunction with a Gallery of Machines.
For each device in the Gallery, I want to map an assigned tab,:3-5 different machines per Canvas/Gallery
In each tab will be a close up image of the machine I plan to use Tooltip for a lot of mouse over inf0. Additionally there will be one "Card" form with a collection of links to technical manuals and operating work instructions in the quality system "documentum" database
So my question to you is........
Instead of having Thingies (too technical?) visible based upon DisplayMode I have made them visible according to the Global Variable assigned on clicking the button.
Is this wrong or just different?
To code for Visible for all the "Thingies" that I want to show up when Button A is Selected
Button: OnSelect Set(View, "ButtonA")
Thingy: Visible View = "ButtonA".
Am I missing something as this seem simpler to code and would rather type less..and do less in general, especially if one can get the same results...LAZY I guess...
Seems solid to me. 😀
Shane, Thanks for the video, and the many others on PowerApps! Do you have any demos on how to utilize scrolling Screens and Fluid Grids? I'm interested in making a simple, but interactive, leaning module. Something that would take a user 3 to 5 minutes to complete that uses screen shots from web sites with overlaid buttons made to look like the clickable links on the site, so that I could interactively step a user through the demo. I think I've got most of how I want it to function worked out, and probably could do it using the tabbed form method you described here, but I"m super interested in using the scroll-able screen with fluid grids. - Its the option just to the right when you add a new screen, or if you look in the list of templates there is a PowerApps tutorial that uses what looks to be a complicated version of what I'm trying to do. - perhaps you could dumb it down and help your adoring public better understand the basics of how that method would work/look like.
Shane, many thanks for the video. What if I want set a default tab when users open an app?
Set the variable to that value. 😀
Hi Shane,
Can you print all the tabs? with the print button?
The print button just prints what you see on the screen. So you probably have to make a view where everything is on the screen to get print to do what you want. But I have never tried.
Thank you Shane! This tutorial is perfect!
Thank you 😀
you don't need to type in the enum's name before the value (talking about DisplayMode, FormMode and such) the "Disabled" one was actually in the dropdown
Yeah. I type in extra stuff a lot to help keep viewers from getting lost. Glad you have gotten beyond it. :) Thanks!
@@ShanesCows I got beyond it by your videos. thank you!
Hi Shane! Thanks for you usefull videos!. You Rock!!!
You are welcome. Glad it helped. :)
Hi Shane, is there a video for different screens? Thank you
Still haven’t done that one. 😑 One day, one day.
Hi Shane,
Do you know when "Developing Business Applications with Microsoft PowerApps, CDS, and Flow" course on edX is going to be updated? I wanted to pursue verified certification. Unfortunately, the course is archived and not no longer active to get a certification.
Regards,
Gogi
I have been told they are not going to update it 😔
@@ShanesCows That's a shame! Thank you for answering my question (Y)
This is really really helpful, but I am having the issue that unless you are on that tab, you wont see the fields. I would like to show the fields when they first go in
Change the default value of the variable that shows and hides to what you want.
Hmmmm...This is great if your form is not long, but my app form is 2.5 screens long from SP. If I set the visible like this , then I have tons of spaces between the datacards. If you move the datacards that need to be visible for associated tab (to the top for instance), they move due to over lapping datacards from the remaining not visible tabs or the remaining datacards move to justify your command. What I have done to overcome this (and most likely the long way of a fix) I selected the number of columns to be 24. This allows all of the datacards to be on one screen without scrolling. I then added a rectangle for each section of my form and Set the varTab to each rectangle. I added the controls needed for the Tabbed section of the form. The controls are set to populate the text box of the datacard to update SharePoint upon saving. This method just covers the screen with a box to allow flexibility of the controls and getting rid of the overlapping of datacards.
Glad you got it to work. Forms can be "difficult" to make do exactly what you want for sure.
@@ShanesCows I did not mention that alot of the functionality came from your X and Y fly out menus, I just did not use the timer and set the varTab to open the appropriate section. Thanks for the continuous learning experiences - I have learned so much from you and find all your information valuable at some phase or another.
Also, my tabs are along the left side of the page instead of the top. I have 7 sections and the buttons just fit and look better.
Hi Shane, can we prevent users navigating to other tabs without an approval field being marked as 'approved'?
Sure. Set the tab aka button to be disabled if the field IsBlank
Hey Shane, thanks for sharing such videos. I have one query wherein I need 'Edit Button' to appear once I select any item from the 'ListBox" and then by clicking on 'Edit Button' it would enable user to navigate to page where details can be edited.
Thanks in advance
Have OnSelect in the gallery set a variable to make the edit button visible
hi shane, great stuff. What if i would like to make a pdf of this tabled form, a page for every tab?
I have a video two videos on pdf that should help.
Thanks for the tips in the video Shane! Question, any considerations to using a context variable instead of setting global variable? Since here is one page, wouldn't affect it, but I imagine for the multi-page one would?
I don't like Context varialbes and rarely use them. They always trip me up so for better or worse when I build the app I am a Set kind of guy.
@@ShanesCows Awesome. Thanks so much for all you do. Great job!
This is a great lesson. I love it as other lessons you made. Thank you so much.
Thanks 😊
If you want to always go to the “info” tab first instead of the tab you left on when clicking a new employee how would you do that?
When you click a new employee set the varTab variable to Info. :)
when the buttons are pressed, the fields would show for View mode, but it only works on Edit mode :(
Thoughts?
Oh boy, I have 99% set out what I achieved to do! I've got 5 lovely tabs across the top, and I've updated all the datacard visible properties to show them in the right tab... but I'm working in a PowerApps Form on a SharePoint list rather than an app, so there's no gallery. As a result, when I edit an item in the list, the form is blank until I click on the first tab. I'm thinking I need to update the DisplayMode there, but if nothing has been selected so far, there is no varTab set, so I'm not sure if I can reference it,? I tried If(varTab = "", DisplayModeEdit, If(varTab = "Info", DisplayMode.Disabled, DisplayMode.Edit)) but it wasn't a happy bunny. I would be so grateful if you could help me get this final 1% done!
How about OnStart for app Set(varTab, "Info") that way it always defaults to the first tab.
@@ShanesCows That worked! Thank you so much! Now if you'll excuse me, I'm off to repeatedly open items in my list just to admire my new form...
Hey thanks for teaching us!
how can I do for wait until refresh() is complete to navigate to another page?
With a timer. I actually show waiting 10 seconds that way in this video. th-cam.com/video/GiN47Is_634/w-d-xo.html
Hi Shane . Thanks for the tutorial. How to fix my data that go to different row in the sharepoint list for different tabs. As example, tab info is one row and tab job is another row . How to fix thats ? Thank you
Use different forms for each tab.
Hey Shane, this video has helped me in implementing tabs layout for my app. I have an app with both view screen and edit screen having 3 tabs each(same tab name but controlled with different set of variables on each screen). Everything worked fine until I tried to set variables to make users remain on same tab name when navigating between view and edit screen. Say, if a user selects tab B of view screen and navigates to edit screen, it should open tab B on edit screen. This functionality seemed working in app studio. But when opened through web link, no items were loading, and on relaunch of studio, I found incompatible type errors for the context variables set for controlling tabs(varTab). Any help regarding the fix would be much appreciated. Thanks, you are doing great job.
Use global variables. Set(varTab, "stuff") instead of UpdateContext({varTab: "stuff"})
Hi Shane, thank you for your videos. They are very helpful. In regards to this method of a tabbed interface, is there a way to control who can see each tab? I'm building a SharePoint site feedback form. One tab would be for the user to submit their idea (they would only see that tab) and the other would be for those of us doing the backend work, assigning tasks to site owners, setting the priority level, updating the status, etc). We administrators would have access to both tabs. I'm pretty new to all of this so if there is a better way of doing this/switching between content types, can you let me know? I've seen your video on how to email a link from PowerApps. Maybe in this case, site administrators would just prefer to update a standard SharePoint list than toggle between tabs? Any advice on how you would handle it is appreciated. Thank you- Teresa
Teresa, you can validate the current user based on a list of users who are allowed to view certain areas. So it would be an iF statement. "If the current user is in this list then whatever is visable". Does that make sense?
I like this answer. Nice work.
Gerfervonbob thank you for the response. Where do I go to set app level permissions? If you know of a good tutorial link, please send it my way. Like I said, I’m new to this so I’m still trying to learn the basics. Thanks again!
great stuff Shane! I had created 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 don’t understand what you are trying to do?
@@ShanesCows appreciate your response. I have a sharepoint list. I was creating an edit form. In the edit form, I had created 4 tabs and assigned different fields to them separately. I want to manage the access as per the current user. I have made a list of some users (managers) for editing who should have access to all the tabs. Managers enter persons email IDs in the people's field in the selected item. Whoever is available in that field must see 2 particular tabs. Is it possible?
Hi Shane, Thanks for the video but I'm having a bit of an issue. When I launch the app, the arrows will only show the items record if I save a new form. It's a very weird thing. Any idea what I've done wrong?
Shonda look at your form Mode. It should probably default to View. Also, make sure if the Item property of your form is a variable that you are setting that variable when you click the arrow.
@@ShanesCows the weirdest thing is that it works momentarily when I preview it, but when I publish it and run the app the form will not display the records of the gallery selection. The form is set to View and the Item property contains the galleryname.selelected. The OnSelect property of the arrow is set to a variable so that it reflects the data under the General Tab as shownn in the video. Thanks so much for responding!
@@ShanesCows it looks like putting this code on the OnSelect property did the trick: Select(Parent); Set(varNCA, "General")
Hi Shane, Would you be able to direct me to a resource that could help me navigate to another screen on powerapps, but in a new window(new tab)?
See if this helps th-cam.com/video/NzhwTrXA-cQ/w-d-xo.html
Hi Shane can you make a demo on how to connect an External List to powerapps? I successfully created a external list (External Content Types) in SharePoint Designer that was connected to Windows Azure. I am frustrated with my work because their is no powerapps supported on the external list. Hope you can help. Thank you so much. God Bless and continue to make video tutorials on powerapps.
Relied to your other comment.
Hey Shane , thanks for your videos ! I got a question , i got a Sharepoint List which i connected with my Gallery in PowerApps. In my Sharepoint list i got different products with a column for the pictures. The pictures are on my OneDrive and in the sharepoint list is the link to each picture.
On the PC you can see everything completely normal. On the app on the phone, the pictures are unfortunately not displayed.
How could this be solved alternatively?
Would be very glad if you could help me!
Hey, just had this issue my self and solved it with this: First(ThisItem.'{Attachments}').Value
@@DraaxDard It does not work me ...you want to send me a mail DraaxDard so maybe i can show you what i have to look like. My mail : 95kizil@gmail.com
Thanks for the assist. :)
Your App isn't authenticating with the data source. You need to add OneDrive as a data source in the app.
Hi Shane, I have fully developed mobile application which I need to convert it to a tablet applications (tablet layout). Is this conversion of Mobile app to tablet app or vice versa possible?
Not really. Better to build a fresh one and just reuse your logic.
#OnPoint Thank you Shane!! 👊👊
Glad to help Thomas. 😀
Hi
How do I make the users go to the tab by default depending on the status column of the form. At the moment a user is having to select Part A, Part B, Etc, if there a way for the app to default the users to the tab rather than having to select them?
OnVisible for the screen set the variables value to corespond with the tab you want to show based on the records value.
Thanks Shane!
You are welcome.
Hi Shane can you please do a multi screen App would appreciated very much
Maybe. It just Isn’t something I typically do so hard because make a video on. If multi screen I always use patch.
@@ShanesCows Thanks
Thanks Shane. Hey does anyone know if there is a way to drag a list item into a higher or lower position in a list?
There isn’t really any drag and drop stuff. Sorry
Thanks Shane 👍
Welcome
How to display a very large SP list say 6000 rows and search function to filter it?
You can’t search it. Search is not delegable to SharePoint
Hi Shane, is there any way to default to a particular "tab" when the form first loads?
Yes. Set the variable to the value of the tab.
@@ShanesCows Hi, thanks for the response. Apologies, I'm new to PowerApps, I've set the variable on the OnSelect property of the button, I get that, but what property do I set it to to set the variable when the form loads? I've tried various properties on the form and the screen and none seem to work. Any help is really appreciated.
Try setting the variable to what you need using the OnVisible property of the screen.
@@ShanesCows No, that doesn't seem to work. I read somewhere else to use the ClearCollect function on the Visible property of the screen to create an array of the tabs (buttons). And then set the Default property to First(Tabs), problem is, I can't see a Default property. This is becoming a real head scratcher.
Thanks
You are welcome. Glad it helped. :)
GREAT VID!!!!! Extremely Helpful
Dude...you are AMAZING but cut the "here'z your intro". XD Anyway, thanks for the amazing work.
Thanks Paulo! 😀
Different screen version please!!!! :)
Yes. I need to do this.
@@ShanesCows Hi Shane.. another good video could be on Powerapps ALM practices.
even though there's a hot chick in the picture, shane's head is just too big here so i'm watching him instead. u sexi you! :D
Thanks :)
@@ShanesCows :D
His name is familiar
It is the best name. 😎
Hi Shane can you make a demo on how to connect an External List to powerapps? I successfully created a external list (External Content Types) in SharePoint Designer that was connected to Windows Azure. I am frustrated with my work because their is no powerapps supported on the external list. Hope you can help. Thank you so much. God Bless and continue to make video tutorials on powerapps.
Think about the problem differently. Can PowerApps connect to the data directly, the same way SharePoint does?
@@ShanesCows thank you for your response. If your question is can PowerApps connect to the data directly to SQL, the answer is YES. My SharePoint app was designed to get data from SQL. I successfully created a external list (External Content Types) in SharePoint Designer that was connected to SQL. May i request if you could demonstrate on how to work with PowerApps via external list? or what is the best practice if you have a data in SQL ang you want to make it as a SharePoint List and then editing or viewing it on PowerApps. Hope you can help me on my problem. Thanks you so much and God Bless.