PowerApps AddColumns ShowColumns

[@kimsalas8197]

I really appreciate the quality of your videos. Well put together, and you don’t forget that the camera is in the wrong place, you don’t type in a bunch of code that doesn’t work and make the viewer suffer through the experience while you troubleshoot for 5 minutes. Keep up the good work!

[@ShanesCows]

Thanks Kim

[@jeffjennsmith]

after redoing my "add column" 140 gazillion times because I couldn't figure out why it wasn't showing up in my collection - Shane came to the rescue! Thank you!!

[@AnnikaSchulz-t2o]

You did it again 🤩 I watched your newer video on variables and you directed us to this video for deeper insights. Once again, I have to thank you for giving me exactly the info I needed!🥰 (The amount of "whoop whoop"s infront of my screne thanks to you is unbelievable 🤣)

[@ShanesCows]

😁 Awesome. Thanks for this comment, it makes me happy. 😀

[@kevinbriz17]

All other videos should lead to this one! I wish I'd watched this weeks ago. This video solves all my data manipulation issues, collections now become very powerful. No more back and fourth to my data source. Yet another great vid with layered with golden nuggets of info throughout. Love your work Shane.

[@kevinbriz17]

Hey Shane, have you made a video on Groups or featuring use of? Groups seem to be used a lot in the Powerapps templates. I don't use them, and I feel like I might be missing out.

[@ShanesCows]

Thanks Kevin. I rarely use GroupBy functions. Maybe one of these days I will do a video on them.

[@vmarr0y0]

The man, the myth, the legend! Shane, you’ve helped me tremendously, across multiple videos and forums that you appear on! Im fairly new to PowerApps and I just created an onboarding form that’s rather complex, pulling data from multiple data source. My next step (about 80% done) is the back end process automation (poweshell). Thank you for all that you do!

[@ShanesCows]

Thanks for sharing. 😀 Keep going. You got this.

[@Vacuuming_is_not_an_issue]

Thanks Shane, Was stuck trying to figure out how to reference different lists in one gallery until your video. Your videos are awesome. Keep up the great work. See you soon.

[@ShanesCows]

Nice job! Glad you got it.

[@cvkealey]

Shane, great job as usual. However, my ears perked up a bit when you mentioned using collections to bring in data and minimize data requests. This is one of the things I've really struggled with, particularly working with SharePoint data sources and updating/refreshing information. For example, I have a gallery with a bunch of orders; click an order, update it in a form on another screen, then come back to the gallery to find the old data there! I've been using collections to work around delegation warnings, which may be what's causing a lot of my issues. Anyway, a video on how to properly (cleanly & efficiently) update/refresh data when using collections would be fantastic! Keep up the good work!

[@ShanesCows]

I will see what I can do. In the meantime I would tell you Azure SQL is a better data source. 😀

[@cvkealey]

I'm sure it is, but using it at our organization would require getting the DBAs involved and turn every PowerApps project from a few weeks to several months. We're also looking at CDS, or will be when our license gets upgraded. Right now, we're stuck with SharePoint as our primary data source.

[@johnbrennan8442]

Onsuccess property of the form use the refresh function on the collection?

[@cvkealey]

@@johnbrennan8442 actually, I stopped using collections entirely in that app (and many others). Delegation for SharePoint data is not as restrictive as it used to be, and I learned that collections rarely solve problems, they just change the source of the problem.

[@johnbrennan8442]

@@cvkealey really I’m intrigued what changed with SP to make it better

[@wendymeyer1250]

