Power Apps With Large Data Sets

Подписаться 27 тыс.

Просмотров 40 тыс.

50% 1

Here's my vBlog about Power Apps performance with large data sets with 44K+ rows/items. I then tested functions & the results pleasantly surprised me. I'm confident this will clear some doubts & concerns you might have.
Important Link-
Here's the link to delegation overview which I mentioned in the video - docs.microsoft.com/en-us/powe...
Here's the link to the Xrm Tool Box which is free -
www.xrmtoolbox.com/
Interested in my blogging gear? Then take a look at them on Amazon:
- Blue Yeti USB Mic for Recording & Streaming on PC and Mac - amzn.to/3d9g7bY
- Microphone Stand, Mic arm Desk Adjustable Suspension Boom with accessories - amzn.to/2N0YNLp
- Neewer 2 Packs Dimmable 5600K USB LED Video Light with Adjustable Tripod - amzn.to/3qteqdf
- Flexible Desk Mount Clamp Gooseneck Stand for Logitech Webcam - amzn.to/2Ozc4eH
- Sunpak tripod - amzn.to/3jJeov2
- Logitech C922x Po Stream Webcam - amzn.to/3aZlqrt

Наука

Опубликовано:

21 июл 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 183

@AISHWAR04 4 года назад

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.

@DanielChristian19 4 года назад

WOW! 100K rows and that too with On-Premises SQL. Well done!

@AISHWAR04 4 года назад

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.

@cchristoff 3 года назад

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-bs8ih 3 года назад

@@AISHWAR04 Hello, did the app work well by bringing 1 million records?

@kevwlew 3 года назад

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.

@DanielChristian19 3 года назад

Your welcome Kewlew!

@NelsonYYZ 4 года назад

Daniel, this is such a great video. Thank you SO MUCH for putting this together. So informative

@DanielChristian19 4 года назад

Glad you enjoyed it!

@sushichow 3 года назад

It’s like gold mine as I keep on digging I am able to find amazing content in Daniel videos.

@DanielChristian19 3 года назад

Wow, thanks, Susheel.

@jigsaw751 3 года назад

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.

@rsaikrishna 3 года назад

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.

@DanielChristian19 3 года назад

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.

@WillCooper1 3 года назад

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.

@DanielChristian19 3 года назад

Glad I could help. Keep PowerApping!

@manikyakotni5493 3 года назад

This is what am looking for. Great video Daniel. Appreciate your knowledge sharing.

@DanielChristian19 3 года назад

Glad it was helpful!

@andrewsmalley 3 года назад

Thanks Daniel, brilliant video - just what I needed!

@DanielChristian19 3 года назад

Glad it was helpful!

@imranpearl 3 года назад

This is amazing bro, exactly what I was looking for. You saved a day😊

@DanielChristian19 3 года назад

Glad I could help

@seegeat 3 года назад

Great Content, Daniel....very clearly and hope you always productive to create another power apps content

@DanielChristian19 3 года назад

Thanks for the compliment and there is more to come!

@ajitdas8343 2 года назад

Thanks Daniel for awesome session, my doubt go clear

@DanielChristian19 2 года назад

Glad to hear that!

@ajitdas8343 2 года назад

Thanks Daniel for awesome session

@DanielChristian19 2 года назад

My pleasure!

@taru250706 3 года назад

Thanks Daniel. As always, great video and to the point content

@DanielChristian19 3 года назад

Thanks for the compliment Tanvi!

@dragonjad 3 года назад

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?

@DanielChristian19 3 года назад

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)

@anandasuresh1 4 года назад

Amazing this is solution I'm looking for, thank you so much

@DanielChristian19 4 года назад

Thanks for compliment Amanda and keep Power Apping!

@ShitijBathla 3 года назад

Amazing! THANK YOU

@yessicadegranados8884 3 года назад

Once and again, thank you for your videos

@DanielChristian19 3 года назад

My pleasure!

@radiosonicfan1726 4 года назад

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.

@kylebroaddrick1222 5 месяцев назад

Thank you! Great video.

@DanielChristian19 5 месяцев назад

Glad you liked it!

@noshortcuttoglory6443 3 года назад

Very, very cool Daniel. And I just subscribed to your channel.

