Dear Shane Young less than 2 weeks ago ... i had Zero Knowledge about Powerapps .. Now .. after watching your videos i built my 1st app , all my friends at work are happy because we share the same database and now we can add and edit the data very easy from anywhere anytime. a Big huge massive Thank you from me and all my friends at work :) ... in codes ... My.Mode [ If(your-videos-go-on-like-this.Mode = true,Happy,Nothappy )
These videos are sensational, 2 years on from when you published this and its the only tutorial i can find that helps with getting dropdowns to communicate changes to source data. Huge help.
Hi Shane. I love your videos and instructionals. During this lockdown period, Ive been learning a lot from you. The bit that drove me crazy with the dropdowns, was that powerapps didnt like that I typed "Dropdown1.Selected.Value". Instead, it wanted "Dropdown1.SelectedText.Value". It took me a good 1-2 hours to discover the problem.
Holy Cow! A thousand thank yous. I've been ripping my hair out for 4 days straight trying to figure out how to get my drop downs to submit to my MS SQL database. If I had only found this earlier I could be drinking and watching an Avengers movie! You are like the Captain America of Power Apps. I'm going to share this video with everyone in my company working with Power Apps. Best 22 minutes I've invested in a long time. Did I say thank you yet? :)
Shane I had very little understanding of Power Apps, Flow and their functions. Six months on as well as doing my normal day time job I am building Apps for safety where I work. You are amazing teacher please keep the education going thanks heaps
6 dislikes ... Looks like they are your real haters ! I have learnt a lot just watching your videos and helped me a lot in my job ! You have lots of examples exactly built to the questions I have around power apps ! And every time my expression is : "Damn this is exactly what I was looking for" , Your VLOGS are fun, short and to the point ! Thank you Shane !
great videos, mate. if you are looking for ideas, here is what I am currently struggling with:- doing calculations on a collection (like the sum of all item prices in a shopping cart)- get the current user to a field of the shopping cart collection to write to a people field in sharepoint- pass the shopping cart collection to flow to send an email with order information- use a flow to update inventory levels in sharepoint after an order from the shopping cart was saved- show the button to the admin screen in the shopping app only to a user with sufficient rights (in sharepoint)- use a flow action with elevated rights (higher rights than the actual user of the app)
So I am playing with some of this today. For adding up all of the values in your cart use Sum(MyCart,Cost) where MyCart is the name of my collection and Cost is the name of column. Working on sketching out a video and I think this might be what I do next. Thanks.
Great video indeed. Do you know if its possible to read and write to multiple data sources? Was interested in looking if its possible to use a single power apps with a homepage and drop down to select a data source to read data from a SharePoint list and write back to that list. Mainly for asset management over multiple sites, each site having its own asset management list.
All of the lists would have to be identical. 😑 Probably best off building functionality for one Site and then replicating it for each addtional site. There are other, crazier ways, but this will most likely get you the easiest answer.
At the 11:00 minute mark, the Default Value - Parent.Default is used. I thought I'd share what I just discovered about using a SQL lookup table for those values and the default. Parent.Default doesn't work. I did use the LookUp function to find the correct ID number and then show the correct text that matches the ID number. In the video, Department is used so something similar to this would work. LookUp('[tbl].[Department]', DepartmentID = ThisItem.DepartmentID, DepartmentName) I think this could be a good addition to a video about connecting to multiple tables in MS SQL or Azure SQL and building a three part form (browse, detail, edit). - The syntax is basically LookUp('the table that has a list of your values for the drop down', the primary key in table = ThisItem.the ID used in the card, the field that has the text) For a better example, take a look at this post: powerusers.microsoft.com/t5/General-Discussion/Drop-Downs-on-Edit-Forms-Opening-existing-record-drop-down-shows/m-p/62204/thread-id/25669/highlight/true
Thanks for sharing Mick. Doing a deeper dive with SQL is on my list and I will make sure I include this when the time comes. I will try to also give you a mention but depending on when no promises I remember. :)
Great video, Shane. You validated the process I ultimately figured out before watching the video. The one major issue I still have is that I need to pull in associated columns to the from based on the dropdown control. Specifically, I have an order from that I am adding items to. The order form and item lists are stored in SharePoint lists. I have solved the problem using SharePoint lookup fields but that prevents me from creating reports on the order table in PowerApps and PowerBI. Specifically what I am trying to do is have a drop down based on an items table and upon a selection in the dropdown, add several associated fields such as price, unit of measure, discount value etc. to other fields on the form and write the result back to the orders list in SharePoint? Hopefully that makes sense.
another great video shane, just what I needed to complete the project I started just a few hours ago creating a power app for the first time, yay! I wanted to let you know that the Data Source "+" sign was not there for me and it took a while to figure out how to add a new source. Basically it was the original process but started over. So no "+" just had to navigate to the additional source and then connect to it which is a little unintuitive when you're linking to multiple tables in the same excel file, you know? LIke you would expect maybe to be able to click on the same file, then navigate to the table within the file. So just in case you want to add a small snippet to your video for folks so they can find the second data source! thank you!!!!
Thank you for your very valuable content. In this precise case what you show at 09:23 doesn't work for me. This Control.Selected.Value gives an error at each of my attempt for a resaon I don't understand. I am not able to retrieve the information in case I edit a record. One other thing, is that I use ID to handle relationship between tables. It avoids to manipulate datas by their descirption or name. e.g If the "Human Resources" department changes to "HR", then your database still running if you handle the relationship by ID. Unfortunately you don't show this, and so far I am not able to figure out how to do it ...
Hi Shane - I am just started using power app and I am appreciating your videos they really help me :-) I am not suing the same version you use in the video but it works more or less anyway. I have a problem to write .value (Aprox 9:24 in your video) Power app will not recognize .value? can I write something else? Thanks a lot
Hello Shane. Do you have a video where I can open a form based on a drop down option? For example if I have a drop down menu that has car purchase, it opens my car inventory form or i select a boat, it opens the boat form inventory?
No but the concept is: Use the OnChange property of your dropdown. So OnChange If(Self.Selected.Value = "Boat", Navigate(BoatSCreen), Self.Selected.Value = "Car", Navigate(CarScreen) Something like that.
Hi Shane Young and to all of you reading this comment!!! I really like your tutorials, they've helped me a lot, so thank you for that!!! Ii have one little, tiny question to y'all: I'm building an app to visualize projects budgets, each project has the budget in an independent excel book, is it possible to select in real time the budget project workbook within the powerapp from a SharePoint folder and pull its data to the app? The excel files containing the budgets are manually added to the folder. Thank you very much for your help!!!! :P
To build on this video, could you explain how to use the toggle button please. I want to have the user select yes/no kind of thing. The properties that it has do not match all the dropdown ones (I can't see an "Update" property for example) thanks for the great video! I am using excel through Microsoft's cloud and I have a data connection to my firm already with partial functionality, but want to make custom cards. Thank you
Shane, your videos are very easy to understand and very helpful. I’m using 3 cascading dropdowns from one SP list. After the 3rd item is selected, I navigate to a details screen to view the selections. How can I save that information to a completely separate SP list so only what was selected is viewed in the SP list?
Great video, Shane. Having a "glow'' around your pointer would help a lot. Also, could just be me, but your pointer moves so fast, often its long-gone before I see the item you clicked. I hope my feedback has been helpful to you. I will subscribe. Your a good instructor.
Thanks for the video Shane. Super helpful. I'm working on creating a customer database for our company, and would like to be able to add multiple date stamped comments on job status day to day throughout the course of the job. Do you have a video that explains that? Thanks!
Shane, I see here we can use the multiple data sources to populate the control but the control is still saving to the first data source. Can you set the control to read and save to the 2nd datasource? Or, can you use one datasource for the gallery? If using Sharepoint lists for the datasources, can you setup a query with joins and then assign the query as the datasource for the gallery? Or, is the only option to have multiple galleries with a separate datasource for each gallery and then setup a variable and code to change the child galleries based on the selection of the first gallery? Thanks and love you videos. Looking forward to working with y'all as a new vendor at work, too!
@@ShanesCows Thanks. I should've noted that I figured out how to add extra galleries to a screen as assign the datasource to the gallery. Used what I learned from your other videos to make sure they were linked to the selected record and it works great. Thank you!
Hi Shane, great video. Not sure why you had problems with an empty row from SharePoint. It is pretty straight forward. Of cource you need to make sure that none of your fields is required to have something in it. Then you can just click the new item button and save. As it might tricky to sort, I would a specific sorting column for that.
Shane - I want to populate records into two different sharepoint lists. I want to have form 1 for Field assessment and form 2 as a contact attempt log. Form 1 poulates a SharePoint list - no issues. The breakdown I am experiencing is when I want to take the customer information from the record associated with form 1 and pass them to form 2 and have form 2, which is on a new screen that I navigate to using a button, write to a different sharepoint list. do you suggestions or a video you might recommend?
You have Form1.LastSubmit that contains your first record after you submit it. You could then use that to set defaults in form2. Might be easier to Patch the second record that manipulate a form but what you want to do is possible.
Thank you so much for this! This is super useful. What if, however, in adding a new person (so you're creating a complete new record), their favorite color is not on the list. Is it possible to have a popup or hidden form to allow the colors list to be updated and then be able to return to adding your new employee?
Yes you can! I don't remember how we did it but we figured it out during one of my Office Hour sessions at training.powerapps911.com hmmmm... how did we do it... I will try to remember. Pretty sure we had to use an HTTP action to do it.
Hello Shane, I have a powerapp and i also have create an edit form. So, the items from this form are fetched from a table in SQL DB but the dropdown is from different table which doesn't have the coloumn that i can connect it from the first table. For example Table1(form table)->Table2(have a key from Table1 and other key from Table3)->Table3(Dropdown items)
That is tough but possible. You will have to give me more details for me to help but it is possible. Just break it down into baby steps and you got it.
Hi Shane, I must be doing something wrong from the jump... I am trying to feed a combo box with either an excel sheet or list. I have my Edit Form selected, choosing View > Data Source, but I only see my single/original source available; no option to add any additional sources. I am going through the steps in this article (docs.microsoft.com/en-us/powerapps/maker/canvas-apps/connections/connection-sharepoint-online) but I do not see where I can look for a custom list to pull data from.... "Under Choose a list, select the check box for Documents or one or more lists that you want to use, and then select Connect" ... thank you in advance!! And thank you for the awesome video content. Very helpful. Thank you, Morghan
Hi Shane, how can you make the values of one drop down depend on the selection of the other and vice versa? For example, if the department selection is "Finance", the only valid color options are "Red" and "Blue"; if user selects "Blue", the department options are only "Finance", "IT", and "HR". Thanks!
Hi Shane. Thank you for the wonderful tutorial video. Would you please advise how it would be possible to select more than one item from a drop down box and add it to the related box? I appreciate that.
Thank you so much Shane, your videos are really helping me build my first powerapp. I do have a question: Is it possible to set/change the data source depending on a comb.selected.result. I have 3 combos, cb1 to select data source from List-tbl1, List-tbl2 or List-tbl3 cb2 filters cb1 selected tbl user (column1) cb3 would then filter cb2 data (column2) of the tbl. Thanks!!
Hi Shane, Lovely Video. I just want to know can we change the First screen with all the details to a checklist ? I want to have a function to select user or emailId from there and send a notification. Please let me know .
Thank you so much Shane!! Im working on an App that pulls information from a SharePoint list and used your instructions to add a couple of dropdown controls to an App that pull information from a different sharepoint list. Is there a way to sort ascending the data that Im Pulling from the different SharePoint list to my dropdowns? The data is sorted in the list, but I can't sort it in the dropdown controls.
Shane, thanks for your videos as they are helping me a lot as I am new here. I am looking for a video where toggle buttons are used with SharePoint list. Do you have any plans of doing it?
Hi Shane, I am trying to create 1 form for my employees to complete, part of it is confidential info (e.g. wellbeing check) & part i want accessible to the wider audience (e.g. systems champion for xxx) .. i am told i should separate my data into 2 lists then condense into 1 form.. for the life of me i cant seem to figure out how, i cant see that your video includes this e.g. first 10 rows are from data source 1 last 10 rows are from data source 2.
Hey Shane, thanks for the vids mate, they are awesome! One quick q if you dont mind....I have set a combobox instead of the dropdown and for Items, have used Office365Users etc so that a person from our organisation can be selected as an Approver. Have set the Update value to Combox1.Selected.Displayname but it wont update the SP column with the selection (field is from the Approver column in SP). Basically, my source is Office365 and I would like the selected entry to be written back to the SP List. Any advise would be greatly appreciated...cheers mate!
Hi Shane, Thanks so much for your video. In my powerapp I have a few dropdown list. A lot of them work fine. But when i create a new sheet and a new edit form I'm having some trouble with the drop downs defaulting to the last input I used. This is when Editing or for a new record. I'm using If(EditForm2.Mode = FormMode.Edit,Parent.Default,"Please Select") . For most of my dropdowns this works perfect except for this new sheet. Would you have any suggestions as to where i could be going wrong. Really appreciate you help!
Hi Shane, I have a question, I have managed to add the 2 data sources which are both sharepoint lists, have it going to an edit screen if new, and have a second editscreen1 for if clicked on from my display gallery. my display gallery is sourced from my second data list and a button next to it how do i make it go to the form linked to editscreen1 with the details already filled out from the gallery. So list one is where the data is stored and is the basis for the form, list 2 is pulling the details e.g. course name location and dates.
Hello Shane, do you happen to know a way to dynamically connect to a data source? Let's say I have 10 SharePoint sites with the same tables and column names and types and I want to connect to data on only one SharePoint site chosen by the user. How would you do this? It would be kind of an automation of the "Add new data source" window. Thank you!
Hi Shane, Thanks for all the guidance you have been providing thru these videos. I am stuck here. When I click the Submit button, it shows the records are updated in PowerApp, but when I go back to excel, I don't see the values captured in the main table. Probably I missed out something here.
Hi Shane! Thanks for the helpful video. In my scenario, I have cascading drop down lists tied to a second data source. I can get the Default of the first drop down list (Region) to populate no problem using the formula from the video. However, I'm not sure how to write the Default formula for the second drop down list (Operating Area) since it is dependent on the first. It keeps populating with the incorrect selection using the method in the video.
@@ShanesCows Thanks for the quick reply. I was actually able to figure it out by writing an If() formula that changes the Default based on a global variable (varFormMode) that is tied to the mode of the form. If varFormMode=New, I set it to "-", else it was set to the varRecord.'Operating Area' global variable.
Hi, in the video example, the colours and department fields existed in all the data sources. What if we need to add an entirely new card for a field that is in the second data source but not in the original data source? is that possible?
Hi Shane, as always, your videos are informative and easy to understand. You are an amazing teacher/presenter! Of your 48 PowerApps videos, I have now watched 13 of them and am working my way through the rest. This one was was SO useful. And...you knew this was coming...I'm having trouble getting the values pulled in from the Excel data source to the SharePoint list to "stick." When I create or edit a list item, I can select the item from the drop-down list and submit the form. I see the update happening in my SharePoint list. But when I go back to edit the list item in PowerApps, the Excel item is blank. I have to re-select before submitting the form. Sigh.
Hi Shane, Thanks for putting together nice videos helpful! I have a question on two lists filtering side by side. Master list has table of 700 rows and details list has 3800 rows. Is there a way to bring all the details to the gallery and apply filter by ID? Data row limit is allowed me to set as 2000. Appreciate your suggestion. Thanks!
Hi Shane, The existing sharepoint list has 40+ columns with many calculated fields adds up every fiscal year. So, re-designed by normalizing in to two different tables with a Key / ID relation to support the data to grow in rows instead of calculated columns for every fiscal year. Now the challenge is the row limit. Let me know your thoughts on this. Thanks in advance.
Hi Shane I have a question, I have a master set of tasks for every employee.I need to populate the list of questions for everyone initially from the master list. However when employees start working on their predefined tasks user data gets stored in a different Sharepoint list. At that point I will need to load the data from non master list. I look forward to your views.
Hi Shane, here is my dilemna, and not sure if you have covered anywhere. I have an Employee list in Sharepoint, and I have created a Powerapp form with a gallery and edit/new form and it all works great. There are 2 things I want to do, I want to get data from a second (and third) list in sharepoint that is matching the chosen item from the gallery. So if you choose "Chewy" then you get Chewy's data from the other lists? The second thing I want to do is only show Gallery items that are the employee looking, OR a line manager can see their whole team ( I have their line manager email and it comes from 365 userinfo) I have the details in the original data, but not the knowhow? Have you covered these issues anywhere please?
When you add a new employee is it saving to a separate SharePoint list? I want to create an app to populate a SharePoint list (List A) but have one of the data cards as a dropdown with options from a different SharePoint list (List B). Do I make the "Department" column in List A a text field?
HI Shane !!! I have one master list where i will store data ,second list with few columns which i want to have in cascading drop-down. I want to create a form connected to first list which will have cascading dropdown from second list . But Dropdown values should be stored as text in master list. How can we achive this? Or do I need to use lookup columns only?
Hi Shane your videos are excellent thank you. I am having trouble with one thing at the moment. I have created a gallery to make it look like an excel table in power apps. I have patched everything to Excel and my last column is is a drop down, which is not working (Found type 'Record'). I have the table on a different sheet like your video and my patch for the drop down is Patch(Table2,ThisItem,{'Status Code':Dropdown9.Selected}) Any ideas please? Much appreciated. Thank you!
hi Shane, thanks for the great stuff, one burning question though, if I have a SP list that I am writing to for issuing leave to the staff, all the data is getting stored in one list and other managers will see the employee request as well, how do I make sure only relavent managers get to see the requests of the staff they are managing. Shall I do another form for managers that pulls data from same list or shall I build another screen on the app. My only issue is how wil managers get to that screen then, Sorry really new to Power Apps
Hi Shane. Is it possible to make a form to be filled in PowerApps with client name then tables in different sizes like 3x10, 5x5 etcetera. Then in the future people can access that info and print PDF reports?
Thank you for wonderful explanation Shane, is there any possibility in powerapps to get source and destination and calculate distance automatically with map integration?
Hey Shane, thank you very much for all your tips ! I have a problem adding another source of data from another sharepoint list, I don't have the option "add another data source", am I looking at the wrong place ? Thank you !
Hello, may I ask, how can I make one reservation form with automatic choosing of one calendar from more calendars? Example: I have list of books on BrowseScreen. I click on item of a book and move to DetailScreen with informations about the book. I click on button which navigate to CalendarScreen for making reservation of the correct book from the list of books without dropdown menu with list of books. Thank you. tom
Hi Shane, thanks for all the videos they are great. I have a question about multiple tabs on an excel sheet....If i have 10 tabs on my excel document, each with a different table in, how can I get these to work in my app? At the moment I can only get 1 table to pull through its data into my app - is it something to do with the formulas used in the app? Please help! :)
Hey Shane, love these videos. I have two tables. One is a list of projects and their respective statuses, then the other is linked to a powerapp which allows people to log their time against each project. When they add a time card against a project, the project descriptions are displayed in a dropdown box, but all of the projects are in there. How can I only show live projects? Thanks
Hi Shane, Your videos are really great. I used this and another video of yours to create a dropdown with an Excel table as a datasource and used a filter function (as you showed in you cascading dropdowns video). the problem is that when I try to change the update field to "Dropdown1.Selected.Value" it does not allow me to use "Value" - it only allows "Result". (Dropdown1.Selected.Result) When I use "Result" it says that the proper variable should be a record , not result. I'm not sure what is wrong. Do you have any idea how to make the field update? I would really appreciate your help, Lena
What data source are you trying to write to? Also if you can only use Result did you maybe add a distinct? It doesn’t return the record just the Result.
Hi Shane, your stuff is awesome. Thank you for all that you do. I am attempting to do a single screen form, where I view and edit data. I'd like to be able to view data from one data source (sql table), but when going to edit, the dropdown selections pull from another source (a different sql table). Any thoughts?
I thought that was what was covered here? The items property of a Dropdown can be whatever you want. Try this video. I am sure it is covered here. ua-cam.com/video/jmh8eeQVAIc/v-deo.html
Hi Shane, how can I reference 2 tables data in 1 form? Is it possible? In the same screen, I use 2 forms. 1 form to display all the fields from "main" table. Then, 2nd form I want to displays all the status history (multiple records) for the ID in the 1st form. I added relationship 1 to N for the 2 tables. 1 record from main table can have more than 1 or none records in history table. Hope you can help! Thanks.
Hi Shane newbie here, thank you for sharing your knowledge to us. I just have a question, if you will going to edit the the value in a data source (ex. In sharepoint list or excel file), does it automatically update the value of the dropdown in the powerapps?, I dont know if ask a stupid question or not (Not an IT guy). I’m tring to build an app to improve our process. Thank you and God bless!
Hi Shane, I added a label to some of the card specifically for the date. I wanted it to be automatically set the date today() when somebody fill up the card but I cannot figure out the formula. Hope you can help me out. Thanks. I just put the formula today() and Everyday the date changes 😬
You are the best. I really like the way that you present your video. I have a question for you regarding the "in" operator. I have a filter statement "Filter('Assigned Sign Message', PC.Value in ["MTAEP3", "testing"]) that is working fine but the list of values are hard-coded (e.g. "MTAEP3"). Is it possible to replace with a Gallery? If so, how? Please let me know. Thank you.
Hi Shane, thanks for the video. it's very helpful. But, I am trying to insert power bi slicer values into a SQL server table through power app edit form data. is it possible each time bring slicer values into power app edit form ? Please let me know if you have any idea. Thanks.
Is it possible to add an 'IF' statement to the DataSource of a display/edit form, to allow for multiple data sources? For example "IF(ColumnChart1.Selected.TableID = "1XMAS", [@SantasTable], ColumnChart1.Selected.TableID = "2XMAS", [@RudolphsTable])?
Hi Shane. I have a question. Is it possible to add 3 icons in Canvas application in single page. By selecting each icon it should fetch data's from various table. Is that possible. By using ''Switch'' formula.
Hey Shane! Amazing Video Very helpful, i am working on huge canvas apps where it take input from 4 different lists, My question would be - Can i add Mulitple forms to single screen in Canvas app - I am unable to resize and unable to show my multiple forms - i did created a section using datacard for showing and hiding controls, but after hiding the patch remains as it is, how can i hide that hidden control patch as well, so that i can shrink my form.
You can have lots of forms but if I was you I wouldn’t use forms. I would have independent controls and then use patch. Gives you a lot more flexibility.
@@ShanesCows thanks!! but if i just use controls then how can i bind data with the controls on load? I have list of records in REACT APP, and click of itemID it should show the selected fields in a form in a custom form, i am passing item id as parameter to PowerApps Form, do you have any video which shows how to bind data to controls from sharepointlist list fields? thanks in advance!!
Hello Shane Really good video. I am trying to create app from data table where I want to select multiple values through drop down list and search for specific result or value related to that search. Is there any video for that
There isn’t. It is complicated to do. What I do is put the data table into a collection and then refine that collection each time they choose a new refiner.
Not directly but you could use an If formula everywhere you call the datasource. Haven’t done it much but not impossible as long as the lists have the same columns
HI Shane, My dropdown gets data from a very long list. scrolling is not optimal. How can I modify it to display records when I start typing. Example from your list, I start typing 'E' and only 'Executive is displayed'. Type 'M' and executive is displayed'.
Try switching to a Combo Box it allows searching but remember the searching is not delegable. This video is really old but should give the ideas ua-cam.com/video/pjs0ZsnJZXo/v-deo.html
Hi Shane, your videos are fantastic. I have manually added the items for dropdown (example for year dropdown in Items i have [" ",2020]. The problem is when i add this as Default for dropdown If(EditForm1.Mode = FormMode.Edit, Parent.Default, " ") then my add new record button in BrowseGallery1 does not work. Can you please help ?
@@ShanesCows Hi Shane, Thank you so much for your reply. Sorry but its was my typo in my last message, I have kept Items attribute for Dropdown as [" ","2020"] Similarly, I have added 7 dropdown like this manually in Items. I removed both error as you showed in your video. All other attributes are by Default. The problem is when i set this - If(EditForm1.Mode = FormMode.Edit, Parent.Default, " ") as my Default for Dropdown then my Plus (+) icon (add new record) stops working. If i do not keep this - this - If(EditForm1.Mode = FormMode.Edit, Parent.Default, " ") as my Default for Dropdown then my Pen icon (Edit) in DetailScreen1 does not work in app mode. The app is absolutely fine in Play mode. It is updating the data source (excel sheet) also but in app mode (when i use it in my mobile) the Plus (+) icon (add new record) icon in my BrowseScreen is not working. I have tried all different ways last three days but nothing is working. Realy need your help. Thanks and Regards Take care!
Thank you..very helpful. QUESTION: Is it possible to insert excel formulas I'm Power App? Example if Shane's favorite color is Purple then the next field will enter "Prince". All information will be in a sepaete table on the excel workbook ( of course). Thanks again!
Hi Shane, Thanks for Sharing. When I am creating a Dropdown from excel file table in which some columns are having less values compare to other, the empty columns also showing, how to get rid of it.
Love the Videos! Could you please make a video showing how to either export the form to a printable document or to print the form directly from PowerApps. Ideally it would look like a form when printed, not just the text mashed up into an email that can be printed. I have looked into the converting document to HTML, Saving to OneDrive, then converting it to a PDF but that is a crap solution that requires way too much time on a large scale. Thank you for the videos and I look forward to seeing more of them.
Hi Loren - There is not a print option in PowerApps today. Sorry. Best I know to offer you is the solution of making a PDF that I cover here. ua-cam.com/video/bfXV_GXc_JM/v-deo.html which sounds like you didn't like.
@@ShanesCows it is not that I did not like the solution, you did an excellent job making something functional that was not out of the box. The problem I have is with the solution on a large scale. It is not feasible to go through that process every time in a business setting. Thank you again for all you have done and hopefully Microsoft will make this a function in the future as this seems like a common issue. Why create a program for inputting forms and data but no good solution to print reports and forms based off the input data...lol
I don't know if you still reply to comments. I do have a question. So I have 2 lists in SP, 1 has username and password, the other list contains other user info such as name, address, etc. How do I put them in the same form and that when I hit button with a function Submitform, all fields gets updated/added in both SP list?
Great video. Thank you very much. Is it possible to make a video about sql on premisses. How to connect, how to read items from sql, how to update and how to write back a New item to sql.
Hi, great video, really helpful. I have copied this and added my own colours drop down which is data from a separate list and it works like yours to lookup. However, when I do the update and like in your example change it to Dropdown1.Selected.Value I just get an error "Dropdown1 = this data type is unsupported for evaluation" and it wont save the selected colour value back to the main list (the other fields add and save fine). Any ideas?
Hi Shane, Thank you for the awesome video! I have gotten far - my only problem is when trying to use data from a SharePoint list (a master file) to display the column as items to select in the dropdown - that would add data to another SharePoint list. I can get the items to appear in the drop-down, but the form fails to submit - says mwot field is required? p.s. on the data card update drop down, the only option is "DropDown1.Selected" or "DropDown1.SelectedText". There is no "DropDown1.Selected.Value " option. I really hope you can help! This is driving me nuts. Best regards, Arne
I 'm a code kiddy and enjoy creating useful VBA macros in my excel documents to do useful things. My company is expanding to office 365 and I been clue into PowerApps and can see many useful apps i would like to create and already see how to create the solutions The one scenario I haven't been able to solve is I have multiple single workbooks I would like to connect to an app, but only one at a time. If I'm working on project 123 then I want 123.xls. if working on project 789 then 789.xls. Is there a file picker to browse and select the target.xls? Or do I need to restructure the way we store the data. Currently each new project gets a new folder with subdirectories that contains multiple folders and files.
Hi Shane! Let´s say you need to register different technical parameters every time you go to visit a client by using PowerApps. So the columns (to simplify things) in the database can be: "Date", "Hour", "Parameter", "Parameter Value" (for example, one register would be "15-03-2018", "10: 00" , "Parameter1" , "10"). However, if you have 20 parameters, we need to add the same "date" and the same "hour" every time (row) in PowerApps by using the "add new register" and the "edit form". Is there a way to use the "date" and "hour" just one time for the 20 rows we need to register??
Shane hi, Is it possible to have in a dropdown 4 lists from Sharepoint? I mean, if is from voley team, shows accesories from Voley list from Sharepoint and if Is soccer team, shows me accesories from soccer list in sp too
Hi Shane, I'm following this video and when I change the value for the Update - Dropdown1.Selected.Value still has an error "Name isn't valid.This identifier isn't recognized". When I type just the Dropdown1. the first option it shows is SelectedText then I type the . and it shows 'Department (Departments)' or Value. Has anything being changed in powerapps?
Hi Shane, I have a data source as SharePoint list and added a drop down for column 'Name'. I would now like to create two input text boxes which will automatically display 'Address' and 'Phone' based on drop down 'Name' selected. How do I achieve that?
Dear Shane Young
less than 2 weeks ago ... i had Zero Knowledge about Powerapps .. Now .. after watching your videos i built my 1st app , all my friends at work are happy because we share the same database and now we can add and edit the data very easy from anywhere anytime. a Big huge massive Thank you from me and all my friends at work :) ... in codes ... My.Mode [ If(your-videos-go-on-like-this.Mode = true,Happy,Nothappy )
Awe shucks. ☺️ Thanks for sharing.
These videos are sensational, 2 years on from when you published this and its the only tutorial i can find that helps with getting dropdowns to communicate changes to source data. Huge help.
Thanks James!
Hi Shane. I love your videos and instructionals. During this lockdown period, Ive been learning a lot from you. The bit that drove me crazy with the dropdowns, was that powerapps didnt like that I typed "Dropdown1.Selected.Value". Instead, it wanted "Dropdown1.SelectedText.Value". It took me a good 1-2 hours to discover the problem.
Yeah one of the goofy things that has changed along the way. Glad you got it. 😀
Holy Cow! A thousand thank yous. I've been ripping my hair out for 4 days straight trying to figure out how to get my drop downs to submit to my MS SQL database. If I had only found this earlier I could be drinking and watching an Avengers movie! You are like the Captain America of Power Apps. I'm going to share this video with everyone in my company working with Power Apps. Best 22 minutes I've invested in a long time. Did I say thank you yet? :)
Awe shucks! Thanks for sharing. Comments like this keep me going.
Shane I had very little understanding of Power Apps, Flow and their functions. Six months on as well as doing my normal day time job I am building Apps for safety where I work. You are amazing teacher please keep the education going thanks heaps
Happy to help. Keep building and you will be a rock star before you know it. 😎
Thank you so much Shane, I spent a day trying to figure this dropdown thing out with no luck. I wish I found your video like 18 hours ago.
Sorry it took too long to find. At least you got it working. Good job.
6 dislikes ... Looks like they are your real haters ! I have learnt a lot just watching your videos and helped me a lot in my job ! You have lots of examples exactly built to the questions I have around power apps ! And every time my expression is : "Damn this is exactly what I was looking for" , Your VLOGS are fun, short and to the point ! Thank you Shane !
Thanks for the love Hemant. Haters going to hate.
great videos, mate. if you are looking for ideas, here is what I am currently struggling with:- doing calculations on a collection (like the sum of all item prices in a shopping cart)- get the current user to a field of the shopping cart collection to write to a people field in sharepoint- pass the shopping cart collection to flow to send an email with order information- use a flow to update inventory levels in sharepoint after an order from the shopping cart was saved- show the button to the admin screen in the shopping app only to a user with sufficient rights (in sharepoint)- use a flow action with elevated rights (higher rights than the actual user of the app)
Thanks for sharing. I will see if I cannot add some of these to my list of to dos. :)
So I am playing with some of this today. For adding up all of the values in your cart use Sum(MyCart,Cost) where MyCart is the name of my collection and Cost is the name of column. Working on sketching out a video and I think this might be what I do next. Thanks.
ua-cam.com/video/DF4KX1oSrVI/v-deo.html You inspired most of this video. :) Let me know what you think.
Great videos. Without them I would never be able to understand PowerApps. I look forward for more of those.
Awe shucks! Thanks for sharing. :)
Great video indeed. Do you know if its possible to read and write to multiple data sources? Was interested in looking if its possible to use a single power apps with a homepage and drop down to select a data source to read data from a SharePoint list and write back to that list. Mainly for asset management over multiple sites, each site having its own asset management list.
All of the lists would have to be identical. 😑 Probably best off building functionality for one Site and then replicating it for each addtional site. There are other, crazier ways, but this will most likely get you the easiest answer.
At the 11:00 minute mark, the Default Value - Parent.Default is used. I thought I'd share what I just discovered about using a SQL lookup table for those values and the default. Parent.Default doesn't work. I did use the LookUp function to find the correct ID number and then show the correct text that matches the ID number. In the video, Department is used so something similar to this would work. LookUp('[tbl].[Department]', DepartmentID = ThisItem.DepartmentID, DepartmentName)
I think this could be a good addition to a video about connecting to multiple tables in MS SQL or Azure SQL and building a three part form (browse, detail, edit).
- The syntax is basically LookUp('the table that has a list of your values for the drop down', the primary key in table = ThisItem.the ID used in the card, the field that has the text)
For a better example, take a look at this post: powerusers.microsoft.com/t5/General-Discussion/Drop-Downs-on-Edit-Forms-Opening-existing-record-drop-down-shows/m-p/62204/thread-id/25669/highlight/true
Thanks for sharing Mick. Doing a deeper dive with SQL is on my list and I will make sure I include this when the time comes. I will try to also give you a mention but depending on when no promises I remember. :)
Great video, Shane. You validated the process I ultimately figured out before watching the video. The one major issue I still have is that I need to pull in associated columns to the from based on the dropdown control. Specifically, I have an order from that I am adding items to. The order form and item lists are stored in SharePoint lists. I have solved the problem using SharePoint lookup fields but that prevents me from creating reports on the order table in PowerApps and PowerBI.
Specifically what I am trying to do is have a drop down based on an items table and upon a selection in the dropdown, add several associated fields such as price, unit of measure, discount value etc. to other fields on the form and write the result back to the orders list in SharePoint? Hopefully that makes sense.
This video is exactly how I do it. Comes up all the time. 😻 PowerApps AddColumns ShowColumns ua-cam.com/video/Gtzs1-IuXuY/v-deo.html
another great video shane, just what I needed to complete the project I started just a few hours ago creating a power app for the first time, yay! I wanted to let you know that the Data Source "+" sign was not there for me and it took a while to figure out how to add a new source. Basically it was the original process but started over. So no "+" just had to navigate to the additional source and then connect to it which is a little unintuitive when you're linking to multiple tables in the same excel file, you know? LIke you would expect maybe to be able to click on the same file, then navigate to the table within the file. So just in case you want to add a small snippet to your video for folks so they can find the second data source! thank you!!!!
I wish they let me note on existing videos. 😑
@@ShanesCowsis there an updated way of doing this as things don’t appear to work the same as I am trying now and can’t follow along.
Great video Shane - you've got a brilliant teaching style.
Thanks Dan 🐶
Thank you for your very valuable content.
In this precise case what you show at 09:23 doesn't work for me. This Control.Selected.Value gives an error at each of my attempt for a resaon I don't understand. I am not able to retrieve the information in case I edit a record.
One other thing, is that I use ID to handle relationship between tables. It avoids to manipulate datas by their descirption or name. e.g If the "Human Resources" department changes to "HR", then your database still running if you handle the relationship by ID.
Unfortunately you don't show this, and so far I am not able to figure out how to do it ...
Control.Selected is now .ColumnName not .Value Microsoft changed it. I have a newer video that might help. ua-cam.com/video/SKMwayf_cuM/v-deo.html
Hi Shane - I am just started using power app and I am appreciating your videos they really help me :-) I am not suing the same version you use in the video but it works more or less anyway. I have a problem to write .value (Aprox 9:24 in your video) Power app will not recognize .value? can I write something else? Thanks a lot
.ColumnName is what you need to use. 😀
Thank you! You truly have the best videos for that quick fix!
Thank you
Hi Shane, Great Video.I was looping on this until I find your video! Thanks a lot
Awesome 😎
Hello Shane. Do you have a video where I can open a form based on a drop down option? For example if I have a drop down menu that has car purchase, it opens my car inventory form or i select a boat, it opens the boat form inventory?
No but the concept is: Use the OnChange property of your dropdown. So OnChange If(Self.Selected.Value = "Boat", Navigate(BoatSCreen), Self.Selected.Value = "Car", Navigate(CarScreen)
Something like that.
Hi Shane Young and to all of you reading this comment!!! I really like your tutorials, they've helped me a lot, so thank you for that!!! Ii have one little, tiny question to y'all: I'm building an app to visualize projects budgets, each project has the budget in an independent excel book, is it possible to select in real time the budget project workbook within the powerapp from a SharePoint folder and pull its data to the app? The excel files containing the budgets are manually added to the folder. Thank you very much for your help!!!! :P
It isn’t sorry. Maybe try this to do it differently ua-cam.com/video/QcWjAt7QVn4/v-deo.html
Again a great video, with great bonus info. Tabindex was just the little thing extra, that just made this video extra good!
Thanks 😊
To build on this video, could you explain how to use the toggle button please. I want to have the user select yes/no kind of thing. The properties that it has do not match all the dropdown ones (I can't see an "Update" property for example) thanks for the great video!
I am using excel through Microsoft's cloud and I have a data connection to my firm already with partial functionality, but want to make custom cards.
Thank you
Shane, your videos are very easy to understand and very helpful. I’m using 3 cascading dropdowns from one SP list. After the 3rd item is selected, I navigate to a details screen to view the selections. How can I save that information to a completely separate SP list so only what was selected is viewed in the SP list?
Use the patch function to write the data you want.
Great videos. Do you have a video on how to share a list to sort and filter on a webpage using Power Apps?
Thank you
You cannot use Power APps on a web page, only for standalone apps. :(
Great video, Shane. Having a "glow'' around your pointer would help a lot. Also, could just be me, but your pointer moves so fast, often its long-gone before I see the item you clicked.
I hope my feedback has been helpful to you. I will subscribe. Your a good instructor.
Thanks. Good news. I did make the permanent switch to a glow around the pointer and making it bigger. :)
Thanks for the video Shane. Super helpful. I'm working on creating a customer database for our company, and would like to be able to add multiple date stamped comments on job status day to day throughout the course of the job. Do you have a video that explains that? Thanks!
Try this ua-cam.com/video/tNKcsuL72ks/v-deo.html
Shane,
I see here we can use the multiple data sources to populate the control but the control is still saving to the first data source. Can you set the control to read and save to the 2nd datasource? Or, can you use one datasource for the gallery? If using Sharepoint lists for the datasources, can you setup a query with joins and then assign the query as the datasource for the gallery? Or, is the only option to have multiple galleries with a separate datasource for each gallery and then setup a variable and code to change the child galleries based on the selection of the first gallery?
Thanks and love you videos. Looking forward to working with y'all as a new vendor at work, too!
See if this helps. 😀 ua-cam.com/video/43ekj5MlNJU/v-deo.html I think that is it.
@@ShanesCows Thanks. I should've noted that I figured out how to add extra galleries to a screen as assign the datasource to the gallery. Used what I learned from your other videos to make sure they were linked to the selected record and it works great. Thank you!
Hi Shane, great video.
Not sure why you had problems with an empty row from SharePoint. It is pretty straight forward. Of cource you need to make sure that none of your fields is required to have something in it.
Then you can just click the new item button and save. As it might tricky to sort, I would a specific sorting column for that.
Who knows what I was up to. 😀
Shane - I want to populate records into two different sharepoint lists. I want to have form 1 for Field assessment and form 2 as a contact attempt log. Form 1 poulates a SharePoint list - no issues. The breakdown I am experiencing is when I want to take the customer information from the record associated with form 1 and pass them to form 2 and have form 2, which is on a new screen that I navigate to using a button, write to a different sharepoint list. do you suggestions or a video you might recommend?
You have Form1.LastSubmit that contains your first record after you submit it. You could then use that to set defaults in form2. Might be easier to Patch the second record that manipulate a form but what you want to do is possible.
Thank you so much for this! This is super useful. What if, however, in adding a new person (so you're creating a complete new record), their favorite color is not on the list. Is it possible to have a popup or hidden form to allow the colors list to be updated and then be able to return to adding your new employee?
Yes you can! I don't remember how we did it but we figured it out during one of my Office Hour sessions at training.powerapps911.com hmmmm... how did we do it... I will try to remember. Pretty sure we had to use an HTTP action to do it.
Hello Shane,
I have a powerapp and i also have create an edit form. So, the items from this form are fetched from a table in SQL DB but the dropdown is from different table which doesn't have the coloumn that i can connect it from the first table. For example Table1(form table)->Table2(have a key from Table1 and other key from Table3)->Table3(Dropdown items)
That is tough but possible. You will have to give me more details for me to help but it is possible. Just break it down into baby steps and you got it.
Hi Shane, I must be doing something wrong from the jump... I am trying to feed a combo box with either an excel sheet or list. I have my Edit Form selected, choosing View > Data Source, but I only see my single/original source available; no option to add any additional sources. I am going through the steps in this article (docs.microsoft.com/en-us/powerapps/maker/canvas-apps/connections/connection-sharepoint-online) but I do not see where I can look for a custom list to pull data from.... "Under Choose a list, select the check box for Documents or one or more lists that you want to use, and then select Connect" ... thank you in advance!! And thank you for the awesome video content. Very helpful.
Thank you,
Morghan
Click view datasource and then in the search box type SharePoint. You should be able to add another data source that way. Sorry they changed it.
Hi Shane, how can you make the values of one drop down depend on the selection of the other and vice versa? For example, if the department selection is "Finance", the only valid color options are "Red" and "Blue"; if user selects "Blue", the department options are only "Finance", "IT", and "HR". Thanks!
I have a video on cascading dropdowns that would be the best place to start.
Hi Shane. Thank you for the wonderful tutorial video. Would you please advise how it would be possible to select more than one item from a drop down box and add it to the related box? I appreciate that.
Look at my videos on combobox and Concat. Both should help.
Thank you so much Shane, your videos are really helping me build my first powerapp.
I do have a question: Is it possible to set/change the data source depending on a comb.selected.result.
I have 3 combos, cb1 to select data source from List-tbl1, List-tbl2 or List-tbl3
cb2 filters cb1 selected tbl user (column1)
cb3 would then filter cb2 data (column2) of the tbl.
Thanks!!
YOu could do something like that as long as the columns are the same in the data sources.
Hi Shane, Lovely Video. I just want to know can we change the First screen with all the details to a checklist ? I want to have a function to select user or emailId from there and send a notification. Please let me know .
Thank you so much Shane!! Im working on an App that pulls information from a SharePoint list and used your instructions to add a couple of dropdown controls to an App that pull information from a different sharepoint list. Is there a way to sort ascending the data that Im Pulling from the different SharePoint list to my dropdowns? The data is sorted in the list, but I can't sort it in the dropdown controls.
You can use SortByColumns in the items property.
Shane, thanks for your videos as they are helping me a lot as I am new here. I am looking for a video where toggle buttons are used with SharePoint list. Do you have any plans of doing it?
Replied to your other comment. 😀
Hi Shane,
I am trying to create 1 form for my employees to complete, part of it is confidential info (e.g. wellbeing check) & part i want accessible to the wider audience (e.g. systems champion for xxx) .. i am told i should separate my data into 2 lists then condense into 1 form.. for the life of me i cant seem to figure out how, i cant see that your video includes this e.g. first 10 rows are from data source 1 last 10 rows are from data source 2.
Hey Shane, thanks for the vids mate, they are awesome! One quick q if you dont mind....I have set a combobox instead of the dropdown and for Items, have used Office365Users etc so that a person from our organisation can be selected as an Approver. Have set the Update value to Combox1.Selected.Displayname but it wont update the SP column with the selection (field is from the Approver column in SP).
Basically, my source is Office365 and I would like the selected entry to be written back to the SP List. Any advise would be greatly appreciated...cheers mate!
This video has all your answers. ua-cam.com/video/gsk14D-CYRE/v-deo.html
@@ShanesCows thank you mate!
Hi Shane,
Thanks so much for your video. In my powerapp I have a few dropdown list. A lot of them work fine. But when i create a new sheet and a new edit form I'm having some trouble with the drop downs defaulting to the last input I used. This is when Editing or for a new record. I'm using If(EditForm2.Mode = FormMode.Edit,Parent.Default,"Please Select") . For most of my dropdowns this works perfect except for this new sheet. Would you have any suggestions as to where i could be going wrong. Really appreciate you help!
You can use Reset function to set them back to default.
Hi Shane, I have a question, I have managed to add the 2 data sources which are both sharepoint lists, have it going to an edit screen if new, and have a second editscreen1 for if clicked on from my display gallery. my display gallery is sourced from my second data list and a button next to it how do i make it go to the form linked to editscreen1 with the details already filled out from the gallery. So list one is where the data is stored and is the basis for the form, list 2 is pulling the details e.g. course name location and dates.
Hello Shane, do you happen to know a way to dynamically connect to a data source? Let's say I have 10 SharePoint sites with the same tables and column names and types and I want to connect to data on only one SharePoint site chosen by the user. How would you do this? It would be kind of an automation of the "Add new data source" window. Thank you!
Not possible. Sorry.
@@ShanesCows that's a real pity! Thanks anyway! :)
Hi Shane,
Thanks for all the guidance you have been providing thru these videos. I am stuck here. When I click the Submit button, it shows the records are updated in PowerApp, but when I go back to excel, I don't see the values captured in the main table. Probably I missed out something here.
Maybe you need to refresh Excel? It should work
Genius! you are helping me so much! Thanks a lot!
Glad to help. 😀
Hi Shane! Thanks for the helpful video. In my scenario, I have cascading drop down lists tied to a second data source. I can get the Default of the first drop down list (Region) to populate no problem using the formula from the video. However, I'm not sure how to write the Default formula for the second drop down list (Operating Area) since it is dependent on the first. It keeps populating with the incorrect selection using the method in the video.
Default is text that ha to match the displayed column. Maybe see if a combobox works better as you can match records in DefaultSelectedItems
@@ShanesCows Thanks for the quick reply. I was actually able to figure it out by writing an If() formula that changes the Default based on a global variable (varFormMode) that is tied to the mode of the form. If varFormMode=New, I set it to "-", else it was set to the varRecord.'Operating Area' global variable.
Hi, in the video example, the colours and department fields existed in all the data sources. What if we need to add an entirely new card for a field that is in the second data source but not in the original data source? is that possible?
You can click the ... above the fields and add a custom card.
Hi Shane, as always, your videos are informative and easy to understand. You are an amazing teacher/presenter! Of your 48 PowerApps videos, I have now watched 13 of them and am working my way through the rest. This one was was SO useful. And...you knew this was coming...I'm having trouble getting the values pulled in from the Excel data source to the SharePoint list to "stick." When I create or edit a list item, I can select the item from the drop-down list and submit the form. I see the update happening in my SharePoint list. But when I go back to edit the list item in PowerApps, the Excel item is blank. I have to re-select before submitting the form. Sigh.
Hi Shane, Thanks for putting together nice videos helpful! I have a question on two lists filtering side by side. Master list has table of 700 rows and details list has 3800 rows. Is there a way to bring all the details to the gallery and apply filter by ID? Data row limit is allowed me to set as 2000. Appreciate your suggestion. Thanks!
That is a lot of data. Can you pair it down? If you want to combine to list you would do that in a collection.
Hi Shane, The existing sharepoint list has 40+ columns with many calculated fields adds up every fiscal year. So, re-designed by normalizing in to two different tables with a Key / ID relation to support the data to grow in rows instead of calculated columns for every fiscal year. Now the challenge is the row limit. Let me know your thoughts on this. Thanks in advance.
Shane this was awesome...Wanted to do something like this with a couple of text boxes though.....Awesome.....now to try it.
your videos really help. thank you very much!!!
Glad to help. 😀
Hi Shane I have a question, I have a master set of tasks for every employee.I need to populate the list of questions for everyone initially from the master list. However when employees start working on their predefined tasks user data gets stored in a different Sharepoint list. At that point I will need to load the data from non master list. I look forward to your views.
You can do it. Just break it down into little pieces. No problem
Hi Shane, here is my dilemna, and not sure if you have covered anywhere. I have an Employee list in Sharepoint, and I have created a Powerapp form with a gallery and edit/new form and it all works great. There are 2 things I want to do, I want to get data from a second (and third) list in sharepoint that is matching the chosen item from the gallery. So if you choose "Chewy" then you get Chewy's data from the other lists? The second thing I want to do is only show Gallery items that are the employee looking, OR a line manager can see their whole team ( I have their line manager email and it comes from 365 userinfo) I have the details in the original data, but not the knowhow? Have you covered these issues anywhere please?
Try this to help with the filtering ua-cam.com/video/-VaADTTPYmg/v-deo.html
When you add a new employee is it saving to a separate SharePoint list? I want to create an app to populate a SharePoint list (List A) but have one of the data cards as a dropdown with options from a different SharePoint list (List B). Do I make the "Department" column in List A a text field?
Yes
HI Shane !!! I have one master list where i will store data ,second list with few columns which i want to have in cascading drop-down. I want to create a form connected to first list which will have cascading dropdown from second list . But Dropdown values should be stored as text in master list. How can we achive this? Or do I need to use lookup columns only?
I have a video on cascading dropdowns that show all of this. 😀
Hi Shane your videos are excellent thank you. I am having trouble with one thing at the moment. I have created a gallery to make it look like an excel table in power apps. I have patched everything to Excel and my last column is is a drop down, which is not working (Found type 'Record').
I have the table on a different sheet like your video and my patch for the drop down is Patch(Table2,ThisItem,{'Status Code':Dropdown9.Selected})
Any ideas please? Much appreciated. Thank you!
thank you Shane ... you are Awesome .... Greetings from PERU
😻
Shane Young - please make a video with sharepoint lists data sources and cascaded comboboxes - editing data. thank you.
I will see what I can do
Hi Shane, is it ok to change the card field type to a drop down box using the abc selection field instead of manually like you did in your video?
Yes. I have just never done it but I think that would be better probably.
Hi Shane this is great video to learning power apps, it helps me lot to develop my skills
Thanks 😀
hi Shane, thanks for the great stuff, one burning question though, if I have a SP list that I am writing to for issuing leave to the staff, all the data is getting stored in one list and other managers will see the employee request as well, how do I make sure only relavent managers get to see the requests of the staff they are managing. Shall I do another form for managers that pulls data from same list or shall I build another screen on the app. My only issue is how wil managers get to that screen then, Sorry really new to Power Apps
This is tough. They can always just go around your app and access the info in SharePoint directly.
Hi Shane. Is it possible to make a form to be filled in PowerApps with client name then tables in different sizes like 3x10, 5x5 etcetera. Then in the future people can access that info and print PDF reports?
I think if you did something like my repeating table example to make the table dynamic.
Thank you for wonderful explanation Shane, is there any possibility in powerapps to get source and destination and calculate distance automatically with map integration?
We had to do this for a customer. So we did math between gps coordinates. Not easy but not to hard either.
@@ShanesCows Nice work, Can u pls explain how to achieve this? And also map should open inside powerapps itself, can it be possible?
Hey Shane, thank you very much for all your tips ! I have a problem adding another source of data from another sharepoint list, I don't have the option "add another data source", am I looking at the wrong place ?
Thank you !
In the top bar click View and then datasources. That will open the menu. Type SharePoint and then add your second list.
Hi Shane, very good content. I was just wondering how would the same form work with comboboxes instead of drodowns.
The items property works the same in dropdowns and combo boxes so I would think you should be good.
@@ShanesCows Totally, thanks man!
Hello, may I ask, how can I make one reservation form with automatic choosing of one calendar from more calendars? Example: I have list of books on BrowseScreen. I click on item of a book and move to DetailScreen with informations about the book. I click on button which navigate to CalendarScreen for making reservation of the correct book from the list of books without dropdown menu with list of books. Thank you. tom
I think this might help ua-cam.com/video/pkZG2boN7jQ/v-deo.html
Another great video. Thanks Shane you rock !
Hi Shane, thanks for all the videos they are great. I have a question about multiple tabs on an excel sheet....If i have 10 tabs on my excel document, each with a different table in, how can I get these to work in my app? At the moment I can only get 1 table to pull through its data into my app - is it something to do with the formulas used in the app? Please help! :)
Responded in other comment
Thanks Shane. I've a question. Is it possible to load the data from one sharepoint list and store the edit form data to the other sharepoint list?
Hey Shane, love these videos. I have two tables. One is a list of projects and their respective statuses, then the other is linked to a powerapp which allows people to log their time against each project. When they add a time card against a project, the project descriptions are displayed in a dropdown box, but all of the projects are in there. How can I only show live projects? Thanks
Use a filter on your items property in the Dropdown
Hi Shane,
Your videos are really great.
I used this and another video of yours to create a dropdown with an Excel table as a datasource and used a filter function (as you showed in you cascading dropdowns video).
the problem is that when I try to change the update field to "Dropdown1.Selected.Value" it does not allow me to use "Value" - it only allows "Result". (Dropdown1.Selected.Result)
When I use "Result" it says that the proper variable should be a record , not result.
I'm not sure what is wrong.
Do you have any idea how to make the field update?
I would really appreciate your help,
Lena
What data source are you trying to write to? Also if you can only use Result did you maybe add a distinct? It doesn’t return the record just the Result.
Hi Shane, your stuff is awesome. Thank you for all that you do. I am attempting to do a single screen form, where I view and edit data. I'd like to be able to view data from one data source (sql table), but when going to edit, the dropdown selections pull from another source (a different sql table). Any thoughts?
I thought that was what was covered here? The items property of a Dropdown can be whatever you want. Try this video. I am sure it is covered here. ua-cam.com/video/jmh8eeQVAIc/v-deo.html
Hi Shane, how can I reference 2 tables data in 1 form? Is it possible? In the same screen, I use 2 forms. 1 form to display all the fields from "main" table. Then, 2nd form I want to displays all the status history (multiple records) for the ID in the 1st form. I added relationship 1 to N for the 2 tables. 1 record from main table can have more than 1 or none records in history table. Hope you can help! Thanks.
Hi Shane newbie here, thank you for sharing your knowledge to us. I just have a question, if you will going to edit the the value in a data source (ex. In sharepoint list or excel file), does it automatically update the value of the dropdown in the powerapps?, I dont know if ask a stupid question or not (Not an IT guy). I’m tring to build an app to improve our process. Thank you and God bless!
Hi Melchor it will update the next time the app is opened by the user. Or if you want to update right now use the Refresh function 😀
Thank you shane!, I enjoyed watching your videos. I learned a lot from you. Extend my regards to chewy 😅😅😅.
Hi Shane, I added a label to some of the card specifically for the date. I wanted it to be automatically set the date today() when somebody fill up the card but I cannot figure out the formula. Hope you can help me out. Thanks. I just put the formula today() and Everyday the date changes 😬
Could you make a video to show how to create multiple entries in one view like an invoice type app, if at all possible with power app. Thanks Shane!!!
I think this series is exactly what you want Marcelo ua-cam.com/video/xgznk4XlPCo/v-deo.html
You are the best. I really like the way that you present your video. I have a question for you regarding the "in" operator. I have a filter statement "Filter('Assigned Sign Message', PC.Value in ["MTAEP3", "testing"]) that is working fine but the list of values are hard-coded (e.g. "MTAEP3"). Is it possible to replace with a Gallery? If so, how? Please let me know. Thank you.
Hi Shane, thanks for the video. it's very helpful. But, I am trying to insert power bi slicer values into a SQL server table through power app edit form data. is it possible each time bring slicer values into power app edit form ? Please let me know if you have any idea. Thanks.
Is it possible to add an 'IF' statement to the DataSource of a display/edit form, to allow for multiple data sources? For example "IF(ColumnChart1.Selected.TableID = "1XMAS", [@SantasTable], ColumnChart1.Selected.TableID = "2XMAS", [@RudolphsTable])?
Only if the data sources are identical. I would say bad idea. Have 2 forms and only show the form you want maybe?
Hey Shane! Can you make a video on creating rules? Or a video on restricting multiple cards to not exceed 1 but also must equal to 1?
Hey Brendy rules are deprecated so I wouldn’t recommend them. You will have to write an If statement to “do the math”
Hi Shane.
I have a question. Is it possible to add 3 icons in Canvas application in single page. By selecting each icon it should fetch data's from various table. Is that possible.
By using ''Switch'' formula.
Hey Shane! Amazing Video Very helpful, i am working on huge canvas apps where it take input from 4 different lists, My question would be
- Can i add Mulitple forms to single screen in Canvas app
- I am unable to resize and unable to show my multiple forms
- i did created a section using datacard for showing and hiding controls, but after hiding the patch remains as it is, how can i hide that hidden control patch as well, so that i can shrink my form.
You can have lots of forms but if I was you I wouldn’t use forms. I would have independent controls and then use patch. Gives you a lot more flexibility.
@@ShanesCows thanks!! but if i just use controls then how can i bind data with the controls on load?
I have list of records in REACT APP, and click of itemID it should show the selected fields in a form in a custom form, i am passing item id as parameter to PowerApps Form,
do you have any video which shows how to bind data to controls from sharepointlist list fields?
thanks in advance!!
Hello Shane
Really good video. I am trying to create app from data table where I want to select multiple values through drop down list and search for specific result or value related to that search. Is there any video for that
There isn’t. It is complicated to do. What I do is put the data table into a collection and then refine that collection each time they choose a new refiner.
Hi Shane,, I have 2 SP list Prod and Dev, is it possible to switch out the datasource in the app depending on a drop down?
hope that makes sense
Not directly but you could use an If formula everywhere you call the datasource. Haven’t done it much but not impossible as long as the lists have the same columns
HI Shane, My dropdown gets data from a very long list. scrolling is not optimal.
How can I modify it to display records when I start typing.
Example from your list, I start typing 'E' and only 'Executive is displayed'. Type 'M' and executive is displayed'.
Try switching to a Combo Box it allows searching but remember the searching is not delegable. This video is really old but should give the ideas ua-cam.com/video/pjs0ZsnJZXo/v-deo.html
Hi Shane, your videos are fantastic. I have manually added the items for dropdown (example for year dropdown in Items i have [" ",2020]. The problem is when i add this as Default for dropdown If(EditForm1.Mode = FormMode.Edit, Parent.Default, " ") then my add new record button in BrowseGallery1 does not work. Can you please help ?
I am not sure I follow. Maybe put “2020” in quotes like that instead.
@@ShanesCows
Hi Shane,
Thank you so much for your reply.
Sorry but its was my typo in my last message, I have kept Items attribute for Dropdown as [" ","2020"]
Similarly, I have added 7 dropdown like this manually in Items.
I removed both error as you showed in your video.
All other attributes are by Default.
The problem is when i set this - If(EditForm1.Mode = FormMode.Edit, Parent.Default, " ") as my Default for Dropdown then my Plus (+) icon (add new record) stops working.
If i do not keep this - this - If(EditForm1.Mode = FormMode.Edit, Parent.Default, " ") as my Default for Dropdown then my Pen icon (Edit) in DetailScreen1 does not work in app mode.
The app is absolutely fine in Play mode. It is updating the data source (excel sheet) also but in app mode (when i use it in my mobile) the Plus (+) icon (add new record) icon in my BrowseScreen is not working.
I have tried all different ways last three days but nothing is working. Realy need your help.
Thanks and Regards
Take care!
Thank you..very helpful. QUESTION: Is it possible to insert excel formulas I'm Power App? Example if Shane's favorite color is Purple then the next field will enter "Prince". All information will be in a sepaete table on the excel workbook ( of course). Thanks again!
You could build logic like that using If or LookUp to get the value. Yes.
Hi Shane, I have a question, how do I add a filter to the color field (referring to your example) based on other column from SharePoint list?
Filter(datasource, colorfield.Value = “Red”)
@@ShanesCows Thank you, Shane, it worked!
Hi Shane, Thanks for Sharing. When I am creating a Dropdown from excel file table in which some columns are having less values compare to other, the empty columns also showing, how to get rid of it.
You could filter the items?
Love the Videos! Could you please make a video showing how to either export the form to a printable document or to print the form directly from PowerApps. Ideally it would look like a form when printed, not just the text mashed up into an email that can be printed. I have looked into the converting document to HTML, Saving to OneDrive, then converting it to a PDF but that is a crap solution that requires way too much time on a large scale. Thank you for the videos and I look forward to seeing more of them.
Hi Loren - There is not a print option in PowerApps today. Sorry. Best I know to offer you is the solution of making a PDF that I cover here. ua-cam.com/video/bfXV_GXc_JM/v-deo.html which sounds like you didn't like.
@@ShanesCows it is not that I did not like the solution, you did an excellent job making something functional that was not out of the box. The problem I have is with the solution on a large scale. It is not feasible to go through that process every time in a business setting. Thank you again for all you have done and hopefully Microsoft will make this a function in the future as this seems like a common issue. Why create a program for inputting forms and data but no good solution to print reports and forms based off the input data...lol
I don't know if you still reply to comments. I do have a question. So I have 2 lists in SP, 1 has username and password, the other list contains other user info such as name, address, etc. How do I put them in the same form and that when I hit button with a function Submitform, all fields gets updated/added in both SP list?
You can’t. You will need two forms or maybe use OnSuccess of one form to update the other list.
Great video. Thank you very much. Is it possible to make a video about sql on premisses. How to connect, how to read items from sql, how to update and how to write back a New item to sql.
SQL content is on my short list.
Good day. Have you done this video? Where can I find it? Thank you
Hi, great video, really helpful. I have copied this and added my own colours drop down which is data from a separate list and it works like yours to lookup. However, when I do the update and like in your example change it to Dropdown1.Selected.Value I just get an error "Dropdown1 = this data type is unsupported for evaluation" and it wont save the selected colour value back to the main list (the other fields add and save fine). Any ideas?
That doesn’t make sense. Dropdown1.Selected.Value is not a control. 🤔
Hi Shane,
Thank you for the awesome video!
I have gotten far - my only problem is when trying to use data from a SharePoint list (a master file) to display the column as items to select in the dropdown - that would add data to another SharePoint list. I can get the items to appear in the drop-down, but the form fails to submit - says mwot field is required? p.s. on the data card update drop down, the only option is "DropDown1.Selected" or "DropDown1.SelectedText". There is no "DropDown1.Selected.Value " option. I really hope you can help! This is driving me nuts.
Best regards,
Arne
Dropdown.selected.columnname should be there.
I 'm a code kiddy and enjoy creating useful VBA macros in my excel documents to do useful things. My company is expanding to office 365 and I been clue into PowerApps and can see many useful apps i would like to create and already see how to create the solutions
The one scenario I haven't been able to solve is I have multiple single workbooks I would like to connect to an app, but only one at a time. If I'm working on project 123 then I want 123.xls. if working on project 789 then 789.xls. Is there a file picker to browse and select the target.xls? Or do I need to restructure the way we store the data. Currently each new project gets a new folder with subdirectories that contains multiple folders and files.
Restructure. And maybe look to store your data in a SharePoint list instead of Excel. 😀
With a drop down list can you start to type a value to help pick from a long drop down list.
No but you can with the combo box ua-cam.com/video/pjs0ZsnJZXo/v-deo.html
Hi Shane!
Let´s say you need to register different technical parameters every time you go to visit a client by using PowerApps. So the columns (to simplify things) in the database can be: "Date", "Hour", "Parameter", "Parameter Value" (for example, one register would be "15-03-2018", "10: 00" , "Parameter1" , "10"). However, if you have 20 parameters, we need to add the same "date" and the same "hour" every time (row) in PowerApps by using the "add new register" and the "edit form". Is there a way to use the "date" and "hour" just one time for the 20 rows we need to register??
Do you want to email me more details about what you are doing. Maybe a screenshot. See if we can figure this out. Shane.young at boldzebras.com
Hi Shane,
I sent you an email yesterday Did you receive it?
Saludos
Yes. I will try to look at it later this afternoon.
Shane hi, Is it possible to have in a dropdown 4 lists from Sharepoint? I mean, if is from voley team, shows accesories from Voley list from Sharepoint and if Is soccer team, shows me accesories from soccer list in sp too
Probably but not exactly sure your question. Email me screenshots right details? Shane at PowerApps911.com
Hi Shane, I'm following this video and when I change the value for the Update - Dropdown1.Selected.Value still has an error "Name isn't valid.This identifier isn't recognized". When I type just the Dropdown1. the first option it shows is SelectedText then I type the . and it shows 'Department (Departments)' or Value. Has anything being changed in powerapps?
Yes they change Dropdowns to use records. Dropdown.Selected.ColumnName is what you want.
Hi Shane, I have a data source as SharePoint list and added a drop down for column 'Name'. I would now like to create two input text boxes which will automatically display 'Address' and 'Phone' based on drop down 'Name' selected. How do I achieve that?
I think this helps ua-cam.com/video/43ekj5MlNJU/v-deo.html
@@ShanesCows thank you 🙂