Hello Shane. I am pretty new to powerapps and your videos are a real treasure. Keep up the excellent work even if you move on to different topics. On the moment when you delete the datacard to create a dropdown instead of it, i usually rename the datacard first to the name that makes sense, the formulas update behind, then i delete it and when i add the new drop down and rename it to what i set, voila. Errors fixed while keeping the origibal locations. Towards the end of the video you have a couple refresh issues - i solved those by addint the refresh() command for all the related databases on the forms OnSuccess function. This comes really handy when you edit an item and change the role. No refreshes needed anywhere (sometimes in the backfround if a user edited from option 1 to option 2, without refreshing the databases and immediately editted the same item he would get the old version displayed and so another save would revert the initial change). Let me know if my workarounds make sense and are good, as they might seem good to me, but as i said, new here :) still discovering.
The way you explain the concepts are amazing and interesting....... Each and every 30 mins of your videos feels a great difference in my understanding in powerapps..... You are teaching the best things in world of powerapps for free of cost is what make you difference from rest of the world. Thanks mate have a great year God bless you Thank you so much for everything from one your fan...
Thanks a lot Shane, I've been looking for this solution for 2 days. The list below is just my notes for my studies. Customizar Formulário dentro do Sharepoint para PowerApps 2:11 Apagar o campo do Card do campo que deseja conectar 3:40 Inserir um dropdown no Card 4:12 Adicionar a lista da origem dos dados que deja ir buscar 5:04 Adicionar a nova fonte de dados ao dropdown 5:45 Ajustar os erros do Card 6:57 Ajustar o campo Update 7:52 Ajustar campo Default 8:35 Ordenar as informações do Dropdown 9:18 Adicionar outras informações da lista de origem 15:45 Apagar formulário personalizado 22:53
I'm getting better Shane, thanks to you. Last week I showed to some colleagues from my company. I think they saw me like an expert hahahhaha but I'd show them your channel. You're the master!
Shane - just wanted to say THANK YOU! Your videos are the bomb and enable me to build out my convoluted PowerApps in my "spare" time. Thanks for sharing your knowledge!
Hi Shane, thanks for this, another brilliant video. I don't think you mentioned it but am I right in thinking that the user needs read access to the Departments Master List on the other SharePoint site?
Your videos have helped me through so many workflows! I can't believe I am just now (in the last couple months) finding out these exist. Not everything in 2020 is pure abysmal, after all :)
I wish I had started my attempts with watching this video first. Would have saved me literally hours of irritation. I know going forward, I'll be checking your videos first before trying to do anything I haven't before. Thank you!!
Hi Shane, thanks again for a brilliant video. I have managed to accomplish a look up but have one issue. I am looking up to a sharepoint list but on my form field the default property is not pulling through the ThisItem.’Related Project’ it’s just showing as blank. I have put a label on the data card as well and set it’s text to ThisItem.’Related Project’ and it displays fine on the label, so I know it’s there. I just can’t see it in the default of the combo box field. Any thoughts are much appreciated. Thanks
Thanks Shane. Great video. Thanks for cutting out the back and forth time. This must take you time, but it save all of us time. Which is exactly what your videos do, for us. Thank you, you are truly making me look good. I’ve advised all of our internal PowerApps champions of your channel. Many many thanks.
Hi Shane. Great video !! .. Just one question. If I want to update SharePoint list using the function "patch" what is the right syntax's for that? Thanks in advance for your help
hey, about the blank field, if it's a person/ group field, I can't have a value to be a dash. How do you work around the blank in that scenario ? Thanks great vid !
Hi Shane, great video - thank you very much for this. Is this supposed to also work if user updated the list in "edit in grid view"? I followed your steps and it works well when you add items using the "New" button, however, if I use the grid mode, it goes back to the normal Choice 1... Thanks
Hi Shane, thanks for the video it was helpful. Is it possible to look up the value of another column using power apps, the value came from different column but it will only show in one column? Thank you very much. I hope you will notice me..
Hi Shane, I’m a big fan of your work! I am new in Powerapps. According to your example I have a PowerApp that " Pulls data from a deferent sharepoint list" Instad of a Dropdown I used a ComboBox with ShowColumns. One column "Stores data" in to another "DataCardValue" by default in the same Form. Saving the Form works fine, it’s saved to the Sharepoint List. My problem is that the data won't pull back to the "ComboBox" and "DataCardValue" After saving the form, the field returns blank or empty. Do you have a tip for me to solve this? Remko
Thank you so much Shane, awesome video and very helpful!! I have one question regarding look up column. In SharePoint if we edit look up source column it will update wherever it is referenced. Please advise your thoughts on this implementing in power apps
Love it, now I go back to my ForAll>Patch>Defaults>and try it without the craziness of Lookups.... hpe that was the idea of the video, if not, why bother :), and also, although the form changed as I wanted, in the QuickEdit view it still shows the DropDown values from the column setting (typical Enter Choice #1)... is there any way to render the same connected drop down here?
Hi Shane, first thanks for the videos! I have some data that was previously based on lookup columns and I wish to move to using drop downs as you show above, however when I remove the lookup columns I lose the previous data. Would you know the best way to keep the old lookup data and still bring in the new dependant drop downs?
Is there a way to do multiselect lookups (from a related entity) in the model-driven apps mode? Single select lookups works just fine, but was wondering if you could share any guidance on that multiselect as well. Thank you.
@@ShanesCows Actually I figured that using the 'sub-grid' component is an excellent way to accomplish a multiselect lookup in a model driven app. Thank you.
Great video Shane. For the one list can you customise the SharePoint form, as in this video, and create a separate Power App for the list including the lookup column without causing issues?
Once the custom lookup column is created using this form method, can I reference it in other PowerApps using that list as a source? I've got multiple lists connected to a single PowerApp that flow like so Companies > Sites (Linked by Company Name) > Racks (Linked to Sites) > Equipment (Linked to each rack id). The problem I have with regular lookup fields is that if I add a new Company, then try to add a new site, the new company will not show up in the sites form dropdown unless an entry with that Company already exists in the sites list. I think that your solution will solve this issue, but I cannot be limited to just having the custom form in sharepoint, I need multiple forms in the same app. Sorry if this isn't clear, don't worry about responding if you don't understand. I just wanted to make sure this will work before I go in and start breaking everything to implement this. Edit: Well I put together some test lists and replicated what you did. The custom form worked in SharePoint, but when using the list again in a new PowerApp, the form uses a single line textbox instead of dropdowns... Guess it doesn't work. Back to the drawing board for me.
Sorry just getting to this. Yeah, if you make another app you would have to use the same steps to wire everythign up again. Sorry it isn't working well for you. 😕
@@ShanesCows All good! I ended up figuring out my own way to implement what I needed. Thanks for all your videos, I'd certainly be lost at my job without them!
Hi Shane, thanks for the video, learnt a great deal about powerapps with this one. However, a sharepoint Lookup function links two data tables such that if Table A looks up something in Table B and that item value in Table B changes, then the Item in Table A should also change. This video doesnt seem to have that functionality unless im missing something! Its more like a choice field from a data source rather than a lookup. Do you know if its possible to link the data sources as per a proper lookup? Thanks in advance.
Hey Shane quick question. I have a scenario similar to this. I am trying to return values from a text column from "List B" back into PowerApps Gallery text field based on the author. Both list have unique Id's. Thanks
Shane Young Hmmm. No dice. I should point out that my Gallery is pulling from a different data source in SharePoint. The value I want to pull in is in another list in share point. Apologies for the missing info. Thanks
Shane this was a great video! thanks a ton! One question: using your video example: I have the "Title" field in new data input form as a drop down controlled from a separate list on same site. However, I want the Department field to be limited based on what the user selected in the "Title" drop down field. Any thoughts if this is possible within powerapps & what the trick would be?
@@ShanesCows When I am using the Distinct(Filter..... formula it does not show the ".Selected.Value" argument at all.. It only gives me the ".Selected.Result" option. Any pointers why that might be limited to only Result instead of value?
Hi Shane. This video is spot on. I only have one question. In your example, what if there are duplicate departments (for some odd reason) that need to be filtered to only distinct entries? I tried using the Distinct function instead of sort, but that didn't work. Thanks for your guidance!
Hi Shane, I've customised my SharePoint form and it works well. However how do I handle an item in the source list for the dropdown being renamed or deleted? This doesn't immediately change existing records but the display form no longer displays the content of the lookup field as it has either been deleted or renamed. We often have the situation where we want historical records to remain unchanged but the dropdown shouldn't allow obsolete options to be selected. Is it possible to limit the options in the dropdown to a view of the source list that doesn't contain obsolete options but still have the obsolete options in the source list so that they appear in the display form but can't be selected from the dropdown? Hope that is as clear as mud :)
Sorry for the delay. It makes sense. You are either goint to have to use real LookUps or create a flow or other process that updates items when source chagnes.
AMZING - I know you made this 4 years ago but it just blew my mind and is going to potentially solve a big issue I have been trying to work around. Question though if you don't mind - I have things set up so that a column in "SharePoint List A" is looking up values from "SharePoint List B". If someone updates the value in the looked-up column in SharePoint List B, is there a way to have that value automatically updated in SharePoint List A without opening the custom Form? Always appreciate your videos! Thanks!
Hey Shane it worked really well for me. Thanks. I did something like this: Filter(Accounts; Customer.Id in Filter(CustomerAccounts; Person.Email = User().Email).ID).Title
Thanks for the video Shane. At 4:11 after I removed the textbox and added a drop down, in View mode of the form the drop down appears as a textbox with a border. It should look like a drop down. How can I fix this? Thank you again.
Dropdowns look like textboxes when they are in view mode. If you want it to look like a drop down but greyed out then you need it to be disabled, not view.
These videos are great Shane, you really seem to capture real world scenarios. Could you show one where a drop down list is controlled by another selected value in the form but the controlling column can have multiple values. For example Customers shop at multiple stores and this is recorded in a list called 'Customers' with columns 'Name' and 'Store', 'Store allows multiple entries. Another list called 'Store' has details of all the stores and has column 'Store Name'. On my form drop down when I select a Store from the 'Store' List a subsequent drop down is restricted just to those customers who had visited the store.
Hi Shane, I"m connecting to a SharePoint list that has lookup columns, however when I select the fields in PowerApps the lookup columns are not available. Another work colleague has done the same thing and it worked fine. Could it be some settings in my list or PowerApps?
Shane, I just found your videos and wanted to thank you. I didn't realize you could use powerapps for sharepoint lookup columns. What i'm trying to do is very close to what you did but with one change. I have a contract list and made the original dropdown like you did using contract name. I then want to populate another End Date column in Sharepoint from the Lookup Table so I can use calculated columns for employee contract roll off. I can do this with static date fields but can't figure out how to use the lookup so if the contract date is updated so is the sharepoint field. Any ideas are appreciated.
@@ShanesCows Thanks. I have this formula for Contract Value from Lookup table: If(SharePointForm1.Mode = FormMode.New, "-", ThisItem.Opportunity). I have LookUp('Contract List', Opportunity = Dropdown1.Selected.Opportunity, End_x0020_Date) to get the end date from the Lookup Table. What I'm trying to do is to populate the Contract End Date in the Sharepoint List.
Great video!! I'm following your steps but I started the app and then connected the SharePoint list. I have an Audit Task list that pulls the Audit using the dropdown but it doesn't show in the SharePoint Audit Task list. Is there a way to get it to show in SharePoint if I didn't start creating the app from SharePoint?
Hi Shane amazing videos! I have two sharepoint lists and i would like to get data from one sharepoint list to another (basically to copy them from sharepoint list 1 to sharepoint list 2) so i dont have users to add data twice! what formula shall i use?
I am trying to connect to another list. I have a couple questions. My list im connecting to had two columns. I am trying to use that to create cascading columns in another list.I was able to create the first column with no problems. however, my second column is throwing errors. Its stating it doesnt recognize dropdown1 in the formula when i clearly see its there. Have you seen this issue before. Also, once i have it working. How do i connect the columns to the list im creating the powerapp in? Thanks
HI Shane, your videos are fantastic. I have a question that need your help. I have a sharepoint list that i updated the department staff list. I have also created a Powerapps and connect this list to the form. I have this a Department dropdown list and from this list i filtered to the Team Staff Names. Now the difficult to me, how can i from this dropdown staff names and populate the staff email, Manager's name etc that all already in the Sharepoint list Data. Layman, i select IT, then select Mary then Mary's email address, her manager's name etc will autopopulate on the Text Input box. Please help.
How might one add a refresh button, if possible, for the Dropdown1 field after adding a new record? I've successfully created a button to create a new record using the "launch" function "on select". However, I have to exit and renter the SharePoint edit/new form in order to select a newly created record from the master list. Thank you so much for such a helpful tutorial.
Thanks Shane, great video. I was really looking for this stuff. But, in my case it is not working. My data is not getting updated for that particular field from other data source. Rest is working fine. Any idea why is it not working? I have changed the "Update" property of that field, still in SharePoint it showing as "Required Info" error.
Thanks for this video! I was wondering is there a way to lookup records in sharepoint and if the textinput box matches the Title in the record bring back the text or value to other data card or Text Input Field that are in that sharepoint record (especially if data card is sitting outside Forms/Galleries/Etc)
Great videos, saved me hours - thanks. One gotcha for people where the lookup does not work by default from SharePoint. Even with data connections to all lists, the lookups do not work if there are similar names in the Lists. Eg If you have a table named Activity and a field somewhere named Activity SharePoint seems to get mixed up
Hi, Shane! Thank you very much for all your videos, they have helped me a lot in understanding PowerApps and this video, in particular, helped me override one of lookup columns limitations which is to use lists from different sites. Another limitation that I would like to solve is the fact that lookup can only look at text, number and dates columns in other lists. Is there any way to lookup a lookup column? For instance, suppose I have three lists: a list of cars, a list of people and a list of parking tickets. The list of cars has two columns: car plate number and car owner, being car owner a lookup column to the people list. The list of tickets has three columns: ticket number, plate number and car owner. For each record, I would like to enter the ticket number manually, lookup up the plate number in the cars list and automatically fill the owner's name from the cars list. Due to the "double lookup limitation" I cannot do it. Is there a way around this, using PowerApps? (Right now I am using two separate lookups: I lookup the car's plate number in the cars list and the car owner in the people list, but this is not what I want: I need to make sure I keep the relation between the car plate number and the owner as stated in the car list). I apologize if this is confusing. Please, if you think there might be a solution I would appreciate your thoughts. Again, thank you very much for all your work and generosity.
Hello Shane,the way you explain the concepts is very good👏👏👏...could you please give me some suggestion how to iterate the collection object which has date picker,drop-down,text values and need to be stored in SharePoint lookup column...Thank you in advance 😊
Hi Shane. I know this video is old, I rewatched it to try help solve a problem I am having. I am using the lookup function in conjunction with AddColumns to essentially create a collection of data across multiple tables that can be used to export to CSV using a flow. The lookup function works as expected in a gallery, but it does not return values for the new column in the collection when using the ClearCollect function. The two functions are as below: Gallery: LookUp('Loan Requests',ID = ThisItem.Title,Number) Collection: ClearCollect(CollectionItemTrack,AddColumns(Filter('Loan Lines',ItemLoanStatus="Active"),"Number",LookUp('Loan Requests',ID = Title,Number))) Any advice as to why the lookup would work in one instance but seemingly not in the other. There are no errors other than delegation warnings coming up.
I found a solution, which doesn't really make sense to me. It seems as though in the AddColumns function you need to use the display name of the column in the lookup and I have to covert to text: The function below works: ClearCollect(CollectionItemTrack,AddColumns(Filter('Loan Lines',ItemLoanStatus="Active"),"Number",LookUp('Loan Requests',Text(ID) exactin 'Loan Lines'.'Loan Note',Number))) I'm still scratching my head...
Correction, the filter was in the wrong place and was returning the entire list. Here's the working function for anyone who might having a similar problem: ClearCollect(CollectionItemTrack,Filter(AddColumns('Loan Lines',"Number",LookUp('Loan Requests',ID = 'Loan Note',Number),"DayseOverdue",Today() - LookUp('Loan Requests',ID = 'Loan Note',ReturnDate)),ItemLoanStatus = "Active"))
Shane. I would like to seach one value between 2 columns l. ex: Column A, number 1, column B number 10 e column C name " House". If I put number 3 on one label, It return " House". What`s struture I need to use?
Shane Thanks you. I have 3 columns on Excel sheet. The first column has to start number, example: 1. Second column has final number example: 10. The third colomn has one Text, example: New York. I would like one syntax On App, if I text one number between 1 and 10, example 1, 2 ,3,4,6,6,7,8,9 or 10, result the word " New York.". I tried, Lookup, Filter and Search but It didn't work.
Thanks for an excellent tutorial. It just fit to my needs. However, your tutorial is based on a customized list form. How I can make the dropblank shown a blank option from a powerapps app. The FomeMode.New as used in your tutorial doesn't work in my app environment where I create an app from a sharepoint list. Any help please.
Can this be done in POWER AUTOMATE? I'm using MS Forms/SP List/Power Automate combination. When someone selects an office I want to look up the respective contact for that office and send them an email. Pls let me know if that's possible! Thanks 🙏
Hi Shane - thanks for showing me how to sort a converted text to dropdown button. But - can you set the sort order on a SharePoint lookup column in PowerApps? For example - I have a column in SharePoint that has: Column1 Name Column2 Order New Entry 1 In Progress 2 Reviewed 3 Approved 4 But the dropdown in Power Apps displays it in alphabetical order: Approved In Progress New Entry Reviewed Is there a way to have them displayed in column (process) order?
Hi Shane! Excellent video. Is it possible to look up department master info using Power Apps? I'm using MS Forms to collect the data, and pushing it into a SP list before doing anything else. But when a user selects an office (department), I want Power Apps to reference an excel sheet or SP site to look up the respective email address for the point of contact. Then I will extract that person's contact info using the Get user info connector. I'm stuck on this, I would be thrilled if you can point me in the right direction here! Thanks :)
Hello Shane, How would you handle a Cross Site Lookup Column that allowed a Fill in Choice that would then update the List being looked up? So if i have a list of customers that is being looked up from a orders list and find that the customer i am adding the order for does not exist in the list. I would like the to enter the Customer Name which would then also add it to the Customer List so it will be there on future orders.
I got this sorted out. I just added a new text box to the datacard to allow a fill in choice if the option they wanted was not there. I then added a button that was visible when the text box had data with a Patch function to add the fill in choice to the SharePoint List that populated the combobox.
Hi Shane, i learned a lot from this video, i was however wondering is it how to pull back more than one item in a LookUp from a ComboBox that pulls from more than one place
Hi Shane, Is there a way to enter a formula in the lookup column such as "Thisitem.ID"? I am trying to pull parent list information into child list by setting a lookup column and selecting parent ID in it. But I am getting an error : "The property on this control expects Record values. The rule produces Text Values which are incompatible" This is what I have: Default : ThisItem.Parent_ID) Update : Value(TextInput2.Text) If there is another better way to combine child and parent SP list can you please direct me to that. Thanks a lot
yes, that's what I mean.... I actually think forms will be more used than an app - at least at my work it will be - too bad they don't work in the phone app like the apps do - only in a browser......maybe in the future they will. looking fwd to the tabs vid....I will put that to use for sure
Is there a way to use your LookUp('Departments Master', Title = Dropdown1.Selected.Title, Manager) function in conjunction with Concat(ListBox1.SelectedItems,Value&"; ") . I am using a list box where users can select multiple items but instead of the pretty text in the title column, I want the to concatenate the data from the second column. Example: my list box is connected to a list with two columns, Name and Email address. The names show in the list box but my label field needs to concat the associated email addresses. Any ideas would be greatly appreciated.
Question....My form will always be in Edit Mode when updating the dropdown, but wondering how would I use the "-" as the default. My dropdown is a pulled from a separate list and I save that value to my sharepoint list form. Would I do an If Statement? If the SP field is blank, display the "-" as the default?
Hi Shane, I have a lookup column in Sharepoint List that indicates that one employee can have more than one role. However, the trouble that I am having is that in Power Apps, I do not know how to limit role column to just the one or two roles of the employee, instead, I keep getting the list of all of the roles in the company. Any ideas what to do?
Hi Shane, I know you published this video back in April so I hope you are still reviewing questions. When working with SharePoint lists in different site collections, do I need to consider permissions on the lists? In other words, can the PowerApp access lists even if the logged-in user doesn't have Edit or Contribute permissions on one of the lists? I need to create a PowerApp to intake data (Employee Award Nominations) and move the data to another list that has extremely limited permissions. The user who is entering the Employee Award Nomination data does NOT have any permissions on the second list. In SharePoint Designer, I've been able to use AppStep to elevate permissions. Is there a similar function in PowerApps or Flow? Thanks!
Love your videos. Question, the lookup values show on my powerapp form perfectly, but when I look at my list where the details drop after the information was submitted, the lookup information does not populate. Suggestions?
In this example I am not creating an actual lookup SharePoint column so I wouldn’t expect the same results. You can use patch to save any data you want though.
Shane, thank you for your videos. As a small business owner, they are incredibly helpful. I’m trying to accomplish what you’re showing us how to do in this video however I’m using a combo box. This is proving to be a disaster. Do you have another video that specifically addresses Cabo boxes in this context?
Can we use lookup function inside patch fiction? Can we use varable as columns in patch function? Can we use reference instead of putting column name in patch function? Please help if it can be done.
Hi, do you have a formula to look up a value that's not based on drop down list? For example I want to look up a part number that a user enters and retrieve it's description from a linked excel table.
Has something changed in PowerApps since this video? Or does it only for if you customise a form? Instead of an app made from scratch? When I try it, I don't get the option of Title. When I type DropDown1.Selected.Title into the Card update field I can only choose from Result or Value, neither of which work. I'm having a problem at the moment that I have a dropdown and a combobox on an edit form that pull their choice data from a separate sharepoint list. I can't figure out how to get them to save their selected data back to the main SP list. I thought i'd cracked it when I found this video, however you example won't work for me (Yes I am using a Drop down and not a Combo to follow your example :P)
Hello Shane Thankyou for posting such an amazing contents. I am writing this comment as I am facing an issue while trying to create an custom powerApp using sharepoint list as database. I have a lookup column in my list which inherits data from some another list, when i imported that lookuo column in my power apps everything seems fine, but when I am trying to submit the form [SubmitForm(form3)] is the query is am running for submitted the form. Its start showing error as DepartmentName: Field 'DepartmentName' is required Location: Button .OnSelect Can you please guide me how to resolve it as i am new to powerApps and still learning through our videos
Is it possible make it without start directly from sharepoint list ? For example create a new app then add a sharepoint list as a datasource .. Bcs I tried but it didn't work, i can not change list field with that way. Thanks for this instructive video!
@@ShanesCows Yes I did it, The column work like lookup on powerapp(edit,submit) but on sharepoint list editing page it is still single text column. Is it normal?
I have two different datsources .. SharePoint list and sql table . . My question is ..for one field in sharepoint list ..it should be filled from SQL table !! Is it possible n how ?
You have probably answered this already, and I apologize for asking it again: In this example, it appears that the contents of the Title field are being used as the foreign key in a many-to-one relationship. If two records on the One side of the relationship (that is, in the Departments table) happened to have the same text in the Title field, I would expect the lookup to fail. Is there a way around this?
I think I may have answered my own question: Does the ThisItem function select the record that we want using an actual foreign key that I can't see? That would make it work.
Hello Shane - Would you know if there have been any changes / advancements in the way PowerApps handles SharePoint Lookup Columns ( Parent / Child) relationships? The latest test I did, creating a PowerApps (not Customize Form) from a SharePoint List with a Lookup Column seemed to comprehend the Lookup Column with the PowerApps generated application / form(s).... Being such, is there a way now to integrate / include Lookup Columns in Apps built from scratch? Wanted to get your latest take... Thanx!!
I don't know Jeff. I just don't build apps with LookUp columns anymore. :( Sorry, not helpful for you but I just haven't done it in months so not sure if they changed things or not.
@@ShanesCows Hi Shane .. Completely understand not building apps with lookup columns any more ... Follow on question ... Without Lookup Columns (in SharePoint Lists), if there are 1000 existing Items and the user changes one of the "lookup spellings / values" how do your apps trickle down the update the 1000 items in the List? Manually?
So helpful. I have a very large list of Locations that I put into a ComboBox with selectmlultiple set to false, I was able to fix the Update property to be ComboBox.Selected.Title. The ComboBox, works and posts back to the SharePoint list, New/View forms work as expected. My issue comes when a user Edits a row, the Location shows the correct city from the data that was added to the list in the New form, BUT the form forces the user to re-add the location. The required setting on the location is called even though it is pulling the data from the list.
What happens if the department name changes, or a department is eliminated? If you modify the lookup list will that affect the records that have already been created using the previous dept name or using a dept that doesn’t exist anymore? If yes, how to work around that?
If that is the case you will need to look to create a proper relationship. Using something like storing the ID of the record from the other list instead of the word Department. But then you need to LookUp the name each time. It has its pros and cons.
This is a great video! I've gotten all of this to work, but I can't seem to get the lookup to work when i want to filter based on values from a multi-select field. Is that still not possible?
hi Shane! ,thank you for your toturials it help a lot, here you expalin about use lookup in drop down and it work perfectly with me, but i try use another data source value as ( list ), but no result for that , what i want to do is take the value from another datasource and show it in the table ad i click start and end time calculate time button to add the data with the name i pull it from the another dat a source to the time calculating data source !
@@ShanesCows agree my question was not clear,when i use lookup he return me only the first record from data source,is there is any other way to get all the data,so i can use it as items list in a gallery ,i hope this more clear :)
I'm a on premises SharePoint guy and want to start learning Online. I've looked through your videos and don't see a "How to get started for Online" type, basically I want to understand how you get setup with an 0365 account so I can learn PowerApps. Do you have time to make a video on that, or do you know of one?
Just a quick qeustion - what happens when someone deletes an entry from Department Master, like "IT"? Is there a way to keep the data in both lists (Employees, Department Master) somehow consistent?
Hi Shane , I learned a lot from all of your video's . Not enough unfortunately :-( One thing still puzzles me (maybe old style programmer issue) . How are relationships for sharepoint list organized> There is the lookup-field in Share point but this is hiding the mechanics for me (Giving an output column doens't say that the relationoship is based on that ) . Then you show a relation based on a Text-field so the relation is build in the app. ( Which is fine but based on a Text-Field ..... not sure I dare ) But what about the ID field : isn't that supposed to enforce the relations? Why I am asking : I try to build a filtered dropdown list for accountmanagers that can be selected in de Sales Pipe for a specific relation ) I cannot base that on name because that will never be unique.
Hi Shane, thanks for the video...I just have a little problem because my column has multiple items with the same name...when i applied distinct, it gives an error. This related to the video at 6:30. Thanks in advance for the support.
Hi Shane, Is there a way to get a different field value(like ID) rather than the Control.Selected.Result for a ComboBox. I customized the Items concatenating two fields but I intend to get the record ID and I can't seem to find the way to reference it. Thanks in advance :) and more power to you!
Thanks as always Shane! I am using a similar function in one of my apps but I would like to know if anyone has the answer to the following. Within my Sharepoint list I have columns named "1" all the way through to "100" (as well as a unique identifer in this case shop name) which helps me create a second related data table for other items in my app. My question is this, when using the Lookup fuction how can I make the "result" part of the formular pull from another element (label.text) within my app? The label text is set by a variable context based on where the user has clicked and displays a number between 1 and 100 (i.e. my column names). However when I set the ',Result' part of the formula to my label it says the data type is unsupported. Any ideas? I hope that makes sense!
Thanks Shane good video as always. Is it possible to use a lookup control in a person / group field to search only for people who appear in another list? If so, let us know how!
I don't know. I haven't tried. I will have to dig around a bit and see. So do you have the users listed in another list in a people column or just a text column?
Thank you for this video Shane, this helped me a lot. However, I currently run into a problem with my adapted version of the solution in this video and I am now at a point where I am desperate enough to ask you guys for ideas. I used a ComboBox instead of a Dropdown. Reason: I wanted to make the lookup choices searchable (~400 Articles). So far so good, my combobox works, it is searchable and it saves the values to my SP list. The problem I have now is that the articles (from the combobox) the user choses is not showing in Sharepoint when the users clicks on the list entry. Does anyone one has any suggestions?
Great video again! I feel like in this video, you were subtly making a recommendation to use separate tables for all your fields/columns that will probably be drop-down control types. like, instead of selecting Choice column in SharePoint, just set it to single text column and then create your supposed values in a separate list/table and then just let Power Apps handle the lookup and relationships. Is that best practice or you just really wanted to show that it's possible as well? I'm thinking it might be best practice because passing values to single line text is always less complicated than passing values to lookup controls (say from a gallery row to a form in edit mode).
Hello Shane.
I am pretty new to powerapps and your videos are a real treasure. Keep up the excellent work even if you move on to different topics.
On the moment when you delete the datacard to create a dropdown instead of it, i usually rename the datacard first to the name that makes sense, the formulas update behind, then i delete it and when i add the new drop down and rename it to what i set, voila. Errors fixed while keeping the origibal locations.
Towards the end of the video you have a couple refresh issues - i solved those by addint the refresh() command for all the related databases on the forms OnSuccess function. This comes really handy when you edit an item and change the role. No refreshes needed anywhere (sometimes in the backfround if a user edited from option 1 to option 2, without refreshing the databases and immediately editted the same item he would get the old version displayed and so another save would revert the initial change).
Let me know if my workarounds make sense and are good, as they might seem good to me, but as i said, new here :) still discovering.
Thanks for sharing. I try to avoid Refresh unless it is a must. Glad you got it to work. 😀
You're like an angel Shane, this is what I was looking for, the explanation is so detailed and then BOOM! The function worked perfectly. Thanks a lot!
Glad it helped!
The way you explain the concepts are amazing and interesting....... Each and every 30 mins of your videos feels a great difference in my understanding in powerapps.....
You are teaching the best things in world of powerapps for free of cost is what make you difference from rest of the world.
Thanks mate have a great year
God bless you
Thank you so much for everything from one your fan...
Thank you so much 😀
Thanks a lot Shane, I've been looking for this solution for 2 days.
The list below is just my notes for my studies.
Customizar Formulário dentro do Sharepoint para PowerApps 2:11
Apagar o campo do Card do campo que deseja conectar 3:40
Inserir um dropdown no Card 4:12
Adicionar a lista da origem dos dados que deja ir buscar 5:04
Adicionar a nova fonte de dados ao dropdown 5:45
Ajustar os erros do Card 6:57
Ajustar o campo Update 7:52
Ajustar campo Default 8:35
Ordenar as informações do Dropdown 9:18
Adicionar outras informações da lista de origem 15:45
Apagar formulário personalizado 22:53
Thanks for sharing with everyone. 😊
I'm getting better Shane, thanks to you. Last week I showed to some colleagues from my company. I think they saw me like an expert hahahhaha but I'd show them your channel. You're the master!
Fantastic! You are the one doing the hard work of learning and building. Glad it is paying off for you. Keep it up!
This is excellent stuff - please don't change a single thing. Your video's are soooo helpful. Much appreciated.
Glad to help. 😀
Shane - just wanted to say THANK YOU! Your videos are the bomb and enable me to build out my convoluted PowerApps in my "spare" time. Thanks for sharing your knowledge!
Glad to help. 😀
Thanks for an excellent tutorial. I have a droplist with some blank fields. Is it possible to ignore these blank fields?
Use Filter to remove the blank ones. Set the filter in the ITems property of the dropdown.
Hi Shane, thanks for this, another brilliant video. I don't think you mentioned it but am I right in thinking that the user needs read access to the Departments Master List on the other SharePoint site?
Correct 😎
Your videos have helped me through so many workflows! I can't believe I am just now (in the last couple months) finding out these exist. Not everything in 2020 is pure abysmal, after all :)
Thanks Kristen. 😻
Thank you Shane. That's another video from you that released me from hours of trouble.
You are welcome Hans!
Great Shane, would be impossible to make this without you.
Glad to help. 😀
I wish I had started my attempts with watching this video first. Would have saved me literally hours of irritation. I know going forward, I'll be checking your videos first before trying to do anything I haven't before. Thank you!!
Hi Shane, thanks again for a brilliant video. I have managed to accomplish a look up but have one issue. I am looking up to a sharepoint list but on my form field the default property is not pulling through the ThisItem.’Related Project’ it’s just showing as blank. I have put a label on the data card as well and set it’s text to ThisItem.’Related Project’ and it displays fine on the label, so I know it’s there. I just can’t see it in the default of the combo box field. Any thoughts are much appreciated. Thanks
Combobox DefaultSelectedItems has to return a record not text. So try doing a lookup to the same datasource as the items property
Hi Shane! So we can just redo the 'Update' field instead of using the 'Patch' function?
I don’t see why not
Thanks Shane. Great video. Thanks for cutting out the back and forth time. This must take you time, but it save all of us time. Which is exactly what your videos do, for us. Thank you, you are truly making me look good.
I’ve advised all of our internal PowerApps champions of your channel.
Many many thanks.
You just solved like 3 issues in one video :) I only wish I had seen this video sooner!
Perfect!
Hi Shane. Great video !! .. Just one question. If I want to update SharePoint list using the function "patch" what is the right syntax's for that? Thanks in advance for your help
th-cam.com/video/gsk14D-CYRE/w-d-xo.html should show you. :) Patch(SharePointList, Record you want to patch, {Column: value})
Thanks a lot Shane! your videos are very helpful and this one in particular saved me a lot of time... kind regards from Argentina
Awesome. Glad to help. 😀
hey, about the blank field, if it's a person/ group field, I can't have a value to be a dash. How do you work around the blank in that scenario ?
Thanks great vid !
Try Blank() instead?
Hi Shane, great video - thank you very much for this. Is this supposed to also work if user updated the list in "edit in grid view"? I followed your steps and it works well when you add items using the "New" button, however, if I use the grid mode, it goes back to the normal Choice 1... Thanks
It should work either way.
Hi Shane, thanks for the video it was helpful. Is it possible to look up the value of another column using power apps, the value came from different column but it will only show in one column? Thank you very much. I hope you will notice me..
Yes you can use the lookup function. I thought this video shows all of this. Maybe this one instead? th-cam.com/video/fqH1U0_TanI/w-d-xo.html
Hi Shane, I’m a big fan of your work!
I am new in Powerapps. According to your example I have a PowerApp that " Pulls data from a deferent sharepoint list" Instad of a Dropdown I used a ComboBox with ShowColumns.
One column "Stores data" in to another "DataCardValue" by default in the same Form. Saving the Form works fine, it’s saved to the Sharepoint List.
My problem is that the data won't pull back to the "ComboBox" and "DataCardValue" After saving the form, the field returns blank or empty.
Do you have a tip for me to solve this?
Remko
There is a video on combobox control.
Thank you so much Shane, awesome video and very helpful!! I have one question regarding look up column. In SharePoint if we edit look up source column it will update wherever it is referenced. Please advise your thoughts on this implementing in power apps
Love it, now I go back to my ForAll>Patch>Defaults>and try it without the craziness of Lookups.... hpe that was the idea of the video, if not, why bother :), and also, although the form changed as I wanted, in the QuickEdit view it still shows the DropDown values from the column setting (typical Enter Choice #1)... is there any way to render the same connected drop down here?
Not sure I follow. Sorry :(
Hi Shane, first thanks for the videos! I have some data that was previously based on lookup columns and I wish to move to using drop downs as you show above, however when I remove the lookup columns I lose the previous data. Would you know the best way to keep the old lookup data and still bring in the new dependant drop downs?
Not sure Max. YOu mgiht have to manually update things in SharePoint first. 😑
Is there a way to do multiselect lookups (from a related entity) in the model-driven apps mode? Single select lookups works just fine, but was wondering if you could share any guidance on that multiselect as well. Thank you.
Not sure. I don’t do much with model driven
@@ShanesCows Actually I figured that using the 'sub-grid' component is an excellent way to accomplish a multiselect lookup in a model driven app. Thank you.
Great video Shane. For the one list can you customise the SharePoint form, as in this video, and create a separate Power App for the list including the lookup column without causing issues?
Yes. You will need to connect all of the dots in your apps but to me that is better than having SharePoint connect all of them.
@@ShanesCows Excellent! Thanks very much for the quick response.
Once the custom lookup column is created using this form method, can I reference it in other PowerApps using that list as a source?
I've got multiple lists connected to a single PowerApp that flow like so Companies > Sites (Linked by Company Name) > Racks (Linked to Sites) > Equipment (Linked to each rack id).
The problem I have with regular lookup fields is that if I add a new Company, then try to add a new site, the new company will not show up in the sites form dropdown unless an entry with that Company already exists in the sites list.
I think that your solution will solve this issue, but I cannot be limited to just having the custom form in sharepoint, I need multiple forms in the same app.
Sorry if this isn't clear, don't worry about responding if you don't understand. I just wanted to make sure this will work before I go in and start breaking everything to implement this.
Edit: Well I put together some test lists and replicated what you did. The custom form worked in SharePoint, but when using the list again in a new PowerApp, the form uses a single line textbox instead of dropdowns... Guess it doesn't work. Back to the drawing board for me.
Sorry just getting to this. Yeah, if you make another app you would have to use the same steps to wire everythign up again. Sorry it isn't working well for you. 😕
@@ShanesCows All good! I ended up figuring out my own way to implement what I needed. Thanks for all your videos, I'd certainly be lost at my job without them!
Hi Shane, thanks for the video, learnt a great deal about powerapps with this one. However, a sharepoint Lookup function links two data tables such that if Table A looks up something in Table B and that item value in Table B changes, then the Item in Table A should also change. This video doesnt seem to have that functionality unless im missing something! Its more like a choice field from a data source rather than a lookup. Do you know if its possible to link the data sources as per a proper lookup? Thanks in advance.
I cover how to save to a lookup column in this video th-cam.com/video/gsk14D-CYRE/w-d-xo.html
Hey Shane quick question. I have a scenario similar to this. I am trying to return values from a text column from "List B" back into PowerApps Gallery text field based on the author. Both list have unique Id's. Thanks
You would use the LookUp function to do that. LookUp(ListB, Author = thisitem.author).textcolumn
Shane Young Hmmm. No dice. I should point out that my Gallery is pulling from a different data source in SharePoint. The value I want to pull in is in another list in share point. Apologies for the missing info. Thanks
Shane this was a great video! thanks a ton!
One question: using your video example:
I have the "Title" field in new data input form as a drop down controlled from a separate list on same site. However, I want the Department field to be limited based on what the user selected in the "Title" drop down field.
Any thoughts if this is possible within powerapps & what the trick would be?
This video th-cam.com/video/pkZG2boN7jQ/w-d-xo.html
@@ShanesCows you sir are a genius!!
@@ShanesCows When I am using the Distinct(Filter..... formula it does not show the ".Selected.Value" argument at all.. It only gives me the ".Selected.Result" option.
Any pointers why that might be limited to only Result instead of value?
Hi Shane. This video is spot on. I only have one question. In your example, what if there are duplicate departments (for some odd reason) that need to be filtered to only distinct entries? I tried using the Distinct function instead of sort, but that didn't work. Thanks for your guidance!
Distinct should work. Not sure why it didn’t for you
Hi Shane, I've customised my SharePoint form and it works well. However how do I handle an item in the source list for the dropdown being renamed or deleted? This doesn't immediately change existing records but the display form no longer displays the content of the lookup field as it has either been deleted or renamed. We often have the situation where we want historical records to remain unchanged but the dropdown shouldn't allow obsolete options to be selected. Is it possible to limit the options in the dropdown to a view of the source list that doesn't contain obsolete options but still have the obsolete options in the source list so that they appear in the display form but can't be selected from the dropdown? Hope that is as clear as mud :)
Sorry for the delay. It makes sense. You are either goint to have to use real LookUps or create a flow or other process that updates items when source chagnes.
AMZING - I know you made this 4 years ago but it just blew my mind and is going to potentially solve a big issue I have been trying to work around. Question though if you don't mind - I have things set up so that a column in "SharePoint List A" is looking up values from "SharePoint List B". If someone updates the value in the looked-up column in SharePoint List B, is there a way to have that value automatically updated in SharePoint List A without opening the custom Form?
Always appreciate your videos! Thanks!
Hi Shane thank you so much for this, how do select multiple items in lookup column like the OOTB lookup column?
Thanks again, Shane. I've been trying to realise a m:n-relation for about two weeks now. Lookup-Columns ruined my day. I think your way should work.
They are nasty for sure. Let me know how this turns out for you.
Hey Shane it worked really well for me. Thanks. I did something like this:
Filter(Accounts; Customer.Id in Filter(CustomerAccounts; Person.Email = User().Email).ID).Title
Thanks for the video Shane. At 4:11 after I removed the textbox and added a drop down, in View mode of the form the drop down appears as a textbox with a border. It should look like a drop down. How can I fix this? Thank you again.
Dropdowns look like textboxes when they are in view mode. If you want it to look like a drop down but greyed out then you need it to be disabled, not view.
@@ShanesCows thanks I'll try that out.
These videos are great Shane, you really seem to capture real world scenarios.
Could you show one where a drop down list is controlled by another selected value in the form but the controlling column can have multiple values. For example Customers shop at multiple stores and this is recorded in a list called 'Customers' with columns 'Name' and 'Store', 'Store allows multiple entries. Another list called 'Store' has details of all the stores and has column 'Store Name'. On my form drop down when I select a Store from the 'Store' List a subsequent drop down is restricted just to those customers who had visited the store.
This video may get you pointed in the right direction. th-cam.com/video/SKMwayf_cuM/w-d-xo.html
@@ShanesCows thanks shane 👍
Hi Shane, I"m connecting to a SharePoint list that has lookup columns, however when I select the fields in PowerApps the lookup columns are not available. Another work colleague has done the same thing and it worked fine. Could it be some settings in my list or PowerApps?
Try and see if this video helps understand the fact lookup columns are records. They are a pain. th-cam.com/video/gsk14D-CYRE/w-d-xo.html
Shane, I just found your videos and wanted to thank you. I didn't realize you could use powerapps for sharepoint lookup columns. What i'm trying to do is very close to what you did but with one change. I have a contract list and made the original dropdown like you did using contract name. I then want to populate another End Date column in Sharepoint from the Lookup Table so I can use calculated columns for employee contract roll off. I can do this with static date fields but can't figure out how to use the lookup so if the contract date is updated so is the sharepoint field. Any ideas are appreciated.
Hey Brad leave a new comment with your formula and error and I will try to help.
@@ShanesCows Thanks. I have this formula for Contract Value from Lookup table: If(SharePointForm1.Mode = FormMode.New, "-", ThisItem.Opportunity). I have LookUp('Contract List', Opportunity = Dropdown1.Selected.Opportunity, End_x0020_Date) to get the end date from the Lookup Table. What I'm trying to do is to populate the Contract End Date in the Sharepoint List.
Great video!! I'm following your steps but I started the app and then connected the SharePoint list. I have an Audit Task list that pulls the Audit using the dropdown but it doesn't show in the SharePoint Audit Task list. Is there a way to get it to show in SharePoint if I didn't start creating the app from SharePoint?
There is a video called save data SharePoint or something like that. I think it will help
Thanks for the video, very informative, useful, and entertaining! Nice way to learn :)
Thanks Melinda 🐶
Hi Shane amazing videos! I have two sharepoint lists and i would like to get data from one sharepoint list to another (basically to copy them from sharepoint list 1 to sharepoint list 2) so i dont have users to add data twice! what formula shall i use?
I would use Flow to copy data from one list to the other. There are other ways also.
Thank you, Shane! Excellent video!
Glad to help. 😀
I am trying to connect to another list. I have a couple questions. My list im connecting to had two columns. I am trying to use that to create cascading columns in another list.I was able to create the first column with no problems. however, my second column is throwing errors. Its stating it doesnt recognize dropdown1 in the formula when i clearly see its there. Have you seen this issue before. Also, once i have it working. How do i connect the columns to the list im creating the powerapp in? Thanks
Maybe cascading video will help th-cam.com/video/pkZG2boN7jQ/w-d-xo.html
HI Shane, your videos are fantastic. I have a question that need your help. I have a sharepoint list that i updated the department staff list. I have also created a Powerapps and connect this list to the form. I have this a Department dropdown list and from this list i filtered to the Team Staff Names. Now the difficult to me, how can i from this dropdown staff names and populate the staff email, Manager's name etc that all already in the Sharepoint list Data. Layman, i select IT, then select Mary then Mary's email address, her manager's name etc will autopopulate on the Text Input box. Please help.
How might one add a refresh button, if possible, for the Dropdown1 field after adding a new record? I've successfully created a button to create a new record using the "launch" function "on select". However, I have to exit and renter the SharePoint edit/new form in order to select a newly created record from the master list. Thank you so much for such a helpful tutorial.
Refresh(SharePointList) should do it.
Thanks Shane, great video. I was really looking for this stuff. But, in my case it is not working. My data is not getting updated for that particular field from other data source. Rest is working fine. Any idea why is it not working? I have changed the "Update" property of that field, still in SharePoint it showing as "Required Info" error.
I covered this in my latest video where I answer comments and yours was one of them. 😀 th-cam.com/video/8eoaSsXnh6Q/w-d-xo.html
Thanks for this video! I was wondering is there a way to lookup records in sharepoint and if the textinput box matches the Title in the record bring back the text or value to other data card or Text Input Field that are in that sharepoint record (especially if data card is sitting outside Forms/Galleries/Etc)
Yes. You can use the LookUp function to get the text. th-cam.com/video/W5Z61Q9Rehs/w-d-xo.html
@@ShanesCows thanks Shane eventually I did find that video!
Great videos, saved me hours - thanks. One gotcha for people where the lookup does not work by default from SharePoint.
Even with data connections to all lists, the lookups do not work if there are similar names in the Lists.
Eg If you have a table named Activity and a field somewhere named Activity
SharePoint seems to get mixed up
Thanks for sharing.
Thank you Shane for the excellent video. This is exactly what I was looking for.
Awesome!
Hi, Shane! Thank you very much for all your videos, they have helped me a lot in understanding PowerApps and this video, in particular, helped me override one of lookup columns limitations which is to use lists from different sites. Another limitation that I would like to solve is the fact that lookup can only look at text, number and dates columns in other lists. Is there any way to lookup a lookup column?
For instance, suppose I have three lists: a list of cars, a list of people and a list of parking tickets. The list of cars has two columns: car plate number and car owner, being car owner a lookup column to the people list. The list of tickets has three columns: ticket number, plate number and car owner. For each record, I would like to enter the ticket number manually, lookup up the plate number in the cars list and automatically fill the owner's name from the cars list. Due to the "double lookup limitation" I cannot do it. Is there a way around this, using PowerApps? (Right now I am using two separate lookups: I lookup the car's plate number in the cars list and the car owner in the people list, but this is not what I want: I need to make sure I keep the relation between the car plate number and the owner as stated in the car list). I apologize if this is confusing. Please, if you think there might be a solution I would appreciate your thoughts. Again, thank you very much for all your work and generosity.
Fernando sorry I am so far behind on responding to this. 😑 If you still need help leave a new comment, not a reply and I will get to it ASAP. Thanks
Hello Shane,the way you explain the concepts is very good👏👏👏...could you please give me some suggestion how to iterate the collection object which has date picker,drop-down,text values and need to be stored in SharePoint lookup column...Thank you in advance 😊
Try this th-cam.com/video/gsk14D-CYRE/w-d-xo.html
Hi Shane. I know this video is old, I rewatched it to try help solve a problem I am having. I am using the lookup function in conjunction with AddColumns to essentially create a collection of data across multiple tables that can be used to export to CSV using a flow. The lookup function works as expected in a gallery, but it does not return values for the new column in the collection when using the ClearCollect function. The two functions are as below:
Gallery: LookUp('Loan Requests',ID = ThisItem.Title,Number)
Collection: ClearCollect(CollectionItemTrack,AddColumns(Filter('Loan Lines',ItemLoanStatus="Active"),"Number",LookUp('Loan Requests',ID = Title,Number)))
Any advice as to why the lookup would work in one instance but seemingly not in the other. There are no errors other than delegation warnings coming up.
I found a solution, which doesn't really make sense to me. It seems as though in the AddColumns function you need to use the display name of the column in the lookup and I have to covert to text: The function below works:
ClearCollect(CollectionItemTrack,AddColumns(Filter('Loan Lines',ItemLoanStatus="Active"),"Number",LookUp('Loan Requests',Text(ID) exactin 'Loan Lines'.'Loan Note',Number)))
I'm still scratching my head...
Correction, the filter was in the wrong place and was returning the entire list. Here's the working function for anyone who might having a similar problem:
ClearCollect(CollectionItemTrack,Filter(AddColumns('Loan Lines',"Number",LookUp('Loan Requests',ID = 'Loan Note',Number),"DayseOverdue",Today() - LookUp('Loan Requests',ID = 'Loan Note',ReturnDate)),ItemLoanStatus = "Active"))
Glad you got it Steven and thanks for sharing with everyone!> 😍
Shane. I would like to seach one value between 2 columns l. ex: Column A, number 1, column B number 10 e column C name " House". If I put number 3 on one label, It return " House". What`s struture I need to use?
Sorry I don’t understand. Try a new comment with more details and I can try to help
Shane Thanks you. I have 3 columns on Excel sheet. The first column has to start number, example: 1. Second column has final number example: 10. The third colomn has one Text, example: New York. I would like one syntax On App, if I text one number between 1 and 10, example 1, 2 ,3,4,6,6,7,8,9 or 10, result the word " New York.". I tried, Lookup, Filter and Search but It didn't work.
Thanks for an excellent tutorial. It just fit to my needs. However, your tutorial is based on a customized list form. How I can make the dropblank shown a blank option from a powerapps app. The FomeMode.New as used in your tutorial doesn't work in my app environment where I create an app from a sharepoint list. Any help please.
Formmode.New should be valid. Try this to help th-cam.com/video/BnzaSDYl8mA/w-d-xo.html
Can this be done in POWER AUTOMATE? I'm using MS Forms/SP List/Power Automate combination. When someone selects an office I want to look up the respective contact for that office and send them an email. Pls let me know if that's possible! Thanks 🙏
Forms no. But when they submit the form yea you could have Automate lookup the user and email them.
Hi Shane - thanks for showing me how to sort a converted text to dropdown button. But - can you set the sort order on a SharePoint lookup column in PowerApps? For example - I have a column in SharePoint that has:
Column1 Name Column2 Order
New Entry 1
In Progress 2
Reviewed 3
Approved 4
But the dropdown in Power Apps displays it in alphabetical order:
Approved
In Progress
New Entry
Reviewed
Is there a way to have them displayed in column (process) order?
Hi Shane! Excellent video. Is it possible to look up department master info using Power Apps? I'm using MS Forms to collect the data, and pushing it into a SP list before doing anything else. But when a user selects an office (department), I want Power Apps to reference an excel sheet or SP site to look up the respective email address for the point of contact. Then I will extract that person's contact info using the Get user info connector. I'm stuck on this, I would be thrilled if you can point me in the right direction here! Thanks :)
I thought this video showed exactly this? Use the LookUp function to get the data you want from Excel or SharePoint.
@@ShanesCows I meant can it be done with POWER AUTOMATE? Not Power Apps! Sorry got those two mixed up :)
Hello Shane, How would you handle a Cross Site Lookup Column that allowed a Fill in Choice that would then update the List being looked up? So if i have a list of customers that is being looked up from a orders list and find that the customer i am adding the order for does not exist in the list. I would like the to enter the Customer Name which would then also add it to the Customer List so it will be there on future orders.
I got this sorted out. I just added a new text box to the datacard to allow a fill in choice if the option they wanted was not there. I then added a button that was visible when the text box had data with a Patch function to add the fill in choice to the SharePoint List that populated the combobox.
Thanks for the update Jimmie!
Hi Shane, i learned a lot from this video, i was however wondering is it how to pull back more than one item in a LookUp from a ComboBox that pulls from more than one place
Filter returns a table lookup returns a record. So if you need more data the filter may be better for you.
Hi Shane,
Is there a way to enter a formula in the lookup column such as "Thisitem.ID"?
I am trying to pull parent list information into child list by setting a lookup column and selecting parent ID in it. But I am getting an error : "The property on this control expects Record values. The rule produces Text Values which are incompatible"
This is what I have:
Default : ThisItem.Parent_ID)
Update : Value(TextInput2.Text)
If there is another better way to combine child and parent SP list can you please direct me to that. Thanks a lot
See if this video helps? th-cam.com/video/fqH1U0_TanI/w-d-xo.html
Shane, is there a video for Cascading drop down lookup fields in SharePoint? I cannot find anything about it. Thanks!
Not that I know of. th-cam.com/video/pkZG2boN7jQ/w-d-xo.html what is shown in that video would work with a lookup column with some work.
My lookup column is a person/group field. So when I did the above thing, no options are visible in the dropdown menu. What to do?
This will help. th-cam.com/video/gsk14D-CYRE/w-d-xo.html
excellent - I was wondering if you would do sharepoint power app forms.....I have been living in them for weeks! thanks! keep em comin!
Do you mean choose the customize option from SharePoint? I love the idea.
yes, that's what I mean.... I actually think forms will be more used than an app - at least at my work it will be - too bad they don't work in the phone app like the apps do - only in a browser......maybe in the future they will.
looking fwd to the tabs vid....I will put that to use for sure
Is there a way to use your LookUp('Departments Master', Title = Dropdown1.Selected.Title, Manager) function in conjunction with Concat(ListBox1.SelectedItems,Value&"; ") . I am using a list box where users can select multiple items but instead of the pretty text in the title column, I want the to concatenate the data from the second column.
Example: my list box is connected to a list with two columns, Name and Email address. The names show in the list box but my label field needs to concat the associated email addresses. Any ideas would be greatly appreciated.
Yes. Check out my second video on PDFs for Concat usage
Question....My form will always be in Edit Mode when updating the dropdown, but wondering how would I use the "-" as the default. My dropdown is a pulled from a separate list and I save that value to my sharepoint list form. Would I do an If Statement? If the SP field is blank, display the "-" as the default?
How about use the new Blank property of dropdowns instead? th-cam.com/video/NzhwTrXA-cQ/w-d-xo.html
@@ShanesCows Worked Perfectly :) Thank you!
Hi Shane, I have a lookup column in Sharepoint List that indicates that one employee can have more than one role. However, the trouble that I am having is that in Power Apps, I do not know how to limit role column to just the one or two roles of the employee, instead, I keep getting the list of all of the roles in the company. Any ideas what to do?
Hi Shane,
I know you published this video back in April so I hope you are still reviewing questions. When working with SharePoint lists in different site collections, do I need to consider permissions on the lists? In other words, can the PowerApp access lists even if the logged-in user doesn't have Edit or Contribute permissions on one of the lists? I need to create a PowerApp to intake data (Employee Award Nominations) and move the data to another list that has extremely limited permissions. The user who is entering the Employee Award Nomination data does NOT have any permissions on the second list. In SharePoint Designer, I've been able to use AppStep to elevate permissions. Is there a similar function in PowerApps or Flow?
Thanks!
Hi. You can use Flow to move the item. PowerApps connects to SharePoint as the logged in user. Flow connects as the maker of the Flow.
Thanks for skipping the 30 seconds! :D
It is the little things in life. 😂
Love your videos. Question, the lookup values show on my powerapp form perfectly, but when I look at my list where the details drop after the information was submitted, the lookup information does not populate. Suggestions?
In this example I am not creating an actual lookup SharePoint column so I wouldn’t expect the same results. You can use patch to save any data you want though.
@@ShanesCows I have the same question regarding populating the sharepoint list with the Dept managers name. What do you mean by using "Patch"?
Shane, thank you for your videos. As a small business owner, they are incredibly helpful. I’m trying to accomplish what you’re showing us how to do in this video however I’m using a combo box. This is proving to be a disaster. Do you have another video that specifically addresses Cabo boxes in this context?
Hi Shane, thanks for this vedio, i am trying to add lookup value from people field but is not working can you please suggest me on the same ?
What is your code?
Can we use lookup function inside patch fiction? Can we use varable as columns in patch function? Can we use reference instead of putting column name in patch function? Please help if it can be done.
Aa
Hi, do you have a formula to look up a value that's not based on drop down list? For example I want to look up a part number that a user enters and retrieve it's description from a linked excel table.
Textinput1.Text instead of Dropdown.selected.value
Has something changed in PowerApps since this video? Or does it only for if you customise a form? Instead of an app made from scratch? When I try it, I don't get the option of Title. When I type DropDown1.Selected.Title into the Card update field I can only choose from Result or Value, neither of which work. I'm having a problem at the moment that I have a dropdown and a combobox on an edit form that pull their choice data from a separate sharepoint list. I can't figure out how to get them to save their selected data back to the main SP list. I thought i'd cracked it when I found this video, however you example won't work for me (Yes I am using a Drop down and not a Combo to follow your example :P)
You have to use ShowColumns in the Items property to make the Title column available.
Hello Shane Thankyou for posting such an amazing contents. I am writing this comment as I am facing an issue while trying to create an custom powerApp using sharepoint list as database.
I have a lookup column in my list which inherits data from some another list, when i imported that lookuo column in my power apps everything seems fine, but when I am trying to submit the form [SubmitForm(form3)] is the query is am running for submitted the form. Its start showing error as DepartmentName: Field
'DepartmentName' is required
Location: Button
.OnSelect
Can you please guide me how to resolve it as i am new to powerApps and still learning through our videos
Is it possible make it without start directly from sharepoint list ? For example create a new app then add a sharepoint list as a datasource .. Bcs I tried but it didn't work, i can not change list field with that way. Thanks for this instructive video!
Yes. Create a blank app and then add SharePoint data source. What is not working?
@@ShanesCows Yes I did it, The column work like lookup on powerapp(edit,submit) but on sharepoint list editing page it is still single text column. Is it normal?
I have two different datsources .. SharePoint list and sql table . . My question is ..for one field in sharepoint list ..it should be filled from SQL table !! Is it possible n how ?
Maybe try this? th-cam.com/video/fqH1U0_TanI/w-d-xo.html
@@ShanesCows perfect sir .. your videos saves many life's ..
You have probably answered this already, and I apologize for asking it again: In this example, it appears that the contents of the Title field are being used as the foreign key in a many-to-one relationship. If two records on the One side of the relationship (that is, in the Departments table) happened to have the same text in the Title field, I would expect the lookup to fail. Is there a way around this?
I think I may have answered my own question: Does the ThisItem function select the record that we want using an actual foreign key that I can't see? That would make it work.
Hello Shane - Would you know if there have been any changes / advancements in the way PowerApps handles SharePoint Lookup Columns ( Parent / Child) relationships? The latest test I did, creating a PowerApps (not Customize Form) from a SharePoint List with a Lookup Column seemed to comprehend the Lookup Column with the PowerApps generated application / form(s).... Being such, is there a way now to integrate / include Lookup Columns in Apps built from scratch? Wanted to get your latest take... Thanx!!
I don't know Jeff. I just don't build apps with LookUp columns anymore. :( Sorry, not helpful for you but I just haven't done it in months so not sure if they changed things or not.
@@ShanesCows Hi Shane .. Completely understand not building apps with lookup columns any more ... Follow on question ... Without Lookup Columns (in SharePoint Lists), if there are 1000 existing Items and the user changes one of the "lookup spellings / values" how do your apps trickle down the update the 1000 items in the List? Manually?
So helpful. I have a very large list of Locations that I put into a ComboBox with selectmlultiple set to false, I was able to fix the Update property to be ComboBox.Selected.Title. The ComboBox, works and posts back to the SharePoint list, New/View forms work as expected. My issue comes when a user Edits a row, the Location shows the correct city from the data that was added to the list in the New form, BUT the form forces the user to re-add the location. The required setting on the location is called even though it is pulling the data from the list.
Hi Shane is there possible create to lookup columns in canvas app let me know
This video th-cam.com/video/gsk14D-CYRE/w-d-xo.html
What happens if the department name changes, or a department is eliminated? If you modify the lookup list will that affect the records that have already been created using the previous dept name or using a dept that doesn’t exist anymore? If yes, how to work around that?
If that is the case you will need to look to create a proper relationship. Using something like storing the ID of the record from the other list instead of the word Department. But then you need to LookUp the name each time. It has its pros and cons.
@@ShanesCows oof, you're presuming a skill level I don't yet have! Have you done a video about this?
This is a great video! I've gotten all of this to work, but I can't seem to get the lookup to work when i want to filter based on values from a multi-select field. Is that still not possible?
I don't exactly follow? What are you using for the output of your multi select? What are your formulas?
Your videos have proved extremely helpful!
Thank you. Let me know if you have ideas for other topics you would like to see covered.
hi Shane! ,thank you for your toturials it help a lot, here you expalin about use lookup in drop down and it work perfectly with me, but i try use another data source value as ( list ), but no result for that , what i want to do is take the value from another datasource and show it in the table ad i click start and end time calculate time button to add the data with the name i pull it from the another dat a source to the time calculating data source !
Break it down to baby steps. You can do it.
@@ShanesCows agree my question was not clear,when i use lookup he return me only the first record from data source,is there is any other way to get all the data,so i can use it as items list in a gallery ,i hope this more clear :)
I'm a on premises SharePoint guy and want to start learning Online. I've looked through your videos and don't see a "How to get started for Online" type, basically I want to understand how you get setup with an 0365 account so I can learn PowerApps. Do you have time to make a video on that, or do you know of one?
Let me see what I can come up with.
Shane Young thanks. That would be really helpful
Hi, Shane! Yes, I am still struggling with this! I would appreciate your help very much! Again, thank you very much.
Just a quick qeustion - what happens when someone deletes an entry from Department Master, like "IT"? Is there a way to keep the data in both lists (Employees, Department Master) somehow consistent?
You would need to write the logic to keep things in sync
Hi Shane , I learned a lot from all of your video's . Not enough unfortunately :-( One thing still puzzles me (maybe old style programmer issue) . How are relationships for sharepoint list organized>
There is the lookup-field in Share point but this is hiding the mechanics for me (Giving an output column doens't say that the relationoship is based on that ) . Then you show a relation based on a Text-field so the relation is build in the app. ( Which is fine but based on a Text-Field ..... not sure I dare )
But what about the ID field : isn't that supposed to enforce the relations?
Why I am asking : I try to build a filtered dropdown list for accountmanagers that can be selected in de Sales Pipe for a specific relation ) I cannot base that on name because that will never be unique.
Hi Shane, thanks for the video...I just have a little problem because my column has multiple items with the same name...when i applied distinct, it gives an error. This related to the video at 6:30. Thanks in advance for the support.
When you use Distinct you get a single column table back and the column name is Result. So you dropdown would be dropdown.Selected.Result.
Wait you don't need that complex formula for default. Yu only need "-" because default triggers only for new item anyway. Right?
Great videos btw!
😊
Hi Shane,
Is there a way to get a different field value(like ID) rather than the Control.Selected.Result for a ComboBox. I customized the Items concatenating two fields but I intend to get the record ID and I can't seem to find the way to reference it. Thanks in advance :) and more power to you!
Combo boxes are weird so not sure off the top of my head. Sorry. I do show similar with drop down menu. Look for the video SharePoint lookup columns
Thanks as always Shane!
I am using a similar function in one of my apps but I would like to know if anyone has the answer to the following. Within my Sharepoint list I have columns named "1" all the way through to "100" (as well as a unique identifer in this case shop name) which helps me create a second related data table for other items in my app. My question is this, when using the Lookup fuction how can I make the "result" part of the formular pull from another element (label.text) within my app? The label text is set by a variable context based on where the user has clicked and displays a number between 1 and 100 (i.e. my column names). However when I set the ',Result' part of the formula to my label it says the data type is unsupported.
Any ideas? I hope that makes sense!
Not sure Jaz
Thanks Shane good video as always. Is it possible to use a lookup control in a person / group field to search only for people who appear in another list? If so, let us know how!
I don't know. I haven't tried. I will have to dig around a bit and see. So do you have the users listed in another list in a people column or just a text column?
Shane Young in that list not all users, only a few to filter who can be assign to a specific task. Thank you very much !!
Sorry I forgot it, the type is person not text.
Sorry I forgot it, the type is person not text.
Thank you for this video Shane, this helped me a lot.
However, I currently run into a problem with my adapted version of the solution in this video and I am now at a point where I am desperate enough to ask you guys for ideas.
I used a ComboBox instead of a Dropdown. Reason: I wanted to make the lookup choices searchable (~400 Articles).
So far so good, my combobox works, it is searchable and it saves the values to my SP list.
The problem I have now is that the articles (from the combobox) the user choses is not showing in Sharepoint when the users clicks on the list entry.
Does anyone one has any suggestions?
Are you having a hard time setting the DefaultSelectedItems for the combobox? This video would help. th-cam.com/video/AXAbmy9zYTU/w-d-xo.html
@@ShanesCows EXACTLY! Thank you very much, I‘ll check it out immediatly.
Much appreciated Shane 🙏🏼
Great video again! I feel like in this video, you were subtly making a recommendation to use separate tables for all your fields/columns that will probably be drop-down control types. like, instead of selecting Choice column in SharePoint, just set it to single text column and then create your supposed values in a separate list/table and then just let Power Apps handle the lookup and relationships. Is that best practice or you just really wanted to show that it's possible as well? I'm thinking it might be best practice because passing values to single line text is always less complicated than passing values to lookup controls (say from a gallery row to a form in edit mode).
I think it is a solid practice that works and lets you maintain the app without editing the app :)
If my list has a new column do I need to go back and add that manually in the custom form?
Yes
@@ShanesCows Ok that is one of the downsides vs the default. Thanks great tutorial.