@DanielChristian19 3 года назад

Awesome, thank you!

@user-uk9hv8xg8s Год назад

Its nice article and very explain in short and simple. Thanks You so much.

@DanielChristian19 Год назад

Your welcome Pravin.

@sudheerbachu8077 3 года назад

Very useful information, thank you so much

@DanielChristian19 3 года назад

Thanks for the compliment, Sudheer!

@renzocanepacastillo 3 года назад

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!

@austinleedavisTeaches 3 года назад

"Import Spreadsheet" app. You get a like for that alone! :) Thank you also for showing an AND in the Filter function for SharePoint.

@DanielChristian19 3 года назад

Glad it helped!

@bibinbastian01 4 года назад

Really Cool Daniel,

@DanielChristian19 4 года назад

Thanks Bibin

@nicholasberglund 4 года назад

Well explained! Thank you!

@DanielChristian19 4 года назад

Thanks for the compliment!

@willsonsantoso4805 3 года назад

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?

@DanielChristian19 3 года назад

Filter with wild card is a great idea. Let me think through that and will record a block on that in the near future.

@FamEkin 3 года назад

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?

@DanielChristian19 3 года назад

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

@chrisrichardson6680 3 года назад

Great demo. Question: with the CDS -> Dataverse rename, can I assume that all CDS details in the demo are 100% applicable now to Dataverse?

@DanielChristian19 3 года назад

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.

@truptinalnikar 2 года назад

very informative !

@DanielChristian19 2 года назад

Glad it was helpful!

@LapaConsult_Ex_Macraris 3 года назад

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.

@DanielChristian19 3 года назад

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? ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-qU22DiaIPpU.html

@jhoncarlospenaarias9837 3 года назад

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

@DanielChristian19 3 года назад

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!

@ShyamKumar-rl3rw 3 года назад

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 🙏

@DanielChristian19 3 года назад

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

@poojashetty2195 2 года назад

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?

@russellniebolt1493 3 года назад

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 ?

@DanielChristian19 3 года назад

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.

@russellniebolt1493 3 года назад

@@DanielChristian19 Great, thanks for info.

@narendrareddy8420 3 года назад

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.

@DanielChristian19 3 года назад

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.

@andreasstrom131 3 года назад

Really good education!

@DanielChristian19 3 года назад

Thanks for the compliment Andreas!

@PC-hp6gz 4 года назад

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.

@DanielChristian19 4 года назад

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/

@alfonsobedonia9760 2 года назад

Hi Daniel. How did you solve the problem of activex control on chrome? I'm having that problem when importing the excel on sharepoint.

@VivekKaser 3 года назад

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.

@DanielChristian19 3 года назад

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.

@deniscloutier383 2 года назад

Thanks sooooooo much!

@DanielChristian19 2 года назад

Thanks Dennis. Glad it helped!

@markdiamante2927 3 года назад

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?

@DanielChristian19 3 года назад

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.

@markdiamante2927 3 года назад

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!

@JACKLAI1117 3 года назад

This is really a great video. Your vedio solve my problem ~~

@DanielChristian19 3 года назад

That's great news. Keep Power Apping!

@papithasekar9567 3 года назад

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?

@DanielChristian19 3 года назад

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/

@papithasekar9567 3 года назад

@@DanielChristian19 Thank you shall check the link

@2007pradipta 4 года назад

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?

@DanielChristian19 4 года назад

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!

@2007pradipta 4 года назад

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

@issiewizzie 3 года назад

At last real life example ....thanks

@DanielChristian19 3 года назад

Yeah, I try to make all my videos real life scenarios.

@patrickrojo7105 3 года назад

thank you. can you make a video that allows bulk upload with excel and saves to database?

@DanielChristian19 3 года назад

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.

@v75tan 3 года назад

how to filter only a few county for the list. like only ["YADKIN", "GUILFORD"] ....? Please help

@notonurnelly 4 года назад

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

@DanielChristian19 4 года назад

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.

@jhoncarlospenaarias9837 3 года назад

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.

@DanielChristian19 3 года назад

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.

@BboyDaquack 3 года назад

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

@t.shoemann5201 3 года назад

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?

@DanielChristian19 3 года назад

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.shoemann5201 3 года назад

