PowerApps Multiple Data Sources 

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.

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 )

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? :)

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.

Thank you! You truly have the best videos for that quick fix!

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.

Great videos. Without them I would never be able to understand PowerApps. I look forward for more of those.

Another great video. Thanks Shane you rock !

Hi Shane, Great Video.I was looping on this until I find your video! Thanks a lot

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 !

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

Great video Shane - you've got a brilliant teaching style.

Again a great video, with great bonus info. Tabindex was just the little thing extra, that just made this video extra good!

Genius! you are helping me so much! Thanks a lot!

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.

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.

Shane this was awesome...Wanted to do something like this with a couple of text boxes though.....Awesome.....now to try it.

thank you Shane ... you are Awesome .... Greetings from PERU

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!!!!

your videos really help. thank you very much!!!

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)

Hi Shane this is great video to learning power apps, it helps me lot to develop my skills

Thank you for share Shane!

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.

Thank you Shane !!! :)

Shane, Great Videos.

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.

Wonderful video!

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?

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?

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.

Muito bom! parabens

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

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.

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.

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.

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?

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?

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, 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.

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?

Thank you very much !

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?

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!

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 😬

Hi Shane, I have a question, when I change the data source and add a dropdown menu, I edit the yellow pop ups, I change the "Y and Update" values to match the dropdown menu name but the Update value keeps showing the yellow mark, what else should I 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?

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)

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 !

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 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?

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?

Thank you so much

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.

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. 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.

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

Hi Shane, great video! I have come across a request in my company on a competitor database through PowerApps (lists from SharePoint). So, the competitor list (list 1) includes some fields describing the company in terms of size, country and it has a multiple choice dropdown with brands (related list). The brand list (list 2) includes specifics about that product including name, price, company (list 1) and technology (related list). Technology (list 3) includes info on how that technology works, within which frequency it works, and more. In the PowerApp I want to be able to click a company name (list 1) and see multiple brands (list 2) and dive deeper into one of them from the company page. Someone with your knowledge has to know how to do this :)

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.

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, 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, 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?

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

hey shane... thanks again for the video, i have a question - how can i save / update my data in more than one sharepoint lists? can it be done by submit (form1); submit (form2) method? or there is any other way?

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 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

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

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.

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.

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! :)

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

Can I have values of dropdownlist from a comma-separated string like "red, blue, purple" not from dataSource like Excel?

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.

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?

Hey, I am not getting locked data card when I enable custom data card.

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. I tried using your Default If function but it keeps giving me an error as Name isn't valid on the EditForm1. Is this still a valid Name or identifier?

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'.

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

It is shame we can not set a drop down control to blank when we add a new item u.u Great video!!! Muchas gracias

How would I link multiple tables together by a customer ID or Prospect ID. If I wanted the user to be able to search for the customer name but when the details screen comes up it pulls info from the other tables with the same customer ID. Hopefully that makes sense, any help would be greatly appreciated.

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

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. I have an excel sheet with data in multiple sheets within them. I want to create a Power app to view the information. One sheet has the master data and others have got the related data in them. I want to give a dropdown to the user to choose one entity and the user should be able to view the information regarding the entity available on all the other sheets. I am stuck in proceeding with the app as one to many relationship needs to be created across all the master data tabs to all the other tabs. Is this possible in Powerapps? Could you please guide me on 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!

Hi Shane, When I did the same thing as you showed in the video, that if the form is in edit mode, the default value will be Parent.Default. but the default value didn't load. When I am in Edit mode, the drop down list is blank, I have to choose from the drop down list. Do you know what is wrong?

Hi, I have Multiple forms in single screen, linked to multiple tables, I want to store the new form in a single record, how is that possible, in the will be triggered from screen1, upon selecting an item in the gallery and then navigate to screen2 when clicked on a button, able to fill the form but it's not saving as a single record, help me, working in teams power apps with teams dataverse as database

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?

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])?

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?

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!

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!

Hi Shane, Thank a lot for ur Videos.... I have one doubt, is it possible to save the updated data into NEW DATA SOURCE or TABLE ?

Hi shane i am making one application using the powerapps for the hospital which is providing the tablet devices for free use and is am facing the problem in making the lookup with the column can you please help me with this.

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??

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?

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.