Finding this video today has solved a ton of issues I was struggling with, in terms of how to pull in data from secondary lists - thank you Shane! QUESTION: Not entirely related, but I'm hoping you can please point me in the right direction of what function I could apply if I needed to reference data that's sitting in a specific column in a series of filtered records (ex SharePoint). e.g. If I filter a list to show all records relating to CompanyX, can I retrieve the corresponding Dates that are sitting in Column3 of those records? The number of line items that exist for each Company does vary.... (I'm needing to extract this data in order to trigger a series of Flows.)

[@wendymeyer1250]

Ooh, I think maybe I've found the solution... kzbin.info/www/bejne/Z4KbfWV-bcije9E (the last part).😅 Thanks Shane!

[@ShanesCows]

Glad you got it working 😎

[@irwinhirsh6647]

Hi Shane, Just a word of caution.... I work in a regulated environment and we never "manipulate" data we only "transform" it.... Just in case you ever get such a customer... don't scare them

[@ShanesCows]

Thanks for the heads up.

[@favoredlearns4789]

Hi Shane, many thanks for this video I have a collection from a SQL data source and another collection from a sharepoint site. I am trying to merge both datasets into a single collection to make a gallery from it. I've tried the method in your video, over and over again, my collection only spools data from one of the datasources. The AddColumn column shows in the collection but it has blank records. Please what could be the issue?

[@wendyl6455]

I am having the same issue. Maybe it has something to do with one of the two tables I use having more than 500 records.

[@gergelylang771]

Thank you for the valuable knowledge that you gave me. Big respect!

[@ShanesCows]

My pleasure!

[@gangavi3]

Great explanation 😀

[@ShanesCows]

Thanks 🙏

[@tammyluper2002]

Shane, thank you for your videos. I've learned lots from your expertise. Is there a way to use a text input field to search 2 data sources at once? (i.e. have parent/child relation galleries and filter both galleries based on search?

[@emanuelpinto7394]

Great video Shane! Thanks!! It's for sure a good use of our time to see your videos. Will most definitely check out that new learning platform you are building! :)

[@ShanesCows]

Thanks

[@fklatecki]

Yes, one for the tool belt, but I am going to revisit an app that is nearly done see if it can be improved!

[@ShanesCows]

Cool. ShowColumns is so awesome.

[@sunshinelabz]

Pls create video for using Accourdian panel in gallery control

[@ShanesCows]

Not sure I know what you mean. 🤔

[@MarioSemper]

Thank you very much for that introduction! Is it possible to add a column in a "main table" that content is the number of rows in a detail table related to the main table?

[@ShanesCows]

Yes, you would need to come up with logic for CountRows of the child items but possible.

[@ambujaable]

Ultimate ! I was really waiting for the such concepts on collections, Thanks a lot :) Really appriciate your work !

[@ShanesCows]

😀 it was overdue for sure.

[@svgenterprises1]

First and foremost.... thank you soooooooooo much for your time and effort on these videos!!! Your tutorials are the best! question: creating a shopping cart style order form for work and i have two collections: user info and cart info that i want to merge to one sharepoint list on submission. Would I use AddColumns to aggregate data on both collections into one sharepoint list?

[@ShanesCows]

Maybe look at ForAll and Patch. kzbin.info/www/bejne/Zqm9ZZmDf8d_rM0

[@svgenterprises1]

@@ShanesCows finally figured it out yesterday! Felt so good to do so! Lol. Couldn't do it apples for apples with collect(collection1,collection2) so did it with a forall. Again. Thanks for the awesome videos!

[@saradehond3293]

The LookUp(Departments, Title = Department).Manager, does this only work if the table has a many-to-one relationship? Like if the lookup column is on the Departements table, does it work? Or only if the lookup is on the Employees?

[@FumbDucker]

Would you be able to provide an example of how you use ShowColumns in a repeating table scenario like you mentioned in your video? We have a resume database of sorts that built based off of quite a lot of your videos, particularly your Repeating Table videos. Problem I'm having is generating a printable resume and have something like their work history line up properly. An example of this is something like: Jon has three previous employers, but the report does not distinguish which job description belongs to which company. I can elaborate more if needed, but I'm hoping that an example of how you might do it with your repeating tables may get me in the right direction. I'm just going in circles right now.

[@ShanesCows]

See if this helps? Concat should be the key. kzbin.info/www/bejne/mJe7h5J9jciSgK8

[@dtCajun]

Shane, I'm trying to make a collection,addcolumn and fill it with a datediff calculation. Is this possible? Normal if statements work but I'm having problems with the datediff.

[@ShanesCows]

It should work. Leave a new comment with your formula and I will try to help you sort it.

[@jray1429]

Great video…One question, if you use drop columns will it increase performance? Or the command that keeps only specific columns, say you only want 3 columns when your list has 20 columns. Would it increase performance? My data gets updated quite regularly, so I’m trying avoid collections in this scenario.