@@DanielChristian19 Ah right. Makes sense! Thanks

@joek2904 4 года назад

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

@DanielChristian19 4 года назад

Take a look at this video, it will point you in the right direction. --> ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-QTbVMu6DIfQ.html

@joek2904 4 года назад

Daniel Christian thanks again!

@Baldur1005 4 года назад

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.

@DanielChristian19 4 года назад

Hey Artur, Try doing it in small sections such as a batch of 50 or 100 at a time.

@anandasanyal 4 года назад

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.

@DanielChristian19 4 года назад

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!

@anandasanyal 4 года назад

Hello again, I've tried below. it works without delegation error. Last(Sort(Project,ID,Ascending)).ID+1) Your comments please. Thank you.

@iniesta8488 3 года назад

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

@DanielChristian19 3 года назад

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!

@joek2904 4 года назад

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?

@DanielChristian19 4 года назад

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.

@joek2904 4 года назад

Daniel Christian thanks Daniel

@s1hl3 4 года назад

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?

@DanielChristian19 4 года назад

Hi S1h3l, A good friend of mine, Reza has covered this topic on his video. Take a look --> ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-eCMuXPI1Qok.html

@s1hl3 4 года назад

@@DanielChristian19 thanks Daniel will check it out

@RaniSingh-om8dp 4 года назад

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-om8dp 4 года назад

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

@DanielChristian19 4 года назад

That is correct. Just like I demoed in this video, SharePoint list is delegable as long as you use the correct functions.

@RaniSingh-om8dp 4 года назад

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.

@terabyte6585 3 года назад

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

@DanielChristian19 3 года назад

Thanks for the compliment Tera.

@mustafahussainmohsin320 3 года назад

@@DanielChristian19 Hi, if you don't mind sharing the patch code for SQL Datasource? I am actually confused

@DanielChristian19 3 года назад

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

@mustafahussainmohsin320 3 года назад

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

@danusranger 3 года назад

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?

@DanielChristian19 3 года назад

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.

@danusranger 3 года назад

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

@MrAfzalaziz 3 года назад

I never saw this major con of Power apps discussed anywhere that multiple users cannot work on the same app at same time.

@vaishnavvijayan2685 3 года назад

Hi Daniel, I have a dataset with nearly 450 columns. Can I use Sharepoint lists in this case for Powerapps?

@DanielChristian19 3 года назад

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

@vaishnavvijayan2685 3 года назад

@@DanielChristian19 Thanks Daniel

@corby8678 3 года назад

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)

@DanielChristian19 3 года назад

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.

@thanhdcbk 2 года назад

Hi Daniel, If the filter result for SP Online has more than 2000 records, can Powerapss retrive all of them?

@DanielChristian19 2 года назад

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.

@Rieske1969 4 года назад

Love the t-shirt

@masgitz 3 года назад

Christian, I want to try create drop-down using a 30k items. I've been wrestling with this all weekend. Any ideas

@DanielChristian19 3 года назад

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.

@masgitz 3 года назад

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

@DanielChristian19 3 года назад

Thanks for the compliment, Tigere. Keep Power Apping!

@GopiNath-jk8jq 3 года назад

sir, how to handle large data in cascading filter?? ... my table contains 15000 rows ..

@DanielChristian19 3 года назад

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-jk8jq 3 года назад

@@DanielChristian19 please explain one video demo sir

@UsagiNZ 4 года назад

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.

@DanielChristian19 4 года назад

Good point there Craig and you are 100% correct.

@UsagiNZ 4 года назад

@@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... :(

@ddntim 4 года назад

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

@saravanank1994 4 года назад

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

@RohitSingh-vc5gs 3 года назад

Is that a data table in powerapps or a gallery ?

@DanielChristian19 3 года назад

Hey Rohit, That is a gallery.

@RohitSingh-vc5gs 3 года назад

@@DanielChristian19 thanks

@rutujashreshth370 4 года назад

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

@DanielChristian19 4 года назад

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.

@rutujashreshth370 4 года назад

@@DanielChristian19 Thank you, through this solution i am able to get 2000 filtered records

@terabyte6585 3 года назад

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

@gtrj55tgjr 3 года назад

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

@DanielChristian19 3 года назад

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.