"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.
There should be some kind of annual TH-cam Guru awards thing. In the category of "Power" Series, Shane would be the record holder for most consecutive wins. Outstanding work!
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.
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
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.
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. th-cam.com/video/BnzaSDYl8mA/w-d-xo.html
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
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
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?
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?
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.
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. th-cam.com/video/MclJ_O9HvJQ/w-d-xo.html
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?
I wish we could get more videos that actually show how these forms incorporate into Sharepoint. How the ordinary employee will fill out form information on Sharepoint and submit it WITHOUT putting the information into a list for everyone else to see. I have searched far and wide for a way to do this, but no luck.
That is the challenge of SharePoint as a data source. The user has to have access to the list. You could use Flow or the likes to move the data or use a different data source like SQL or CDS to better control access
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.
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..
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 ?
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 ?
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.
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 ?
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?
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
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
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!
Hi Shane. I have gone to SharePoint online, created a list then went to customize form. There are two data cards in there by default but I added dropdowns and field in the title card. I have saved and published the form. All the dropdowns work when clicking on them but as soon as I submit the form and go to the list to see the data I have just entered it keeps on popping up as a blank form. Please help
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 !
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.
Hi Shane....Can i Detach a datacard from a list by removing datafield value.I want to delete the datacard but deleting it breaks my whole App design. Can i detach it like this and them make it invisible.
Hi Sir I have data in Excel 20 Rows and 5 Columns (Columns and Rows may vary based on available data).I want to copy (Ctrl C) all data from excel and past (Ctrl V) into PowerApps canvas and Patch to SharePoint along with few headers in Canvas with the help of button. Request your help in this regard.
Why did you add a gallery first? I created a list in SharePoint but I need it to be a fill in form for users to submit New Service Requests and was told I should use Power Apps. This is my first view of Power Apps but I've already learned tons from this first video.
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
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?
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 ?
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,
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?
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!
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?
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
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
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?
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 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 :(
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..
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.
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?
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?
Adding Edit Form doesn't fetch the record from my table . Even if I add the datasource , it shows me that "There are no fields in this control" . But When I try binding the table with Gallery / DataTable and all , the data appears correctly. Why is it not coming in the edit form?
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
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.
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
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.
Is it normal that i don't have the gallery option. And when I connect data and select a table it connects but nothing shows up. It works for the Gallery but I can't find it on form
Hey! Shane I really admire your knowledge. I am very new in this PowerApps platform. I just wanted to know how did you manage to show those images in form gallery what is the column settings you set in SharePoint list for picture. I also tried but could not achieve it Please help.
I user the URL of the images from the doc library. Go to the doc lib, click on the image so it shows, then click the button for View Original. That is the URL you need. Should look like https //shane.sharepoint.com/sites/pa/Shared%20Documents/Adeline%20&%20Me.png
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?
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?
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?
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? th-cam.com/video/0lNK9Bx4QKE/w-d-xo.html
@@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.
How do I change the order of fields in a form, and keep the form from changing them back? I've tried to move them before, and it ignored most of my attempts, and eventually reset the position back to the original position PowerApps originally declared it should have.
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?
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?
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?
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.
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?
In my sharepoint i just upload the microsoft forms, it's the only thing in the "website". But when I select that sharepoint in powerapps (vertical galery), nothing appears. What's happen? Thanks btw for the videos, they are very good!!
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)
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?
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.
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) ?
Hey man, awesome video. I've just started working on a Power App with a D365 connector with entities such as InventoryOwners. But the automatically generated Details and Editview are giving me an error that the entity is read-only = yes. So I can't add/delete or edit any fields only view. Would you know how this could be fixed? Thanks!
@@ShanesCows I can edit the values in D365 fine but not in Power Apps. Haven't had much luck getting it to work since, but changed focus since then. Used some D365 data in for ex. dropdowns that would then send it to a SharePoint list instead. Not what I intended to create but it has been a learning experience. Thanks for the reply :)
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!
I need to introduce many Power BI visuals in a scrolling screen. My question is: Do I need to use a data card for all the Power BI visuals? or Do I have to use many data cards?? Thanks in advance.
![เจ็บที่ยังฮัก - ม่อน วรวิทย์ [ Official Mv ] จอนนี่มิวสิค](http://i.ytimg.com/vi/KALIGSRSjFs/mqdefault.jpg)
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.
Sorry but at least you found my videos. 😀 we also have proper training at PowerApps911.com
"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.
Glad it helped. So many little tricks for sure.
There should be some kind of annual TH-cam Guru awards thing. In the category of "Power" Series, Shane would be the record holder for most consecutive wins. Outstanding work!
Thanks Rick. 🐶
Cant say loud enough how helpful this tutorial is. Super helpful is an understatement. Thanks Shane!
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.
Glad to help. 😀
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
Fantastic!
Thanks Shane - Forms are so underrated and are really great for citizen developers to get their apps off the ground.
They are even if they drive me crazy.
Nice video! Your delivery is very informative but concise and to the point!!!
Thanks 😊
Shane, you're my hero. Sincerely - thank you
You are too kind! Thanks
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!
Awesome. Glad to help.
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
Awesome Marc. Thanks
Thank you this was very straightforward and helpful.
Glad to help. 😀
Awesome video. It came just in the nick of time as I have been struggling with many of the topics you addressed.
Thanks Frank! Glad to know it helped.
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.
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. th-cam.com/video/BnzaSDYl8mA/w-d-xo.html
You are great! A big fan of yours. Thank you for this video and others.
Glad to help. 😀
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
Hey Scott use the varRecord concept from this video instead of Gallery.Selected and you can overcome this common issue 😀
Excellent video and very informative. Thank you Shane.
Thanks
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
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.
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?
Check the Item property of your form. Guessing you did not set it.
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?
Not sure why you are getting that error. Sorry
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.
Try this th-cam.com/video/7XXo9wjnJvc/w-d-xo.html
Hi Shane I have a question if I have custom cards in my form how can I save them if I hit "save" button?
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. th-cam.com/video/MclJ_O9HvJQ/w-d-xo.html
Thanks a lot Shane! Awesome!
Happy to help.
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?
Guessing you are writing a text number instead of a number number. Try Value(textinput.text)
I wish we could get more videos that actually show how these forms incorporate into Sharepoint. How the ordinary employee will fill out form information on Sharepoint and submit it WITHOUT putting the information into a list for everyone else to see. I have searched far and wide for a way to do this, but no luck.
That is the challenge of SharePoint as a data source. The user has to have access to the list. You could use Flow or the likes to move the data or use a different data source like SQL or CDS to better control access
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.
I discuss this in this video th-cam.com/video/43ekj5MlNJU/w-d-xo.html
Really good informative video with some great tips
Thanks Chris
You mentioned the StarVisible part of the card, how do you actually define a field as being required?
That comes from your data source. PowerApps determines it on its own.
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..
That is exactly this video th-cam.com/video/if_mFIfi5PM/w-d-xo.html
Great video - thank you, Shane! Cheers!
Happy to help
I can’t thank you enough. You are awesome 👏🏻
You are welcome
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 ?
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 ?
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.
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 ?
They need some access. Here is one way I dealt with it. th-cam.com/video/vGSNrj82JcI/w-d-xo.html
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?
Maybe. There are lots of ways to do it. Submitting a bunch of forms can be difficult though.
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
Maybe this will give you some ideas th-cam.com/video/Uuolue31t5o/w-d-xo.html
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
Maybe this? th-cam.com/video/IvapIsBbM-U/w-d-xo.html
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!
I don’t think it is with forms.
Hi Shane. I have gone to SharePoint online, created a list then went to customize form. There are two data cards in there by default but I added dropdowns and field in the title card. I have saved and published the form. All the dropdowns work when clicking on them but as soon as I submit the form and go to the list to see the data I have just entered it keeps on popping up as a blank form. Please help
Did you add the fields?
Very informative. Thank you, Mr. Young!
Welcome!
Shane, Maybe your other videos cover this, But can you have lookup fields ? Subforms ? etc..Things you can do in MsAccess.
Repeating tables like infopath is the video to check.
Another great vid! Learning so much! THX man!
Glad to help. 😀
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 !
They have change the UI a bit. Rules got cut.
Very Helpful, Thank you
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.
Should work. Not sure.
Hi Shane....Can i Detach a datacard from a list by removing datafield value.I want to delete the datacard but deleting it breaks my whole App design. Can i detach it like this and them make it invisible.
Yes. But you should also be able to remove the card without breaking your app
Hi Sir
I have data in Excel 20 Rows and 5 Columns (Columns and Rows may vary based on available data).I want to copy (Ctrl C) all data from excel and past (Ctrl V) into PowerApps canvas and Patch to SharePoint along with few headers in Canvas with the help of button.
Request your help in this regard.
Why did you add a gallery first? I created a list in SharePoint but I need it to be a fill in form for users to submit New Service Requests and was told I should use Power Apps. This is my first view of Power Apps but I've already learned tons from this first video.
Start with my video on intro to powerapps
Hello, do I absolutely need a data source? I just want to make a form that users submit data in.
Hi Shane, I am trying to build graph in Canvas powerapp with the existing data in excel, cannot create, can you help pl/
I haven’t done a lot with with graphs. Sorry
Very very nice videos. I want say tanks. Dear.
Most welcome
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
Set the items property of the Form. 😀
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?
I found the reason why forms are not showing controls. The table from the datasource is in read-only mode.
Glad you got it. 😀
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 ?
You will need to write an If conditional 😎
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,
I think it is called PowerApps conditional formatting
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?
I answered you on the other video. 😀
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
Hunter you need to set the Item property of the form
@@ShanesCows How to do that?
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!
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?
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
Yup would make buttons that look like tabs.
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
What is your data source? If it doesn’t have a primary key PowerApps cannot edit or create records.
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?
David there are some Flow actions. That can help. Use PowerApps to send the data to Flow and have Flow do it.
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?
Forms just don't move very well. :( Sorry
@@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 :(
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..
Store it in a variable. This video has the concept shown in a different context. th-cam.com/video/A5Pi5P2YKds/w-d-xo.html
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.
Also, any idea how to use a search bar with a gallery that uses a distinct function?
Look at setting the default value of one to match the other.
Column count is in factors of 12 because that is how pages are divided in HTML5 using div tags.
Awe. Very cool, I didn’t know that. 😍
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?
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?
They have updated. If you look to the right can click fields and should be good.
Adding Edit Form doesn't fetch the record from my table . Even if I add the datasource , it shows me that "There are no fields in this control" . But When I try binding the table with Gallery / DataTable and all , the data appears correctly. Why is it not coming in the edit form?
Did you forget to set the Item property of the form?
Very useful video considering that data cards are not very intuitive and takes some effort to learn.
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
Maybe this. docs.microsoft.com/en-us/powerapps/maker/canvas-apps/add-images-pictures-audio-video
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.
I don't have any cut and paste ideas. Sorry.
Great video!
Thanks 🙏
did they update the data section ? I don't have the refresh or edit form data.
Yes. Look in View>datasource to get those settings
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
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. 😀
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
Maybe this video will help. th-cam.com/video/fqH1U0_TanI/w-d-xo.html
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?
Yes. Click on type and change to allowed type. I think I show it here but not sure. th-cam.com/video/43ekj5MlNJU/w-d-xo.html
@@ShanesCows thank you! Appreciate your quick response... You videos help a ton!
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.
You can put the 4 lists in one collection if they data is the same (columns)
Thanks again Shane!
You are welcome Bob 😊
Is it normal that i don't have the gallery option. And when I connect data and select a table it connects but nothing shows up. It works for the Gallery but I can't find it on form
That seems odd. Create a new app from data to see if it works that way.
Hey! Shane I really admire your knowledge. I am very new in this PowerApps platform. I just wanted to know how did you manage to show those images in form gallery what is the column settings you set in SharePoint list for picture. I also tried but could not achieve it Please help.
I user the URL of the images from the doc library. Go to the doc lib, click on the image so it shows, then click the button for View Original. That is the URL you need. Should look like https //shane.sharepoint.com/sites/pa/Shared%20Documents/Adeline%20&%20Me.png
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?
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?
powerapps.microsoft.com/en-us/blog/powerapps-ten-reusable-components/ they have this exact control on this post.
@@ShanesCows Great, thanks. I found it myself by more testing from your video as well!
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?
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? th-cam.com/video/0lNK9Bx4QKE/w-d-xo.html
@@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.
Do you have a location for the dummy pictures and the list data used in this demo?
I don't, I need to find a way to distribute that better.
How do I change the order of fields in a form, and keep the form from changing them back? I've tried to move them before, and it ignored most of my attempts, and eventually reset the position back to the original position PowerApps originally declared it should have.
It shouldn’t. Do you have hidden cards? I know they make forms grumpy.
@@ShanesCows Sometimes, but this happens for every form, all of the time, from the very beginning.
Sorry. Not sure why it isn’t being nice
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?
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.
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?
Yes, only modern lists.
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?
I don't think so Peter.
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.
sorry, there really isn't a drag and drop
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?
Sure. Need to use it to determine what to show them. Kind of like in this video th-cam.com/video/if_mFIfi5PM/w-d-xo.html
In my sharepoint i just upload the microsoft forms, it's the only thing in the "website". But when I select that sharepoint in powerapps (vertical galery), nothing appears. What's happen?
Thanks btw for the videos, they are very good!!
Sorry not sure I follow
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)
Try lookup instead of filter.
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?
Where are you seeing this error?
@@ShanesCows thanks for reply, I rebuilt the gallery and it now works! Weird
Good work MVP
Appreciate it
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.
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) ?
I talk about validation in this video th-cam.com/video/s85i8UWw2QM/w-d-xo.html
@@ShanesCows Thank you so much!
Hey man, awesome video. I've just started working on a Power App with a D365 connector with entities such as InventoryOwners. But the automatically generated Details and Editview are giving me an error that the entity is read-only = yes. So I can't add/delete or edit any fields only view. Would you know how this could be fixed? Thanks!
Yikes. I haven't ran into that. DId you confirm you can edit the entity and have permissions?
@@ShanesCows I can edit the values in D365 fine but not in Power Apps. Haven't had much luck getting it to work since, but changed focus since then. Used some D365 data in for ex. dropdowns that would then send it to a SharePoint list instead. Not what I intended to create but it has been a learning experience. Thanks for the reply :)
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!
I need to introduce many Power BI visuals in a scrolling screen. My question is: Do I need to use a data card for all the Power BI visuals? or Do I have to use many data cards?? Thanks in advance.
Not sure. I have never done that.
Good one 👍
Thank you! Cheers!
Hi Shane,
I want some of the fields autofilled using excel as a data source how to do that
Try starting here th-cam.com/video/-Z_13J02RPU/w-d-xo.html