[@farzadnazemi5741]

Question, I can't find an answer for this online, is there a cap on how many columns a datasource can have before powerapps breaks? I am working with someone elses datasource, its a sharepoint list with an ungodly amount of columns that they had working with a nintex form, we need to make effectively the same form in powerapps but the datasource does not seem to work at all and the only thing I can think of is the huge amount of columns being the issue thanks in advance

[@maestro26799k]

Hi Shane, how can I join two columns from different collections without any lookup condition? The columns from different collections have the same number of rows. Collection1 (Column1: [1,2,3]) And Collection2 (Column2: [5,6,7]) CollectionJoined(Column1: [1,2,3], Column2: [5,6,7])

[@ShanesCows]

Not sure. Haven’t done that one.

[@arunshenoy7323]

Hi Shane, Thanks for sharing this helpful video. Yes, AddColumns can be done & can Save it in Collections. But is there a way to save the data from the collections in One Drive or Share point or a Server? I intend to use this data & create dashboards in Power BI. Hence, I very much need the data that is available in the add columns.

[@ShanesCows]

Yes, Collect(SharePointList, CollectionName) will save the data to SharePoint list as along as the columns match.

[@idrissbelamri1929]

Thanks Shane,I'v question , can we joining mltiple table with conditions like sql using addcolumnand , showcolumns and lookup if is it possible hope if you can make us a video to explain that

[@ShanesCows]

It is possible but I don’t have a video on it yet.

[@simonitodo3775]

Hello Shane, great video as usual. I have this instance where I have a form and I want to add fields from another data source, but my form already uses a lookup to a Gallery to populate it, how can I merge the AddColumns and the Lookup under the item property?

[@ShanesCows]

Forms can’t add columns. They only show you what come from the datasource

[@diegovazquez9315]

Hi Shane nice video, I have a doubt about the data source. Can I choose specific columns? Because I have a table with a blob colum that don't need on my gallery. Can I deselect this colum to load?

[@ShanesCows]

Yes. ShowColumns does that.

[@percyalbertoulloamunoz1132]

Hi Shane, I want to reference a columna from a variable. Is it possible?, ex. ShowColumn(mySharepointList, "ID", varDinamicColumnName)

[@ShanesCows]

I don't think so, you would have to do some shenaginans and probably wouldn't end well. I do show it in this video though kzbin.info/www/bejne/rJO1lXmcppqneJo

[@2007pradipta]

ShowColumns & AddColumns does not work after 2K tiems. don't load after reaching the limit ...any way we can still load item like as usual Gallery where it load beyond 2k limit ?

[@ShanesCows]

Not really. You could try making a giant collection but I don’t like it.

[@caterdays2852]

Hi Shane. I’m new to PowerApps but want to start studying to earn a certificate in it. Do you have any recommendations on resources to study (besides your awesome videos)?

[@ShanesCows]

I teach a formal class www.powerapps911.com/training if you mention KZbin you get 10% off. 😻 Another option is go to Edx.org and search PowerApps. I did a class for Microsoft that is hosted for free there.

[@skragibrahi9023]

Hi young!! Hope you are doing well!! Thats a great video I need a help if i can add columns in a table with my actual dataset amd save them all in another sheet with reviewing

[@Javierzorromorales]

Thank you very much for the videos, a query, it is possible to uncheck a Checkbox from the on select property of a button? I try with this line, Checkbox1.Value = false but it does not work, greetings

[@ShanesCows]

Set the property of the button to be a true false variable. Then have the button change the variable.

[@yu11757]

Hi Shane, Thank you it's really helpful. This seems pretty simple but I can't figure it out. Take your example, how can I list full names in the dropdown menu?

[@ShanesCows]

Reference the column Fullname for the field.

[@melissashaker2805]

Great video! Can I add a column that can be used as an identity for the collection? I'd like to be able to automatically number the rows in the collection. I'm pulling from a SQL table and want to number just the rows returned (instead of using the primary key). Thanks!

[@ShanesCows]

It is possible but too complicated to explain here. You can email me and I can share the code.

[@peterhelms-nielsen8838]

Love your videos! One quick question: If I want to add a column, displaying the total number of records for this particular user in a gallery, how do I do that in the Items menu? Example: User A, Current record no.: 3 Total records: 5 I would like to use this to filter my gallery to only show the most recent record per user. Is there a better solution?

