This is really a great video. Today I worked with around 100k rows of data on on prem sql server and the app behaved fairly that too without any filtering. Filtering definitely going to optimise it.
@DanielChristian194 жыл бұрын
WOW! 100K rows and that too with On-Premises SQL. Well done!
@AISHWAR044 жыл бұрын
Daniel Christian Thanks Daniel! And that too right now on Sql Server my laptop. I am going to scale it to a million rows by tomorrow and then test with filtering. Hope it works well.
@cchristoff3 жыл бұрын
Actually with the delegable datasources, the limit is how much rows the datasource supports. So for SQL there is no explicit limit (limited by available storage), thus in theory the app will work with millions (even billions of rows). Of course results will not be served instantaneously when you search/filter. For SharePoint list/library that limit is 2 million.
@JoseHernandez-bs8ih3 жыл бұрын
@@AISHWAR04 Hello, did the app work well by bringing 1 million records?
@kevwlew4 жыл бұрын
Man...this is awesome! Pulling data from a SharePoint list that currently has 192,807 records. Added a ComboBox & Text Input Box, and wow! Thanks Daniel.
@DanielChristian194 жыл бұрын
Your welcome Kewlew!
@NelsonYYZ4 жыл бұрын
Daniel, this is such a great video. Thank you SO MUCH for putting this together. So informative
@DanielChristian194 жыл бұрын
Glad you enjoyed it!
@rsaikrishna4 жыл бұрын
Very nice demo Daniel. I recommend App makers to index the columns in the data source. Indexing improves the filter and search functionality. Data sources like SharePoint will NOT let you perform Filter or Search operations on the the data after it reaches 20K items if we do not index the columns. Power Apps just passes the commands such as Filter, Search to the data source. Its data source capability whether it can perform it or not. During app creation process, we must consider the delegation while creating the type of columns.
@DanielChristian194 жыл бұрын
Hi Krishna, Indexing the columns is always a good idea. I wasn't aware of the inability to filter after reaching the 20K items limit. I'll have to research that a bit and confirm.
@jigsaw7514 жыл бұрын
Great content, should be great if you show us how you built the App, the hidden fields showing by clicking the edit button in each row looks interesting to get. Thank you.
@sushichow3 жыл бұрын
It’s like gold mine as I keep on digging I am able to find amazing content in Daniel videos.
@DanielChristian193 жыл бұрын
Wow, thanks, Susheel.
@WillCooper14 жыл бұрын
This helped a lot! I am getting ready to run up against a situation with a customer app where the SharePoint list is growing and I need to adjust the search and filters. Thanks for the great ideas.
@DanielChristian194 жыл бұрын
Glad I could help. Keep PowerApping!
@manikyakotni54933 жыл бұрын
This is what am looking for. Great video Daniel. Appreciate your knowledge sharing.
@DanielChristian193 жыл бұрын
Glad it was helpful!
@andrewsmalley3 жыл бұрын
Thanks Daniel, brilliant video - just what I needed!
@DanielChristian193 жыл бұрын
Glad it was helpful!
@austinleedavisTeaches3 жыл бұрын
"Import Spreadsheet" app. You get a like for that alone! :) Thank you also for showing an AND in the Filter function for SharePoint.
@DanielChristian193 жыл бұрын
Glad it helped!
@seegeat3 жыл бұрын
Great Content, Daniel....very clearly and hope you always productive to create another power apps content
@DanielChristian193 жыл бұрын
Thanks for the compliment and there is more to come!
@imranpearl4 жыл бұрын
This is amazing bro, exactly what I was looking for. You saved a day😊
@DanielChristian194 жыл бұрын
Glad I could help
@FamEkin3 жыл бұрын
Hello Daniel, love your videos and easy to understand explanations. But I have a question, that is also asked by other people here, that's about the filter County (26:00), you don't show what query you use? Because of the large dataset, not all rows will return, so how did you fixed that in the demo? I had also a large Sharepoint database and I distinct one row and copied these items in a new Sharepoint-list with only one column, added this datasource to my PowerApp and used that dataset on the filter as u use County filter. But how did you filter County with only one large Sharepoint Dataset?
@DanielChristian193 жыл бұрын
Hey Mustafa, I didn't use the filter for the country dropdown but instead hard coded the items for this demo. You can consider using another list that stores the county information. If that doesn't work then use search. ["ALAMANCE", "ALEXANDER", ..., "WASHINGTON", "YANCEY", "YADKIN"]
@radiosonicfan17264 жыл бұрын
What formula did you use for the drop down filter with counties? I am trying to recreate tried distinct(data source, column) but I couldn't get to work.
@noshortcuttoglory64434 жыл бұрын
Very, very cool Daniel. And I just subscribed to your channel.
@DanielChristian194 жыл бұрын
Awesome, thank you!
@ajitdas83433 жыл бұрын
Thanks Daniel for awesome session, my doubt go clear
@DanielChristian193 жыл бұрын
Glad to hear that!
@anandasuresh14 жыл бұрын
Amazing this is solution I'm looking for, thank you so much
@DanielChristian194 жыл бұрын
Thanks for compliment Amanda and keep Power Apping!
@dragonjad3 жыл бұрын
This is such a good video - I have been trawling through endless forums trying to figure this out and you managed to save me in just 30 minutes. Thank you! Just as a question, what is your patch() formula for the Save button on the CDS screen? Are you able to share this in another video?
@DanielChristian193 жыл бұрын
Thanks DragonJad, This is my patch function formula Patch('NCDOT AADTS',CDSGal.Selected, { COUNTY:CDSCountyTextInput.Text, ROUTE:CDSRouteTextInput.Text, LOCATION:CDSLocationTextInput.Text }); Set(EditVar,false)
@ajitdas83433 жыл бұрын
Thanks Daniel for awesome session
@DanielChristian193 жыл бұрын
My pleasure!
@chrisrichardson66803 жыл бұрын
Great demo. Question: with the CDS -> Dataverse rename, can I assume that all CDS details in the demo are 100% applicable now to Dataverse?
@DanielChristian193 жыл бұрын
Thanks Chris. The short and simple answer is yes. All your app connections should continue to work. So far the only complains I have heard is the naming convention for a few things such as choice and choices.
@alfonsobedonia97603 жыл бұрын
Hi Daniel. How did you solve the problem of activex control on chrome? I'm having that problem when importing the excel on sharepoint.
@MrAfzalaziz4 жыл бұрын
I never saw this major con of Power apps discussed anywhere that multiple users cannot work on the same app at same time.
@yessicadegranados88843 жыл бұрын
Once and again, thank you for your videos
@DanielChristian193 жыл бұрын
My pleasure!
@narendrareddy84203 жыл бұрын
This really helped, Thanks Also is there any delegation with respect to updating new Records to large data sets, because when trying to use SubmitForm(FormName) the sharepoint list does not add the new data set submitted. If yes, could you suggest any workaround for this.
@DanielChristian193 жыл бұрын
Your welcome. Updating will work with the edit form. You need to have the item you wish you update selected using a gallery and that selected item will appear in the edit form. After you have made the change the submit function will save the data.
@willsonsantoso48054 жыл бұрын
Thanks Daniel. This works well for filter that startwith certain text. What about filter with wildcard search where the text being searched can be anywhere in the string? That is a very common search use case. Do you know how PowerApps with large SharePoint list can support that?
@DanielChristian194 жыл бұрын
Filter with wild card is a great idea. Let me think through that and will record a block on that in the near future.
@taru2507063 жыл бұрын
Thanks Daniel. As always, great video and to the point content
@DanielChristian193 жыл бұрын
Thanks for the compliment Tanvi!
@jhoncarlospenaarias98374 жыл бұрын
i need some help. I am doing a lookup search in a CDS database with more than 200k records, but if I search for a record that is in row 200k it does not give me a result, I must first do a search for a record that is in row 198k and then do the search for the 200k row so that I get the result.
@DanielChristian194 жыл бұрын
Hey Jhon, Here are two things you should do- 1) Take a look at this link which has all the delegable functions for CDS. This list does get updated frequently. Make sure you are using the correct combination of functions for your search --> docs.microsoft.com/en-us/connectors/commondataservice/ 2) Filter your search in sections and drop them in a collection. Then filter the same gallery to narrow down your search. You can do this several times to get exactly what you are looking for.
@LapaConsult_Ex_Macraris3 жыл бұрын
Hello Daniel, Thanks for this video. Do you see some performance issues in building a powerapps on Sharepoint list with 700 Columns? Would you even consider sharepoint and powerapps in case you had so much data to fill in through a form. Thank you for your time.
@DanielChristian193 жыл бұрын
Hey Macraris, You are welcome. I have not worked with 700 columns. That's alot of columns! I wouldn't be surprised if you ran into any performance issues. Take a look at my three part series video on Planning SharePoint Lists Relationships. Maybe you can get some ideas from there? kzbin.info/www/bejne/p4aVY3eflq6Dprc
@russellniebolt14933 жыл бұрын
Daniel, this was REALLY good! Thanks for setting up that proof-of-concept app, it proved out all your conclusions). Question: I'm developing a power app where about 15-20 Help Desktop staff will looking up user accounts on a on-premises Active Directory instance.......using SQL calls. In your experience, would this many users hitting AD at different times, cause any stress on AD access and slow down other legacy stuff that AD is doing ?
@DanielChristian193 жыл бұрын
Internet connection to the server/machine where the on-premises gateway is where the performance throttling occurs. Active Directory and SQL calls for 15-20 should be fine. Keep that on-premises gateway version up-to-date as often as possible.
@russellniebolt14933 жыл бұрын
@@DanielChristian19 Great, thanks for info.
@issiewizzie3 жыл бұрын
At last real life example ....thanks
@DanielChristian193 жыл бұрын
Yeah, I try to make all my videos real life scenarios.
@joek29044 жыл бұрын
Hey Daniel, A follow up question, is it possible to create a new spreadsheet on the dynamically.. let's say you are logging entries from a power app into a spreadsheet stored in SharePoint, and you want a new spreadsheet for every month. Is is possible to have the power app dynically create a new speadsheet or choose a new file to write to? my manager is trying avoid writing to SQL and CDS...
@DanielChristian194 жыл бұрын
Take a look at this video, it will point you in the right direction. --> kzbin.info/www/bejne/h4XFh4Cra6l8nLM
@joek29044 жыл бұрын
Daniel Christian thanks again!
@PravinGumgaonkar-b7r Жыл бұрын
Its nice article and very explain in short and simple. Thanks You so much.
@DanielChristian19 Жыл бұрын
Your welcome Pravin.
@danusranger3 жыл бұрын
Hi daniel, i also come across this kind of problem, i have 19m total record which i have to sum and filter, but i have to filter content with another collection, but i can't seem to delegate it, do you have any idea how to do it?
@DanielChristian193 жыл бұрын
Hey Muhammad, I haven't worked with a list or table with 19 million rows. Breaking the large table down to smaller tables is my recommendation for now.
@danusranger3 жыл бұрын
@@DanielChristian19 hey daniel thanks for replying, i've tried using smaller table to test if the script i made is considered delegable or not, unfortunately it's not, i've been looking at the forum but still find no answer, if you dont mind, could you look at my script and tell me where did i do wrong?
@ShitijBathla4 жыл бұрын
Amazing! THANK YOU
@v75tan3 жыл бұрын
how to filter only a few county for the list. like only ["YADKIN", "GUILFORD"] ....? Please help
@PC-hp6gz4 жыл бұрын
I am very new to all of this and found this particularly useful. Is 'StartsWith' the only option that can be used here? Obviously this looks up the string of characters at the start of row entries under specified columns but I am interested to know if it can be a more general 'Contains' kind of statement. So, if I have rows that contain the word 'people', StartsWith will work as a filter if I start my search term with 'peo' but I have less uniform data and therefore would like to pull back results regardless of where the string I enter appears in the row item, by this, I mean that I would like 'people' results to be returned even if I use 'ople' as the search string. I hope that makes sense.
@DanielChristian194 жыл бұрын
Hi Peeceeuk, You question makes sense, however, the answer depends on our data source. Depending on what the data source is the delegable functions and operations changes. Here's a link to the doc- docs.microsoft.com/en-us/connectors/sharepointonline/
@UsagiNZ4 жыл бұрын
Great video Daniel. But your solution for SharePoint isn't really the same as SQL or CDS... Filter(...StartsWith()) doesn't really do the same thing as Search() - you can't find words in the middle of a field. And you've used "AND", but Search() is doing an "OR" - though "OR" is usually delegable too - but often not in SharePoint... MS really needs to do a lot more work on delegation into SharePoint, it's a real pain, very limiting.
@DanielChristian194 жыл бұрын
Good point there Craig and you are 100% correct.
@UsagiNZ4 жыл бұрын
@@DanielChristian19 It's something MS really need to work on, now that SQL/CDS is a premium licence, vs using SharePoint Online as a datasource. Delegation just falls apart and performance dives with big SP lists... :(
@ddntim4 жыл бұрын
@@DanielChristian19 So what is holding MS back from having SharePoint work well with PowerApps? The limitations make me look a fool. 10500 rows and the app shuts down with same formula as the one that works with 2500. Why not toss BETA on every screen, if it can't handle reasonable amounts of data? It's not like I am programming on my old VIC-20.
@saravanank19944 жыл бұрын
Hi, I need summary of my SQL table, when I am using countrow formula it's show 500 only. But I have 28000 line items. Can you please help me
@joek29044 жыл бұрын
Hey Daniel, What if you power app doesn't pull data, but just writes to a spreadsheet.. will you hit these limitations? I also noticed if you are writing to an excel file saved in sharepoint or onedrive and someone has it open, we receive a locked file error... have you ever seen this before?
@DanielChristian194 жыл бұрын
Hi Joe, You'll be fine if you are only doing a new entry, no limitations there. Excel spreadsheets getting locked out has been an issue for as long as I can remember. Hence I only use Excel in OneDrive for a quick POC or for production apps I use it as a source for read-only such as drop-down items to select from.
@joek29044 жыл бұрын
Daniel Christian thanks Daniel
@jhoncarlospenaarias98374 жыл бұрын
hello excellent videos and great explanation. A question how can I do to keep some fields hidden from me and only show them if I am going to edit them as you have in the video the pencil option
@DanielChristian194 жыл бұрын
Hey Jhon, Each control/field has a visible property which you use to hide or show it. That property along with variables is what I use to show and hide fields. Hope this helps!
@vaishnavvijayan26854 жыл бұрын
Hi Daniel, I have a dataset with nearly 450 columns. Can I use Sharepoint lists in this case for Powerapps?
@DanielChristian194 жыл бұрын
Hi Vaishnav, With Power Apps any existing limitations the data source has doesn't change. Hence take a look at the Microsoft Docs to see what limits SharePoint Lists faces and what are the workarounds. Here is a helpful link- support.microsoft.com/en-us/office/manage-large-lists-and-libraries-b8588dae-9387-48c2-9248-c24122f07c59
@vaishnavvijayan26854 жыл бұрын
@@DanielChristian19 Thanks Daniel
@notonurnelly4 жыл бұрын
Hi Daniel, Is it possible to pull the filtered items into a collection when dealing with SharePoint Lists. I have a list with 55k records and would like to work with the filtered records and combine them with columns from another data set.> Thanks Jamie
@DanielChristian194 жыл бұрын
Hi Notonurnelly, You can get up to 2000 items into a collection. Since you have such a large data set you'll have to do alot of filtering.
@ShyamKumar-rl3rw3 жыл бұрын
Thank you. Very informative. Can you please make detailed video of how CDS should be created? And bring in to power app from scratch? And azure SQL table also. I am aware of sharepoint. Thank you 🙏
@DanielChristian193 жыл бұрын
Hey Shyam, Go through the Microsoft Power Apps App In a day training. It's a self-paced course and in addition to building your own custom canvas app, it does have a module on creating a CDS entity. aka.ms/appinaday
@poojashetty21952 жыл бұрын
Hi Daniel, Do you have any idea how we can get more than 1000 rows of data in powerapp when using powerbi as a datasource?
@renzocanepacastillo4 жыл бұрын
Hi Dan! Thank you for your support. I stucked in a project, because I can't use a Sum(Filter function with a Sharepoint list. I don't want to migrate my database :( Should you please give me and advise? Really appreciate it!
@2007pradipta4 жыл бұрын
Helpful demo. Thanks..How it internally request to SharePoint when you scroll down after 100-100 items ? As it load when it reaches 100 items. Does it use $top or what ? Can I see the internal request through Fiddler?
@DanielChristian194 жыл бұрын
Hey Pradipta, Glad the demo was helpful. The Power Apps app will make a request to SharePoint (or CDS or SQL table) once you have reached the end of the 100 items, it does this automatically. Since these are delegable connectors you will see more than 2000 items as you keep scrolling. As far as Fiddler goes, I haven't tried it yet but my educated guess is that you will see the call the app makes via the browser as you reach the end of 100. Let us know what you find by adding a comment here!
@2007pradipta4 жыл бұрын
@@DanielChristian19 thanks Daniel ... I got new article which really help to want in Native application. This option is there in the Advanance section (Monitor) powerapps.microsoft.com/en-us/blog/introducing-monitor-to-debug-apps-and-improve-performance/
@papithasekar95673 жыл бұрын
Very useful information, Thank you Daniel. Instead of search,can we use filter ,that check directly CDS entity and do the filter and countRows and display in the gallery? Right now my app performance is slow, I have less data in dev environment. Guess it will be damn slow in PROD has we have large set of data. Can you suggest to improve the performance?
@DanielChristian193 жыл бұрын
Thanks Papitha. Assess to see how many times you are refreshing and saving data. Do you have any attachments? How big are they? Finally, take a look at these two links for ideas- docs.microsoft.com/en-us/connectors/commondataservice/ docs.microsoft.com/en-us/learn/modules/testing-performance-checks-powerapps/
@papithasekar95673 жыл бұрын
@@DanielChristian19 Thank you shall check the link
@BboyDaquack3 жыл бұрын
Was wondering if i could get some input. I have a SQL table with 200k+ rows. When you use search/filter functions, it seems to run no problem. On my end, it's just stops at 2000 and doesn't pull any rows after that. how did you get your connection to pull more than 2000? The limit is set for non-delegable. But those functions, to my knowledge should be delegable. edit: realized it all came down to delegation issues. can't use "startswith" for a number type column. couldn't convert the SQL column from number to text with Text() function. also, non delegable. The difference was in filtering for a column that was a number type vs string. With the SQL column being a number, the search box has to equal exactly that column number. ended up using "Filter('[SQLServer].[SpecifiedTable]', SQL_Column_Name_Number = Value(TextSearchBox1.Text))".
@kylebroaddrick12228 ай бұрын
Thank you! Great video.
@DanielChristian198 ай бұрын
Glad you liked it!
@sudheerbachu80774 жыл бұрын
Very useful information, thank you so much
@DanielChristian194 жыл бұрын
Thanks for the compliment, Sudheer!
@s1hl34 жыл бұрын
Hi Daniel, great stuff, I am filtering my data by Date, as per the document this is not delegable. How do I work around this. How can I use flow to resolve this?
@DanielChristian194 жыл бұрын
Hi S1h3l, A good friend of mine, Reza has covered this topic on his video. Take a look --> kzbin.info/www/bejne/m3SwpouGfpaEpc0
@s1hl34 жыл бұрын
@@DanielChristian19 thanks Daniel will check it out
@markdiamante29273 жыл бұрын
Thank you for the excellent tutorial videos. With SP as the data source, up to the 2000th row was shown even if a collection was used. Row IDs of 2K and above were used to filter the collection but still, data is not shown after 2K row when searching. Any workaround?
@DanielChristian193 жыл бұрын
Your welcome Mark. The data will show. In my demo you see I am doing a filter for items that are in 20k+. SharePoint lists is delegable which means the filter is performed on the server side.
@markdiamante29273 жыл бұрын
Data is stored in a document library (photos). Tried the same approach but didn’t work. Will surely appreciate if you could share a workaround. Thank you!
@VivekKaser4 жыл бұрын
Thanks for the video. It really helped me with creating app for large data set using SharePoint as I only have access to the SharePoint. I am however not able to see the data on the mobile. Is it because of large data set? If so, what can be done.
@DanielChristian194 жыл бұрын
Your welcome. The amount of data you see in your studio should be the same in the mobile app as well. Check the gallery settings to see what you are missing.
@bibinbastian014 жыл бұрын
Really Cool Daniel,
@DanielChristian194 жыл бұрын
Thanks Bibin
@iniesta84884 жыл бұрын
Great Daniel !! But how to manage a list of SP with more than 6000 records to delete an item located after the 2000th record ? Thanks a lot, Have a good day ;)
@DanielChristian194 жыл бұрын
Good question! You can use a the remove function for this. Add a trash icon and in it's OnSelect add Remove(SPListName, ThisItem). Hope this helps and keep PowerApping!
@masgitz3 жыл бұрын
Christian, I want to try create drop-down using a 30k items. I've been wrestling with this all weekend. Any ideas
@DanielChristian193 жыл бұрын
Hey Tigere, Use a Text control with a gallery. It has the same effect as a drop-down. As long as the data source and it's column is delegable, you should be fine. Depending on your data source you can use either Search, Lookup or Filter function.
@masgitz3 жыл бұрын
I just figured it out this morning, I was getting desperate. Man, my company just rolled out PowerApps in October. I'm working on my first app, but unfortunately for me, it has 30k line items. You videos are invaluable to me right now 👏👏👏
@DanielChristian193 жыл бұрын
Thanks for the compliment, Tigere. Keep Power Apping!
@patrickrojo71054 жыл бұрын
thank you. can you make a video that allows bulk upload with excel and saves to database?
@DanielChristian194 жыл бұрын
Hi Patrick, I'll add that to my to-do list. As FYI, you can use Excel to import data into each of the three data sources.
@andreasstrom1313 жыл бұрын
Really good education!
@DanielChristian193 жыл бұрын
Thanks for the compliment Andreas!
@t.shoemann52013 жыл бұрын
Thanks for the video. But on sharepoint: What if I apply a filter but the filtered results still exceed 500 rows / items? My understanding is that then search function would again not work appropriately, correct? If so, any further ideas on how this can be solved?
@DanielChristian193 жыл бұрын
Hey Tim, SharePoint is a delegable datasource hence as long as your formulas are correct you can search at the server level and not be limited to the 500 or 2000 rows.
@t.shoemann52013 жыл бұрын
@@DanielChristian19 Ah right. Makes sense! Thanks
@terabyte65854 жыл бұрын
Great Video!!! I was looking for this!!, should be great if you show how you built the App, can you show the code for patching into SQL, I actually getting some problems in that. Thanks
@DanielChristian194 жыл бұрын
Thanks for the compliment Tera.
@mustafahussainmohsin3204 жыл бұрын
@@DanielChristian19 Hi, if you don't mind sharing the patch code for SQL Datasource? I am actually confused
@DanielChristian194 жыл бұрын
Hi Mustafa, I am not using a patch function in this video. I am using search and here is the formula Search('[dbo].[DBName]',SQLSearchTextInput.Text,"COUNTY","LOCATION","ROUTE")
@mustafahussainmohsin3204 жыл бұрын
@@DanielChristian19 Mr Daniel, when you are editing the record and updating to the SQL, I want to see that code, can you please share it??
@thanhdcbk2 жыл бұрын
Hi Daniel, If the filter result for SP Online has more than 2000 records, can Powerapss retrive all of them?
@DanielChristian192 жыл бұрын
Yes. However, keep in mind that the gallery can only display 100 at a time hence you should consider storing those records in a collection. Also, ask yourself if you need to pull 2000+ items, can you add more filter conditions to lower the item number.
@RaniSingh-om8dp4 жыл бұрын
Hi Daniel, So you mean to say for more than 3k data we need not retrieve it through flows or collection I can directly do it through ds .. SharePoint in my case using proper functions?
@RaniSingh-om8dp4 жыл бұрын
I have lot of columns...but till now I have not recieved any delegation error except when I had to filter data using lot of conditions which include start date and end date...so I'll be able to work on data more than 10k if I don't get delegable issues without any collection or flow ??
@DanielChristian194 жыл бұрын
That is correct. Just like I demoed in this video, SharePoint list is delegable as long as you use the correct functions.
@RaniSingh-om8dp4 жыл бұрын
Thanks Daniel . But I have lot of columns like more than 60+ which includes ppl picker..text..date and multiple line of text. I have used filter in my galleries and there is no warnings yet. Will I be able to retrieve all those columns for that selected item in gallery ? Also, can you please provide a solution for date.. I need to fetch report which has a start date and end date and a status drop-down.i get this warning in the date. Please provide a soln for this as well.
@Baldur10054 жыл бұрын
How long it take to upload SharePoint List with this spreadsheet? I was trying to do once upon a time, but I lost hope after 1,5 h.
@DanielChristian194 жыл бұрын
Hey Artur, Try doing it in small sections such as a batch of 50 or 100 at a time.
@anandasanyal4 жыл бұрын
This is really a nice and helpful video. I've a question on delegation with sharepoint. My requirement is Get the last record of the Project list. I'm using formula - First(Sort(Project,ID,Descending)).ID This gives a delegation warning. Any work around for the same?. Thank you.
@DanielChristian194 жыл бұрын
Thanks for the compliment Ananda. Try this, pull the data in the gallery in a descending order of the list Id. You can also do a filter based on the last n number of orders. That should get your started. Don't forget to like and subscribe!
@anandasanyal4 жыл бұрын
Hello again, I've tried below. it works without delegation error. Last(Sort(Project,ID,Ascending)).ID+1) Your comments please. Thank you.
@corby86784 жыл бұрын
Dear Sir GE How to filter sharepoint birthday list by todays date in powerapps screen my sharepoint name is birthday : name | DOB | birthday days & Months i had used powerapps filter(sharepoint list name source file , birthday day & months =today()) but dosent display todays list in powerapps can you help (formula)
@DanielChristian194 жыл бұрын
Hi Mani, If you are looking for todays date, you can Filter(yourList, StartsWith(yourTextDateColumn, "20201910")). If you want to find all items for the month, you could do Filter(yourList, StartsWith(yourTextDateColumn, "202010")) etc.
@RohitSingh-vc5gs3 жыл бұрын
Is that a data table in powerapps or a gallery ?
@DanielChristian193 жыл бұрын
Hey Rohit, That is a gallery.
@RohitSingh-vc5gs3 жыл бұрын
@@DanielChristian19 thanks
@truptinalnikar3 жыл бұрын
very informative !
@DanielChristian193 жыл бұрын
Glad it was helpful!
@nicholasberglund4 жыл бұрын
Well explained! Thank you!
@DanielChristian194 жыл бұрын
Thanks for the compliment!
@GopiNath-jk8jq3 жыл бұрын
sir, how to handle large data in cascading filter?? ... my table contains 15000 rows ..
@DanielChristian193 жыл бұрын
Hi Gopi, I would recommend saving the filtered items in a collection. You can increase the Data row limit for non-delegable queries to 2000.
@GopiNath-jk8jq3 жыл бұрын
@@DanielChristian19 please explain one video demo sir
@JACKLAI11173 жыл бұрын
This is really a great video. Your vedio solve my problem ~~
@DanielChristian193 жыл бұрын
That's great news. Keep Power Apping!
@deniscloutier3832 жыл бұрын
Thanks sooooooo much!
@DanielChristian192 жыл бұрын
Thanks Dennis. Glad it helped!
@Rieske19694 жыл бұрын
Love the t-shirt
@gtrj55tgjr3 жыл бұрын
Daniel thank you every video, one question I have, which is off topic, your accent is somewhat INDIAN, are you ever belonging from india, please answer sir
@DanielChristian193 жыл бұрын
Hey Gautam, I was born in India and moved to US after my High school graduation. I haven't gone back since all my family is here.
@rutujashreshth3704 жыл бұрын
i have 8000+ record in online SP list and it have column salesperson, I want to get list of sales person in dropdown with distinct function
@DanielChristian194 жыл бұрын
Hi Rutuja, The steps should be the same, however, you may want to use the user mail (which is the same for email) for the distinct function. This way you can get unique names.
@rutujashreshth3704 жыл бұрын
@@DanielChristian19 Thank you, through this solution i am able to get 2000 filtered records
@terabyte65854 жыл бұрын
@@rutujashreshth370 Hey, how you got the unique names of salesperson, I have something this kind of problem. what have you done can you please share?