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.

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.

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 !

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.

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)

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

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

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

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

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

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.

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

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.

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

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

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

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

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

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

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

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 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 this is great video to learning power apps, it helps me lot to develop my skills

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?

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

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

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

Thank you for wonderful explanation Shane, is there any possibility in powerapps to get source and destination and calculate distance automatically with map integration?

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

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)

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

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!

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

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!

Another great video. Thanks Shane you rock !

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.

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

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?

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.

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

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

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

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?

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?

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 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, I enjoy your videos, please help me here. Form | DataSources. how can one change this at run time. I have created a number of Sharepoint Lists for each of my projects to manage delegations, but these must use a single form. I am hopping to change the DataSource property name everytime a different project is selected.

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.

Hi Shane!! I have stuck into Big problem - you are the only one who can guide me... Scenario - User will raise "Access request" for Multiple users, hence I have Gallery where user select couple of checkbox and each check box is associated with label which display the access level instructions when user click check box, the problem is when i click new item, the label item values will remain same as previous item rather it should be blank by default i don't see Text property in label so that i can set default value as blank and Text value as actual Access instruction Issue is: in my Gallery when i create new item, the lable in new item is set as pervious item value instead of blank - how can i make thi snew item lable in my gallery blank?

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.

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!

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.

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, very good content. I was just wondering how would the same form work with comboboxes instead of drodowns.

Hello, sorry for my bad English, I must ask you how I should build an app that works with two data sources, one where it consumes fixed (sql) + variables (txt), then save them in another base, in this case, sharepoint ?. Thank you

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 your videos are really amazing, thanks for sharing your knowledge. I have a doubt. I have a sharepoint list with a choice column that allows the user to enter new data. It happens that when I enter this data through sharepoints I get it, but when I use powerApps through a DataCardValue this is no longer possible. Is there a solution for this?

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, 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 have a question, how do I add a filter to the color field (referring to your example) based on other column from SharePoint list?

​ Shane Young - please make a video with sharepoint lists data sources and cascaded comboboxes - editing data. thank you.

With this scenario, is it possible to enter data in Microsoft Access and still keep updated the PowerApp?

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

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

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?

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

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 ?

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

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, could you please arrange this playlist in proper order, as these are in jumbled order. Could you please help?

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.

Tip to solve an unidentified issue with this: If the list behind would contain the department ID instead of the department title i had problems on the editing - solved it by adding refresh for both datasources on the forms OnSuccess, otherwise it would have issues updateing the values.

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, 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, can we do multiple data sources in one gallery? it is possible to do so? i have multiple list but wanted to connect to one gallery. Appreciate if you can help.

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?

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.

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

Thank you sir for very good videos, sir but i am facing the same issue which you also faced, on 8.00 you wrote departments in function bar, the same thing i have done ,i have created sharepoint list called "departments" and add three row(IT,EC,CS) on title bar and connects its in powerapps and when i use it while writing in function bar, its show three rows but nothing is visible(all three rows is not visible in dropdown), i have tried 50 times but if i use "distinct(Departments,Title)" its show all three bar, why i work with distinct not without distinct

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