[@ShanesCows]

Look at GroupBy function.

[@nileshbhosale5531]

Thanks Shane, I've question how I can rename the column name in power app form. I rename SharePoint list columns but same haven't got renamed on power apps form. Pls help, thanks

[@ShanesCows]

You might have to edit the label. Though if you refresh the data source it might pick it up

[@maidstone53]

I'm trying to display names (one or more) in a powerapp Gallery field. The data is from a sharepoint person or group lookup list. I am able to display one name when the collumn does not allow multiple selections. However if I change it to allow multiple selections I get an error in the power app. The formula in Text is set to ThisItem.Names.DisplayName It works fine when I only allow one choice, when I switch it to allow multiple the error displayed is "The property expects text values, but this rule produces incompatable table values". Any Ideas? Thanks for any help.

[@ShanesCows]

When you store mutli-values you have records not text as the error says. Look at using the Concat function to turn the records back into text in your label.

[@maidstone53]

@@ShanesCows Thank you Shane that did it! Appreciate your help and Videos!

[@tonya3308]

I want to use Add Columns as a way to change column names - when I do, PowerApps places the column order by alphabetical order and not the way I want the column order to be - is there a way to get around this?

[@ShanesCows]

Why does Column order matter? The preview tool always shows the columns in alphabetical order no matter what. You might be able to use ShowColumns and specificy the order but I have never tried.

[@tonya3308]

@@ShanesCows I want the column names to be user friendly and in an order to then export to CSV and Excel.

[@tonya3308]

​@@ShanesCows The customer wants the ability to click a button to download filtered data into an excel file. I can do this via a CSV export but the column names are reordered to alphabetic order. I tried show columns, add columns, a collection, and other but it always exports to the column names in alphabetical order. My next idea is to send the filtered part number list to Power Automate and perform a odate query there against a sql view that has the items in the correct orders - fingers crossed!

[@iliasbououlididrissi1745]

First of all great video, I have a problem that I haven't been able to find the solution thought : I want to show the columns that are selected by the user from a drop down list , how can I do that ?

[@marounsader318]

hi shane, how can we make the droplist to show the title while in the patch we actually patch the ID of that text, as if we have a SPlist that has IDs of the transactions not the text?

[@marounsader318]

ok it worked, seems that the showcolumns will allow me to choose what value i patch and what value to show in the droplist, thanks shane ! :)

[@ShanesCows]

Glad you got it.

[@AnandavadivelanV]

Coincidentally, I heard in the news today that the University of California have devised a more accurate method calculating "dog years" :-), check it out.

[@ShanesCows]

Oh fun. I will have to look that up.

[@nich5696]

Shane, solid work, and thank you for all the videos! (bar-code scan really helped) I'm working on a gallery that is showing a filtered list from a table. I need it to be a gallery because at any time the list of items could change. However, I also want to have different controls showing for each questions, in case the question is True/False or a text input, but I don't want to have the toggles visible when it's a text input, but I can't seem to get the gallery to show or hide controls per record. Any ideas? Thanks again!

[@solomonrobert67]

Hi Shane,. Thank you so much for these videos. Is there a way we can Enable a new field based on a choice made on another field?

[@ShanesCows]

Yes. Look at my video on Tabs or conditional formatting for ideas

[@solomonrobert67]

Shane Young Thanks a lot 😊

[@miguelsaldivar646]

can you showColumns dinamically, for example instead of use "FirstName" use Dropdown.selected.value: ShowColumns (Employees, Dropdown1.selected.value, "LastName"). can you do smething like that?

[@ShanesCows]

Haven’t tried but I doubt it.

[@gerardosalazar2351]

You always solve my doubts even before asking lol!!!

[@ShanesCows]

😊

[@cheaphotrods]

How can I "display only" information in the form (that has edit portions) that is information from a column of the list without allowing anyone to change it?

[@ShanesCows]

Change the control mode to View.

[@andres777video]

