PowerApps Multiple Data Sources
Вставка
- Опубліковано 5 вер 2024
- In this video, you are going to learn about PowerApps Multiple Data Sources. You will connect your app to SharePoint and Excel data sources using OneDrive.
Link to the previous video to build the app
• Learn to connect: Powe...
For information or PowerApps consulting check out www.BoldZebras...
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!
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. 😎
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. 😀
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.
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. Without them I would never be able to understand PowerApps. I look forward for more of those.
Awe shucks! Thanks for sharing. :)
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. :)
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 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
Great video Shane - you've got a brilliant teaching style.
Thanks Dan 🐶
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
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.
Thank you! You truly have the best videos for that quick fix!
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 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!
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. :)
Hi Shane, Great Video.I was looping on this until I find your video! Thanks a lot
Awesome 😎
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. 😀
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. :(
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.
Again a great video, with great bonus info. Tabindex was just the little thing extra, that just made this video extra good!
Thanks 😊
Genius! you are helping me so much! Thanks a lot!
Glad to help. 😀
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’ve read that PowerApps can send notifications to the mobile phone user and I’m looking at hoping to be able to do that in my app. My app is for engineers to visit jobs and in each job record that user has a date and time for the job that they have to attend. It’d be great if you could use powerapps to get the mobile phone to notify the user via a pop up 1 hour before the job is due to take place as a reminder.
If you think this is doable then your asking for video ideas!!.... 😂👊
Hi Daniel. I don’t think you can get a PowerApps notification unless they have the app open. What you could do it use Flow. Have it notify them automatically.
Shane Young ok. Thanks Shane.
flow 😫😫
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, 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
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.
Thanks for sharing
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.
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.
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 :)
I will reply to your email instead of here. :)
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
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, 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.
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?
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, 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.
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, 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.
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 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 this is great video to learning power apps, it helps me lot to develop my skills
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 😅😅😅.
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
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.
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.
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, 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
thank you Shane ... you are Awesome .... Greetings from PERU
😻
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.
Shane this was awesome...Wanted to do something like this with a couple of text boxes though.....Awesome.....now to try it.
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,
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.
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
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?
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?
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 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.
IF the data sources match exactly you can sometimes do it by using an If where the data source is. BUT it never turns out very well. :(
your videos really help. thank you very much!!!
Glad to help. 😀
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
Use the Patch() function to update the second data source
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.
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, 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!
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
How did you display Favorite color along with the color value?
I think I used Choices(List.ColumnName)
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!
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, 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 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 🙂
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 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
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!
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.
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
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!
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
Thank you Shane !!! :)
You are welcome 🙏
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, Thank a lot for ur Videos.... I have one doubt, is it possible to save the updated data into NEW DATA SOURCE or TABLE ?
Yes. Use patch
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?
Yes, but I don't have a quick answer for the how. Basically you have to use a combobox and then if they don't select and item you use the Search output of the combo box. I guess I do have a quick answer. I will note this for a future video. Thanks for the idea.
@@ShanesCows Thanks for your feedback!!
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!!
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! 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.
Can PowerApp open multiple rows and columns in excel file? Like for instance there are 100 rows and 100 columns?
Should be fine.
Hi Shane, I have Project manager column (User type) in Sharepoint online and on powerapps I have project manager list that comes from excel file. I am trying to insert this into Sharepoint list but all the text/numbers values are passed to sharepoint list except for Project Manager as its User type column in the sharepoint. How do I pass text from powerapps into user field in sharepoint ? Thank you
ua-cam.com/video/gsk14D-CYRE/v-deo.html
Shane Young thank you very much Shane, your videos been like main source of information for me... are you on udemy?
Another great video. Thanks Shane you rock !
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.
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
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.
Look for my video on Relationships it should help 😀
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
It is odd for sure. I need to dig deeper but for now we at least have a workaround.
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, 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!
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.
Is it possible to pull data from an On-Premises SQL Server using customer ID and then auto populate fields? E.g.: I type customer ID (0012012) in a text box (field 1), and this auto populates a dropdown menu (field 2) which show all services of the customer. Finally, I choose a service (from the dropdown menu) and the rest of the fields are auto populated automatically. E.g. Customer name, service request date and description.
Yes. I don't have a working example but you would want to filter your dropdown. I have a video on filtering. You may have to play around with it bus conceptually this is achievable.
Thank you very much.
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. 😀
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.
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
Sorry not sure.
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.