PowerApps Forms - Introduction to data sources, data cards, and layout

Поделиться
HTML-код
  • Опубликовано: 30 май 2024
  • In this video, you will learn about PowerApps Forms. This is the first of a multi-part series meant to help you learn all about this critical piece of PowerApps.
    Topics covered in this video include:
    * Adding a data source
    * design controls for a form
    * data cards
    * connecting to a gallery
    If you need additional help please contact www.PowerApps911.com
  • НаукаНаука

Комментарии • 365

  • @concerned_2023
    @concerned_2023 4 года назад +5

    I just came back from a one day Microsoft Power Apps course. I learned more here in five minutes than I did spending a whole day in the course.

    • @ShanesCows
      @ShanesCows  4 года назад

      Sorry but at least you found my videos. 😀 we also have proper training at PowerApps911.com

  • @samuel311
    @samuel311 2 года назад +1

    Cant say loud enough how helpful this tutorial is. Super helpful is an understatement. Thanks Shane!

  • @seadude
    @seadude 5 лет назад +10

    "Add Custom Card" was a nice revelation! I keep adding "placeholder1", "placeholder2", etc COLUMNS to my Sharepoint data source to make "spacers" and "section headers". Thanks Shane.

    • @ShanesCows
      @ShanesCows  5 лет назад +1

      Glad it helped. So many little tricks for sure.

  • @deal0417
    @deal0417 3 года назад +2

    I just really like to thank you for having these comprehensive tutorials online. It really helped me in creating a simple app for work. More power to you.

  • @ricksegalCanada
    @ricksegalCanada 3 года назад +2

    There should be some kind of annual RUclips Guru awards thing. In the category of "Power" Series, Shane would be the record holder for most consecutive wins. Outstanding work!

  • @Amr-Ibrahim-AI
    @Amr-Ibrahim-AI 4 года назад +1

    Thanks Shane for always being helpful. I was struggling with datacards and how they are connected to the data source. Enlightened at 16:32
    Thank you!

  • @macasu
    @macasu 3 года назад +1

    Shane, thanks. Never used Powerapps prior this video. In one day I have created a basic survey tool. Now learning how to add the bells and whistles. Looking forward to the next sessions. Mac

  • @VideoGameMusicFan13
    @VideoGameMusicFan13 5 лет назад +1

    Very informative. Thank you, Mr. Young!

  • @MarcSoester
    @MarcSoester 5 лет назад +2

    Shane, you are a very knowledgeable man. Thank you so very much for sharing your knowledge. You have a new fan in me :) thanks mate

  • @DataSpinners
    @DataSpinners 4 года назад +1

    Thanks Shane - Forms are so underrated and are really great for citizen developers to get their apps off the ground.

    • @ShanesCows
      @ShanesCows  4 года назад

      They are even if they drive me crazy.

  • @dmdleiteagmailcom
    @dmdleiteagmailcom 2 года назад +1

    Shane is awesome! Thank you for your assistance and generosity!

  • @frankmixson7578
    @frankmixson7578 5 лет назад +1

    Awesome video. It came just in the nick of time as I have been struggling with many of the topics you addressed.

    • @ShanesCows
      @ShanesCows  5 лет назад

      Thanks Frank! Glad to know it helped.

  • @zoeyliang3567
    @zoeyliang3567 3 года назад

    Hi Shane, thanks forcreating this tutorial which is super helpful! I am facing a problem on ordering the data cards in a form. I have a massive table where all fields are presented in a same form, and i want to order the data cards linked to certain fields in my share point table in the form. I did most of the cards by adjusting in position X and Y, however there is 1 card that doesnt work. ie. however what number i enter in the X and Y position boxes, the card doesnt move at all. When I am back checking the numbers in X and Y, these numbers went back to the original default setting. May I pleae know if this is something you have seen before and any helps are appreciated!

  • @dees4130
    @dees4130 4 года назад +1

    Nice video! Your delivery is very informative but concise and to the point!!!

  • @TheDungeons2077
    @TheDungeons2077 3 года назад +1

    Shane, you're my hero. Sincerely - thank you

    • @ShanesCows
      @ShanesCows  3 года назад

      You are too kind! Thanks

  • @jaggyjut
    @jaggyjut 5 лет назад +1

    Excellent video and very informative. Thank you Shane.

  • @pinkangora
    @pinkangora 3 года назад +1

    Thank you this was very straightforward and helpful.

  • @knpckw
    @knpckw 5 лет назад +1

    I can’t thank you enough. You are awesome 👏🏻

  • @twiendlocha
    @twiendlocha 4 года назад +1

    Another great vid! Learning so much! THX man!

  • @lanchang7063
    @lanchang7063 4 года назад +1

    You are great! A big fan of yours. Thank you for this video and others.

  • @emaildodanielmelo
    @emaildodanielmelo 4 года назад +1

    Hey Shane! thank you for the video! helped me a lot!

  • @mannymorales7913
    @mannymorales7913 3 года назад

    Great video - thank you, Shane! Cheers!

  • @barbararevill7554
    @barbararevill7554 3 года назад +2

    probably a very silly question, I have created the form, when I click on play ("the form) nothing comes up? I followed the video step by step, and I used the gallery view, although my gallery fields are blank, I don't need the gallery view, I just want to see a form, kind of like you would see when filling it in on paper.

    • @ShanesCows
      @ShanesCows  3 года назад +1

      If you want the form to create a new record and be blank you need the form to be in New mode. It defaults to Edit. ruclips.net/video/BnzaSDYl8mA/видео.html

  • @tanmaysathaye
    @tanmaysathaye Год назад

    Hi Shane, Thanks for your videos! I have watched several videos of yours and am a huge fan of your channel. You have tremendously helped me in your videos, and made the journey of learning Power Apps very enjoyable!
    After practicing Power Apps, I have come across some questions:
    1. In Dataverse, there is a lookup column 'Currency' in the Opportunity table. Is there a way to add a drop-down control in PowerApps such that instead of showing the default options (1,2 and 3), it shows the options that are already defined in Dataverse (US Dollar, Australian Dollar etc.)? Can it be achieved without manually defining the options in Canvas Apps, since there are hundreds of currencies and would like to sync my drop-down control with Dataverse lookup column.
    2. While working with Edit Forms in Power Apps, I've noticed that when I try to add a lookup field such as 'Potential Customer' on the edit form of Opportunity table, it inserts a blank data card. However, when I add the 'Currency' field, the data card gets added with the field properly. Any reason behind this?
    Could you recommend any videos of yours that could address my questions?

  • @pokeman3828
    @pokeman3828 2 года назад

    Hi Shane, Thank you for the tutorial. Is there a tutorial on SharePoint form using powerapps that routes the form from employee to supervisor to Leadership for approval?

  • @brentasten4479
    @brentasten4479 Год назад

    Very Helpful, Thank you

  • @chrisharper4041
    @chrisharper4041 4 года назад +1

    Really good informative video with some great tips

  • @cyriellebocquet6323
    @cyriellebocquet6323 3 года назад +1

    Hi Shane, thank you very much for the great content, your viedos are really helpful! I'm new to Powerapps and I was wondering, is there some situations where you absolutely need forms or you can always use a bunch of functions instead?

    • @ShanesCows
      @ShanesCows  3 года назад

      There is no situation forms are required. :) SOmetimes you might use them because they are quick and easy but never because you ahve to.

  • @pteixeira1089
    @pteixeira1089 3 года назад +1

    Thanks a lot Shane! Awesome!

  • @SuperPaunocudoyoutub
    @SuperPaunocudoyoutub 5 лет назад

    Shane, nice video and well explained. But I've been searching the web for a solution and can find it.
    I have a Sharepoint list that Iḿ using as datasource for my app. In the first column (Company) I have a list of companies, but some of them have more than one at the same column as (Company1, Company1) with different sub-items. What I need help is - How can I group them in the Gallery or DropDown so they show only one of each, and only shows the rest when selected? Is it possible?

  • @HowToExcelBlog
    @HowToExcelBlog 5 лет назад +1

    You mentioned the StarVisible part of the card, how do you actually define a field as being required?

    • @ShanesCows
      @ShanesCows  5 лет назад +1

      That comes from your data source. PowerApps determines it on its own.

  • @semperdiscendum7439
    @semperdiscendum7439 5 лет назад +1

    Awesome!! Thank you!! 👍👍

  • @far10472
    @far10472 5 лет назад +1

    Great stuffs Shane. Thanks to your videos I've been able to create a first app for my office and got great feedback. But recently I noticed that the layout and fields info are no longer appearing on the data source pop up screen. Same as seen in this video at the 5 mins mark. It was showing previously though. Any idea how I can bring them back?

    • @ShanesCows
      @ShanesCows  5 лет назад

      They have updated. If you look to the right can click fields and should be good.

  • @luca-rw7ss
    @luca-rw7ss 2 года назад +2

    Thank you, Shane. Very useful as always. Did you in the meantime already made some video about the "form Validation" (as a whole) and how to prevent submitting in case of error?
    Which is the best strategy regarding a Submit button (or save button) ?

    • @ShanesCows
      @ShanesCows  2 года назад +1

      I talk about validation in this video ruclips.net/video/s85i8UWw2QM/видео.html

    • @luca-rw7ss
      @luca-rw7ss 2 года назад +1

      @@ShanesCows Thank you so much!

  • @NKBobcat
    @NKBobcat 4 года назад +1

    Thanks again Shane!

    • @ShanesCows
      @ShanesCows  4 года назад

      You are welcome Bob 😊

  • @sudosaurus
    @sudosaurus 4 года назад +1

    Shane, with the gallery Titles, in your video are these list items? I'm building a fairly large form at work for a new contracts management system and as the SharePoint list has roughly 75 columns, rather than scrolling down one form, it would be useful to be able to use something like the gallery to navigate through different parts of the form rather than scrolling forever.

    • @ShanesCows
      @ShanesCows  4 года назад

      Try this ruclips.net/video/7XXo9wjnJvc/видео.html

  • @tiranirani6501
    @tiranirani6501 4 года назад +2

    Great videos - I'm new to PowerApps & have learnt a lot from your tutorials - thanks.
    However, I have one issue relating to dropdowns in a form.
    I have a dropdown in a form that relates to a numeric field which is the ID of a store. The dropdown is loading ID and Title columns. When I load the record in the form I can see the ID number if I set the dropdown to use the ID - this value changes depending on which record I select in the source gallery (the gallery data source is a SharePoint list).
    If I select the text value (Title field) to display in the dropdown I just get the first item from the dropdown source list (another SharePoint list) value - the displayed value in the dropdown (the store name) doesn't reflect the value associated with the ID value from the gallery/SharePoint list.
    Any suggestions on how I use the ID as the data item but display the appropriate text in the dropdown?
    Thanks in advance.

    • @ShanesCows
      @ShanesCows  4 года назад +1

      I discuss this in this video ruclips.net/video/43ekj5MlNJU/видео.html

  • @funhurtsmylungs1056
    @funhurtsmylungs1056 5 лет назад +1

    Just a quick question. For your spacing, wouldn't it be easier to make multiple forms then select the column (from SharePoint) you want to display, then place where you want the page?

    • @ShanesCows
      @ShanesCows  5 лет назад

      Maybe. There are lots of ways to do it. Submitting a bunch of forms can be difficult though.

  • @gauppstopper
    @gauppstopper 4 года назад +1

    Hey Shane! I’ve watched this and your PowerApps forms mode video a couple of times and I still can’t figure out my issue. Seems like either a bug or simple oversight.
    I’ve attached a SharePoint list data source to my form and all the columns and corresponding drop down information shows up, and when I use the alt key play test it shows and works, but when I actually go in to play it shows me the “no data to display” screen.
    I’ve tried changing the form modes like you do in your next video and still the same outcome of no data to show. For what I’m doing with the app having a gallery to auto fill the data based on selection doesn’t make sense, but do I still need the gallery for the form to work?
    Thanks for the content! It’s been very helpful as I’m learning PowerApps

    • @ShanesCows
      @ShanesCows  4 года назад

      Set the items property of the Form. 😀

  • @factmeee
    @factmeee 4 года назад +1

    hi shane do you have a tutorial where i can add unique images, my data source is excel btw. was trying to insert images accordingly when i select an item

    • @ShanesCows
      @ShanesCows  4 года назад

      Maybe this. docs.microsoft.com/en-us/powerapps/maker/canvas-apps/add-images-pictures-audio-video

  • @scrosby1000
    @scrosby1000 3 года назад +1

    Hi Shawn, I'm struggling a bit with this, I've created the same form as you. the only difference is that I have two screens in the form. Screen1 and screen2. both screens have info on the selected item in the gallary. So for example I select Chewy and I see the info on chewy in screen one, then I select screen2 to see more info about chewy but the highlight bar on the gallary just randomly chooses another item. So I have to manually go back and choose Chewy. Is there a way to tell the gallary to STAY on the selected item? Thanks

    • @ShanesCows
      @ShanesCows  3 года назад

      Hey Scott use the varRecord concept from this video instead of Gallery.Selected and you can overcome this common issue 😀

  • @k4rd3n4l
    @k4rd3n4l 5 лет назад +1

    Hi mate, first of all, thanks your lessons! are awesome!! Second, do you know if there's a ctrl-C ctrl-V option to inlude in canvas? I mean, any option to send to clipboard any result from a query.
    Thanks again

    • @ShanesCows
      @ShanesCows  5 лет назад

      Not that I know of. Sorry.

  • @marklund7498
    @marklund7498 5 лет назад +1

    Hi Shane, at 04:44 you get to access the Form Pop Out form by clicking on any of the three options, such as Data. This gives you the option to refresh the datasource or edit the data etc. When I click on my form I can't see these options at all. Have things changed since you made this video? Thanks

    • @ShanesCows
      @ShanesCows  5 лет назад

      Yes. Now when you click on the form of you look to the right you have slightly different options. But all the same things are over there.

  • @soumyadeepbiswas1550
    @soumyadeepbiswas1550 3 года назад +1

    Shane, at 12:25 where you're explaining field types, is there a way to set a text field to a dropdown? Or does power apps determine that for us?

    • @ShanesCows
      @ShanesCows  3 года назад +1

      Yes. Click on type and change to allowed type. I think I show it here but not sure. ruclips.net/video/43ekj5MlNJU/видео.html

    • @soumyadeepbiswas1550
      @soumyadeepbiswas1550 3 года назад

      @@ShanesCows thank you! Appreciate your quick response... You videos help a ton!

  • @rashidahmohdsaid3578
    @rashidahmohdsaid3578 3 года назад +1

    Hi Shane, I've built a Powerapp Form from a SharePoint List and managed to incorporate a cascading dropdown field but if the field setting in SharePoint is set to "Yes must have info", I get "An entry is required or has an invalid value. Please correct and try again on Powerapps" when I try to save the form in SharePoint. If I set the field to "No", I can save the form but no matter what I select in the cascading fields, the corresponding field in my SharePoint list is blank. What should I do to make sure my entry can get saved to SharePoint correctly after I select from the cascading fields?

    • @ShanesCows
      @ShanesCows  3 года назад

      Not sure why you are getting that error. Sorry

  • @ketalanka
    @ketalanka 5 лет назад +1

    Hi Shane, great video's - I learn a lot from them. I am relatively new to Powerapps, but I have an issue with trying to show an edit-form. I get the message ' The property expects Record Values, but this rule produces incompatible Table values', and I haven't been able to figure out why. My gallery is coming from a PowerBIIntegration.Data object (works fine in itself), the editform has SQL server as a database. I try to connect the 2 by setting the item property to Filter('[dbo].[Tbl_CCMdata]',Srvc_order_unit=Gallery1.Selected.'Srvc Order Unit'). (Tble_CCMdata is the Sql data, the field in srvc_order_unit is seen by PowerApps as a String. The value of the selected value in Gallery1, 'srvc Order Unit' comes from the PowerBI datasource.) Any ideas why this isn't working? When I load my PowerApp in PowerBI, I see 'getting your data' continuously as well by the way (this may be a different problem)

    • @ShanesCows
      @ShanesCows  5 лет назад

      Try lookup instead of filter.

  • @gamingbeast7008
    @gamingbeast7008 3 года назад +1

    Good one 👍

  • @Anisayuni96
    @Anisayuni96 4 года назад +1

    Hi Shane, thank you for all the videos! My form works perfectly but somehow when I navigate to the previous page, and went back to the form page, the form is missing and will show 'getting your data...'. All the forms field will appear if I click New Form but somehow all the previous details that was typed in went missing. How do I fix this?

    • @ShanesCows
      @ShanesCows  4 года назад

      Check the Item property of your form. Guessing you did not set it.

  • @seth197725
    @seth197725 4 года назад +1

    Great video!

  • @katiekorth1171
    @katiekorth1171 3 года назад

    Hi Shane! Thank you for all of your videos, you are a LIFESAVER. I was wondering if you've come across any solutions to data cards within forms that seem to re-order themselves on their own? A co-worker and I have searched through PowerApps forums and have seen many other people with the same issues, but no solutions. A video or comment back would be a huge help!

  • @jahangirhashwani
    @jahangirhashwani 5 лет назад +1

    Hi Shane, Great videos mate. I have one question, If you could help? I have a scenario where I would like to show list of results from CRM Entity and then I would like to drag and drop the rows as per there choice and that sets priotiry stuff in CRM. Any assistance would be appreciated.

    • @ShanesCows
      @ShanesCows  5 лет назад

      sorry, there really isn't a drag and drop

  • @victoriakaloudis9421
    @victoriakaloudis9421 4 года назад +1

    Thanks for the video! I'm trying to create 3 forms for 1 SharePoint list. Each form would auto generate based on what project type a person is working on. Is this doable?

    • @ShanesCows
      @ShanesCows  4 года назад

      Sure. Need to use it to determine what to show them. Kind of like in this video ruclips.net/video/if_mFIfi5PM/видео.html

  • @parkins992
    @parkins992 4 года назад +1

    Hi Shane, thanks for all of your work! its taught me so much. I have a form connected to a gallery which is filtered by 2 date pickers, the form worked with item set to search gallery selected until i added the date pickers now it gives me this error "invalid formula. Expected a value compatable with the 'data source'"
    what am I missing please?

    • @ShanesCows
      @ShanesCows  4 года назад

      Where are you seeing this error?

    • @parkins992
      @parkins992 4 года назад

      @@ShanesCows thanks for reply, I rebuilt the gallery and it now works! Weird

  • @sandramcgechan5817
    @sandramcgechan5817 29 дней назад +1

    Hey Shane, I've really enjoyed your videos on automate and now I'm starting to explore PowerApps Forms (where I've previously used Nintex Forms). Have you done a more recent "introduction to PowerApps Forms" for beginners? Or has the UI/functionality not changed since you made this vid?

    • @ShanesCows
      @ShanesCows  29 дней назад

      This functionality is still solid to get you going. But if you are brand new you might enjoy this intro class better. training.powerapps911.com/courses/power-apps-and-power-automate-getting-started

    • @sandramcgechan5817
      @sandramcgechan5817 28 дней назад

      @@ShanesCows Superstar, thank you!

    • @sandramcgechan5817
      @sandramcgechan5817 23 дня назад

      @@ShanesCows That was a perfect introduction thanks Shane, I'm now able to watch and understand this video. :) Some of the UI has changed a bit, but it's easy enough to work out.

  • @dollyshah5397
    @dollyshah5397 5 лет назад +1

    How to create a tab view ? Something like the one in excel when u click on sheet that opens the same way on click of different tabs different forms should open but on same screen .
    Is it possible in powerapps?
    Kinly reply at the earliest.
    Thanks in advance

    • @ShanesCows
      @ShanesCows  5 лет назад

      Yup would make buttons that look like tabs.

  • @yamzychimomboh7790
    @yamzychimomboh7790 2 года назад +1

    Good work MVP

  • @davidjhernandez3052
    @davidjhernandez3052 5 лет назад +1

    Great video. I just have one question. What about if you finish the whole app but you are asked to create a mail merge operation from a one record in powerapps to a word document?. Basically, you are asked to pick up 5 fields of 40 fields in powerapp and mail merge those fields to a MS Word document. The mechanics will be to push those 5 fields to specific positions in the MS Word document. Can powerapps do that like it can be done from access 2019 > External Data > Word > connect to a form and wham! the 5 fields end up in the right position in the word document. Can power apps do that?

    • @ShanesCows
      @ShanesCows  5 лет назад

      David there are some Flow actions. That can help. Use PowerApps to send the data to Flow and have Flow do it.

  • @akshaynm
    @akshaynm 4 года назад +1

    Hi Shane, many thanks for the nice tutorial. You mentioned that you any another video where you have specified to define the Mode. I mean when the form is in edit or submit mode then a specific field should be hidden. Whereas when the form is in view mode then the field to be displayed. Could you please share the link of the video. Seems very useful.
    Regards,

    • @ShanesCows
      @ShanesCows  4 года назад +1

      I think it is called PowerApps conditional formatting

  • @Nopealope23
    @Nopealope23 2 года назад +1

    Is it possible to have a field stretch the HEIGHT of a column without stretching the rest of the columns? For instance, I'd like to have my form fields on the left and have one field, say Comments, run down the entire right side of my form. When I add the Comments field and stretch it down, it pulls the other columns down as well. Really hoping this is possible. Thanks!

    • @ShanesCows
      @ShanesCows  2 года назад

      I don’t think it is with forms.

  • @peteolding
    @peteolding 3 года назад +1

    Love your videos. Really help me. With the custom card you can add white space to a row. Is it possible to have one data card to go over multiple rows?

  • @prashanthdiddi7199
    @prashanthdiddi7199 3 года назад +1

    I love this video. But I have this question for you Shane... I designed a form which uses SharePoint list as data source. When I moved (export & Import) this into production and I updated the dat source with production list (Same columns) and it asks to replace / keep the data cards. Obviously I want to keep it, but when I removed the old datasource .... existing datacards on the form throws error. Is there a way that we can use the previous datacards without having to replace them when a datasource is updated?

    • @ShanesCows
      @ShanesCows  3 года назад

      Forms just don't move very well. :( Sorry

    • @prashanthdiddi7199
      @prashanthdiddi7199 3 года назад

      @@ShanesCows hmm... Any alternative approach? such as to use power apps controls and connecting then with SharePoint list column data for easy export & import? If yes, can you please share the video/articles that does that? Its a 60 column page though :(

  • @kittydoes7600
    @kittydoes7600 3 года назад +1

    Hi Shane, was wondering if you have already created a video about what you have mentioned here regarding showing field/s only on a particular condition or time 18:32

    • @ShanesCows
      @ShanesCows  3 года назад

      Maybe this? ruclips.net/video/IvapIsBbM-U/видео.html

  • @danielszelagiewicz2262
    @danielszelagiewicz2262 3 года назад +1

    Hello, Thanks a lot for your fantastic work here! Small question (I cannot find it until now): I want to increase and decrease value of record in edit form by clicking on a button "+" and "-" . But I cannot find a right syntax for OnSelect for these buttons... Any tip?

    • @ShanesCows
      @ShanesCows  3 года назад +1

      powerapps.microsoft.com/en-us/blog/powerapps-ten-reusable-components/ they have this exact control on this post.

    • @danielszelagiewicz2262
      @danielszelagiewicz2262 3 года назад

      @@ShanesCows Great, thanks. I found it myself by more testing from your video as well!

  • @karawhitehair285
    @karawhitehair285 2 года назад +1

    I absolutely love your videos and they have helped a lot when setting up power apps forms. The one thing that drives me crazy though is that when I set labels or my sections and I have a scrollable form, the text labels scroll with the forms! I have tried setting the positioning using the X, Y components, tried using alignment, etc. and nothing seems to work! Do you have any quick tips on how to get that done?

    • @ShanesCows
      @ShanesCows  2 года назад

      Thanks Kara. Check out this video where I talk about Scrollable screens. Maybe there is something in there that will help with the lightbulb moment? ruclips.net/video/0lNK9Bx4QKE/видео.html

    • @karawhitehair285
      @karawhitehair285 2 года назад

      @@ShanesCows - Sorry for the delay in getting back to you! Thank you so much for the response. I now see the error in my ways. I needed to create a scrollable form and set different sections/screens on the scrollable form. Unfortunately, I did not do that... 😞 You live and you learn! As a novice user at best, I have too much time invested into the initial form to start over again.

  • @Ep11x
    @Ep11x 5 лет назад +2

    Love your work related to PowerApps & Flow. Do you happen to know would it be possible to use local Collection with forms?

    • @Alex-bt2qv
      @Alex-bt2qv 5 лет назад +1

      Same question!

    • @ShanesCows
      @ShanesCows  5 лет назад

      Yes, forms and galleries work with any data source including Collections. :) I am pretty sure this video shows them in action. ruclips.net/video/aOcQIMvdWW4/видео.html

  • @myama9688
    @myama9688 Месяц назад +1

    Hello Shane, I have a Document library that uses a customized Content Type Document Set, I'm trying to build a App for it, but the field "Name" which holds de Folder name of an item, appear in the Form as ViewType, I cannot edit it, do you know if I can create a App for a customized Content Type Document Set ?

    • @myama9688
      @myama9688 Месяц назад

      But the way, I'm getting the error "The specified column is generated by the server and can't be specified", I think when you work with Content Type Document Set, you can't create a APP for it ?

    • @ShanesCows
      @ShanesCows  Месяц назад

      I haven't tried, sorry. But I wouldn't be surprised if you struggled. Content Types and Document sets add curve balls. :( you might have to look to the SharePoint API to do it.

  • @minstreltokunbo
    @minstreltokunbo 2 года назад

    Is it possible to add multiple forms within a form, to create a from or data. For example, you are filling a benefits form, a user has the option to add more than one beneficiary within the same form. when a user submits the form, the admin can review the form and view the multiple beneficiaries within the form.

  • @hunterbenefits
    @hunterbenefits 4 года назад +1

    I went through the steps to add a form to a new screen and when I view the screen says "no item to display". Not sure what I missed

    • @ShanesCows
      @ShanesCows  4 года назад

      Hunter you need to set the Item property of the form

    • @NelsonDiskin
      @NelsonDiskin 3 года назад

      @@ShanesCows How to do that?

  • @farderted
    @farderted 3 года назад

    Hello, do I absolutely need a data source? I just want to make a form that users submit data in.

  • @rebeccabard5483
    @rebeccabard5483 4 года назад +1

    Hey Shane! I'm running into an error for a powerapp that is tracking savings projects. For some reason every time I go to save I receive and error saying that my field that holds the savings value (number) is expecting a string and can't save. Have you seen this error before and do you know a way around it?

    • @ShanesCows
      @ShanesCows  4 года назад

      Guessing you are writing a text number instead of a number number. Try Value(textinput.text)

  • @gamingbeast7008
    @gamingbeast7008 3 года назад +1

    Hi Shane,
    SharePoint list item has a lot of fields. Instead of showing all the fields in one screen I need to show fields in tab panes is there a way to achieve that ? Thanks..

    • @ShanesCows
      @ShanesCows  3 года назад

      That is exactly this video ruclips.net/video/if_mFIfi5PM/видео.html

  • @scrosby1000
    @scrosby1000 3 года назад +1

    I've followed your exact procedure and everythings exect the image. The picture from the my sharepoint list does not get imported into powerapps. The field in the list is called photo. This doesnt even appear as a field in powerapps. its just not there, why?

    • @ShanesCows
      @ShanesCows  3 года назад

      Scott I am not sure. Weird the field doesn’t show.

  • @rochellenicholson6372
    @rochellenicholson6372 3 года назад +1

    Hi there, how do you set up your sharepoint list so that employee images show in the power app gallery. I have images of our employees in a employee sharepoint list but when I insert the gallery I do not seem to be able to show these images as you do in all of your videos.

    • @ShanesCows
      @ShanesCows  3 года назад

      I have a "Hyperlink or Picture" column in my list set to PIcture. Then for the URL I store the link to the file in a SharePoint Document library.

  • @SirajAhmad-uo1gr
    @SirajAhmad-uo1gr 2 года назад

    dear shane, you are doing great job.
    i have scenario, can you help me on this,
    i want to create form dynamically in powerapps. fields name should be taken from sp list.
    is that possible?

  • @sreeniv09
    @sreeniv09 3 года назад +1

    Is it necessary to select record from gallery or previous screen, how to get a particular record from db directly for editing and displaying. not sure if this is possible, may be take entire db rows into collection and decide which row i want to throw into the screen.. Alll the examples i have seen goes first to gallery and then edit, listview and edit view..

    • @ShanesCows
      @ShanesCows  3 года назад +1

      Store it in a variable. This video has the concept shown in a different context. ruclips.net/video/A5Pi5P2YKds/видео.html

  • @srikanthreddy191
    @srikanthreddy191 3 года назад +1

    Hi Shane thanks a lot for such a wonderful demo. I am trying to bind gallery with SharePoint list all the data is loading but image filed where I have uploaded the image in SharePoint list is not loading in image gallery of the Canvas App. Is something which I missed, please let me know.

  • @manitkantawala9104
    @manitkantawala9104 3 года назад +1

    Hey shane, what if we want to limit only one value per user. If user tries to enter another value in form, it should give an error message . How can we do that ?

    • @ShanesCows
      @ShanesCows  3 года назад +1

      You will need to write an If conditional 😎

  • @gissellemarievaldez6764
    @gissellemarievaldez6764 4 года назад +1

    Hello! I love your videos they are very helpful. I'm trying to create a survey using "forms" but the option "property and Rules " ( right top) doesn't show for me. Do you know why? Thank you in advance !

    • @ShanesCows
      @ShanesCows  4 года назад

      They have change the UI a bit. Rules got cut.

  • @ztoefy4026
    @ztoefy4026 3 года назад +1

    Hi, I'm using lists for an issue tracker and I wanted to customise the form and added additional customised data cards that contain fields I want added. How do I now use those extra fields in the form to display as a column in Lists? thanks

    • @ShanesCows
      @ShanesCows  3 года назад

      Maybe this will give you some ideas ruclips.net/video/Uuolue31t5o/видео.html

  • @sukruthakini
    @sukruthakini 2 года назад +1

    Hi Shane, I am using Sharepoint List as backend for the application developed in PowerApp. My client would like to block the direct access to sharepoint list via browser. Is there any option ?

    • @ShanesCows
      @ShanesCows  2 года назад

      They need some access. Here is one way I dealt with it. ruclips.net/video/vGSNrj82JcI/видео.html

  • @amirwayn
    @amirwayn 8 месяцев назад +1

    It did not show any where in the video how Form fields are linked to the selection on Gallery.

    • @ShanesCows
      @ShanesCows  8 месяцев назад

      When you set the Item property to Gallery.Selected that tells the form what Record to show. All of the fields are then displayed for that record.

  • @sudhakaranna2171
    @sudhakaranna2171 3 года назад +1

    Very very nice videos. I want say tanks. Dear.

  • @katakwar
    @katakwar 4 года назад +1

    Hi Shane, for some reason when I am adding a Form in edit mode and connecting to a datasource it's not displaying "text" controls. It just shows fields label and no data. Can you please suggest what might be going wrong?

    • @katakwar
      @katakwar 4 года назад +1

      I found the reason why forms are not showing controls. The table from the datasource is in read-only mode.

    • @ShanesCows
      @ShanesCows  4 года назад

      Glad you got it. 😀

  • @_Areknames_
    @_Areknames_ 4 года назад +1

    do you show ,in some of your videos ,how to create (in a form in powerApp) a dropdown menu of which the datasource is a sharepoint list? Thank you

    • @ShanesCows
      @ShanesCows  4 года назад

      Maybe this video will help. ruclips.net/video/fqH1U0_TanI/видео.html

  • @richarddiasribeiro429
    @richarddiasribeiro429 4 года назад +1

    I´ve been having an issue in which power apps generates a form containing only a given portion of my sharepoint list´s fields. Do you know why this could be happening?

    • @ShanesCows
      @ShanesCows  4 года назад

      I answered you on the other video. 😀

  • @LORD_ORiGiNALz
    @LORD_ORiGiNALz 2 года назад +1

    Hi Shane I have a question if I have custom cards in my form how can I save them if I hit "save" button?

    • @ShanesCows
      @ShanesCows  2 года назад +1

      Custom Cards are not tied to a data field so Submit form will never save them. Maybe you should consider Patch instead of forms to get the custom experience you want? This is a good intro. ruclips.net/video/MclJ_O9HvJQ/видео.html

  • @jlampman
    @jlampman 2 года назад

    Can you add data cards from different SharePoint lists to the same form on a screen?

  • @niteshism
    @niteshism 4 года назад +1

    From an edit form can I append by submitting the form instead of overwriting it?

    • @ShanesCows
      @ShanesCows  4 года назад

      Yes but you would have to write formulas to append data

  • @adriancelis9691
    @adriancelis9691 3 года назад +1

    This is awesome :)

  • @yesfours
    @yesfours 4 года назад +1

    Dear Shane YoungI followed your video. I am using a Power App Trial Version. I am connecting to Database on my laptop. I created the Gallery as you showed.When I added the Forms Edit- added the datasource same as in Gallery. It did not add the fields as you showed. I had to add the fields usig Edit Fields in the property pane. After Doing this. I am getting only the Field names.No text box to Enter or Modify data. Can you guide me the correct way to do it.Thank you in advance.Srini Singapore

    • @ShanesCows
      @ShanesCows  4 года назад

      What is your data source? If it doesn’t have a primary key PowerApps cannot edit or create records.

  • @alexandradiaz4194
    @alexandradiaz4194 4 года назад +1

    Good morning, someone knows how to insert the calendar

  • @mohammedsuheb4793
    @mohammedsuheb4793 2 года назад

    I have question.. I tried to unhide unhide image colomn in sharepoint list and uploaded the image on sharePoint page.. however i was not able to call this image on powerapp galary.. any suggestion please..

  • @chetansoni139
    @chetansoni139 3 года назад +1

    sir, can we add Multiple data source to a Single Gallery?
    i have the 4 Different SP List.
    What's the best practice, to built a form & display all the Entries in all the 4 SP List.

    • @ShanesCows
      @ShanesCows  3 года назад

      You can put the 4 lists in one collection if they data is the same (columns)

  • @WilliamHardwick
    @WilliamHardwick 5 лет назад +1

    Shane I am trying to connect my data to a SharePoint list that is not a custom list so I can start it in tablet mode, not a mobile mode, but I can't make a data connection because the list does not show? Is there a workaround for this?

    • @ShanesCows
      @ShanesCows  5 лет назад

      What type of list is it? You can use the other at the bottom of the list of lists for the SharePoint data source to add it.

    • @WilliamHardwick
      @WilliamHardwick 5 лет назад +1

      It’s a contact list. It’s the original classic list. It seems that flow or power apps won’t show these types of list in the selections, but it shows my custom list?

    • @ShanesCows
      @ShanesCows  5 лет назад

      Yes, only modern lists.

  • @kita22
    @kita22 4 года назад +1

    After my organization decided to discontinue use of SmartSheet and move to Office 365, I have been forced to learn the suite of applications quickly in order to migrate my elaborate systems to this new platform. Your videos have been amazing in my journey to master this complex web of applications...thanks! Curious if you know what formula to use if you want two toggles (yes/no) to be connected when they are located on a gallery view, and a data card view. The goal is that when it is changed on one screen, it automatically changes on the other.

    • @kita22
      @kita22 4 года назад

      Also, any idea how to use a search bar with a gallery that uses a distinct function?

    • @ShanesCows
      @ShanesCows  4 года назад

      Look at setting the default value of one to match the other.

  • @julianfolino3757
    @julianfolino3757 3 года назад +1

    Min 6:35 is there any way to grow a data card vertically without modifying the entire row height? Kind of the same horizontally but vertically

    • @ShanesCows
      @ShanesCows  3 года назад +1

      I don't think so

    • @julianfolino3757
      @julianfolino3757 3 года назад

      @@ShanesCows thank you Shane for getting back to me. I finally moved the one I wanted to grow to the botton so it wouldn't look so bad ;)

  • @SITG2023
    @SITG2023 3 года назад +1

    I am referencing some excel sheets for creating LOV in power apps. Power apps is asking me to share the excel file with the user as well. is there a better method?

    • @ShanesCows
      @ShanesCows  3 года назад +1

      Don't use Excel as a data source. 😀 Use a SharePoint list. This is a topic for a future video for sure. Excel just isn't a good app data source.

  • @jl1399
    @jl1399 2 года назад +1

    Do you have a location for the dummy pictures and the list data used in this demo?

    • @ShanesCows
      @ShanesCows  2 года назад

      I don't, I need to find a way to distribute that better.

  • @antonzhong9970
    @antonzhong9970 3 года назад +1

    Hi Shane, can you inform the Employee Details Sharepoint List structure ? or have you teach about it in earlier video ? Reason is I want to try and make the same as in this video, but I need to create that list, especially about the image, "Face" field, is it an Image column or attachment? Basically I need to know the structure and need to insert some record similar like this, first.
    Thanks

    • @ShanesCows
      @ShanesCows  3 года назад

      Face is a Hyperlink column set to picture. The files are saved in a doc library. I do need to make a video about that list. 😀

  • @wynnek2730
    @wynnek2730 5 лет назад +1

    Hi Shane, I am looking for a way to add a chart (that looks like a grid) on the PowerApps form where the user can cut multiple cells from an Excel spreadsheet and paste it in the chart within the PowerApps Form. I have been seeing instructions to upload information from excel sheets but I just want the cut and paste to work. Thanks a million.

    • @ShanesCows
      @ShanesCows  5 лет назад

      I don't have any cut and paste ideas. Sorry.