i'm trying to display 2 columns (FACILITY_ID & TAB & METER_ID ) in a ListBox using Showcolumns or AddColumns, possible ? I don't know how to do the TAB character yet... this is what I have so far... [the Filter is for selecting only 500 rows at a time to display in my listbox... since I have over 20k records... ] Filter(ShowColumns(colORAMeters,"METER_ID","MTR_SEARCH","ROWNUM"),MTR_SEARCH=Dropdown1_1.SelectedText.Value,StartsWith(METER_ID,searchQuery)) I'm using this app so users can modify parameters Stored in SQL to be used in PowerBI /Paginated Report filters - Thanks!

[@ShanesCows]

Find the ascii code for tab and then use the Char(13) function but replace 13 with the number for tab

[@Gbd279]

These vids are great. Thank you.

[@ShanesCows]

Happy to help. 😀

[@TheCaju]

Thanks for this video. Can i suggest you to make video dealing with ManytoMany table (bridge tbl) ..specially in formedit mode to update and add new entry in bridge table. Thanks

[@ShanesCows]

More details please on what you want.

[@TheCaju]

@@ShanesCows hi Shane, this is exactly similar asked here. powerusers.microsoft.com/t5/General-Discussion/Many-to-many-in-form-SQL-source/td-p/103111

[@TheMathizze]

@@ShanesCows I'm struggling with the exact same problem. Showing multiple values for an item from 2 SQL tables in a many to many relationship. In my app, a project can be part of multiple domains, 1 domain or none and the data is stored in a projects table an a domain table, linked by the project ID. I can only show 1 domain if there is one, but never multiple. It seems like the lookup function stops at the first match? BTW: love your tutorials, they have helped a lot so far!

[@tinbui9876]

Wrong link to getting started with collections, Shane. It's seem to be the link to edit, not viewing it.

[@sanjanakhanna2226]

is there a way to transpose data in powerapps , columns to rows?

[@heloisaheng3189]

17:05 bookmark useful formula

[@ShanesCows]

😎

[@kamranbutt8076]

Hi Shane, how would i use addcolum on a gallery with a filter?

[@ShanesCows]

AddColumns(Filter(datasource, columnname = 1), “ShaneWasHere”, “yup”)

[@gagangoel4808]

Can you please tell me how to add columns in the excel sheet through power app button

[@ShanesCows]

Not possible

[@gagangoel4808]

@@ShanesCows ok then help me with login page when user enter his login id passwrd then he can access his profile page..if other user enter his login details then he can acess his own profile..🙏🏻 plZ help me for this by tomorrow

[@petereriksson6859]

Alwas so nice videos .

[@ShanesCows]

Glad you like them!

[@yogeshpatel8909]

Hello I have created a app in power app with premium user login. When I shared that with my work mate it opens but won't work further. Not sure whats happening. Please help

[@ShanesCows]

What is your data source? Does the user have access to the data source?

[@yogeshpatel8909]

@@ShanesCows yes the excel.file from which app us sourcing data is saved in one drive. Which is shared by everyone

[@9449365005]

Hello Shane, I had followed the process as indicated, but now have a problem. whenever i try to save hard the sharepoint list is not getting updated, even if my collection is updated. and also the Save button is not showing up any toggles whereas my record button shows up the toggle and saves the list in collection. Please let me know if i can sort out the issue

[@ShanesCows]

Not sure. Break it down into baby pieces and see if you can find the missing info.

[@evanpangle6042]

How can you set a date and time to be sent in a meeting invite?

[@ShanesCows]

Replied to your other comment.

[@hiattech]

Hey Shane, A tad off topic but I noticed you have discord open. Is there by chance a discord group I can join to discuss issues with? Thanks.

[@ShanesCows]

Twitter is your best chance. I use Discord for a game I play. 😂

[@alifpurnama3298]

where do i get age? in sharepoint there is no age

[@ShanesCows]

Age is one of my SharePoint column names.

[@alifpurnama3298]

@@ShanesCows employees columns? I didn't find it

[@agnelodcosta906]

7:55 haha gonna refrence ur comment that made me smile.. More comments to come :)

[@ShanesCows]

Glad to keep you entertained 🤗

[@agnelodcosta906]

As always :).. Thank you for everything guru shane.. Really appreciate it🙏

[@MeMe-mu2ob]

Greate, it works fine😀. Thank you

[@ShanesCows]

You're welcome!