Can you actually select the item to go on a custom form? I have 2600 people that I need to just be able to select a single person and add it to the form.
If I understood your question correctly that there 2600people list item and if you select 1item then a custom form will open and with selected people..then to answer question yes it is possible
Basically activitycount stores the I'd of the item...you need to update it...while creating the new item you can make 2nd call to update acitivitycount
@@tech365. Thank you. But sorry I still don't understand how to make activitycount working like in this video. It will be better if you can make another video to explain activitcount.
So there will be multiple patch...one Set(Result,Patch(source,Defaults(source),yourdata).,then in second Patch(source,Result,yourdata to save Activity count)
@@tech365. I got worked by adding a new column 'year' and used clear collect. By this I got abot 3200 files. But when I add a new file (directly in sharepoint ), it is not showing in power apps collections. I tried clear collect, also tried refreshing datasource, but no use. Only showing items already there in sharepoint when the app was created, not showing any new records
@@tech365. using power autimate, unfortunately the flow was not working as expected, so the columns didn't updated. It is rectified and flow is running.
Hi, thanks for the great information. Could you help me to associate the ID column to the Indexed column that I just created? I've created the indexed column but they have no values, I'm not sure how to give the ID as the value for my indexed column. Thankyou
So, when you creating item in Sharepoint, whatever way you are using you will get the ID in return. then you need to update the same record with returned ID
Hi I have a date picker for searching the data but the picker is not working for previous year. only picking the current year can you please guide me how to resolve this
Thanks for your video! It's very helpful! just a question that how to edit the content of this list? The data source of the EditScreen is probably ActivityColl which will be updated after submit the form. how to reflect the change to the original SharePoint list "ActivityList"?
PowerApps itself available as apk. Means you can download PowerApps from Play store. and all the apps which is developed in powerapps within your organisation and shared by the users will be visible in PowerApps application
I never tried with SQL but with my approach if it work with indexed column, then you can get as much as you want, but remember heavy data performance will be decrease
Hi Shubham, thanks for the video! It worked out great :). Just one question: with the limit of 2000 rows I could use ThisItem.Attachment to get the images of that item. After exceeding this limit by using the method in your video the ThisItem.Attachment is not showed anymore .. Do you know how to fix this?
ActivityCount is a column which can have the value Id of the item... So how can you save it... It depends on how you are saving item.... If from powerapps then first you need to create item & you will get id of the item in return... Then update the same item with the return id
Yes...Create one number column and index that column.... Now whenever any item is getting created, update that index column with the item id.... So in powerapps will get the data based on that index column...
Good video that explains a workaround for a hectic Microsoft constrain! Good job!
Hi all, great vid, just wondering what ActivityColl is referring to? I can't make it work because I'm not sure what to point that to in my setup.
Hello, ActivityColl is a collection that contains filtered data from the list ActivityList based on ActivityCount which contains the ID of the item.
@@tech365. Can you please provide some more information on this? I am still unable to figure out something corresponding to ActivityColl in my app.
It is just a collection name....you can use any name as your wish....collection name is something which we define
At 8:37 ~ What is 'Name of the collection' i.e. ActivityColl?
And how can I find my 'name of the collection' ?
Hi Jay,
ActivityColl is a collection where I am storing all data from the list. ActivityColl is just a name, you can have any name there.
Have you noticed any performance issue using this work around?
Upto 5000 works fine beyond that it may lag
Can you actually select the item to go on a custom form? I have 2600 people that I need to just be able to select a single person and add it to the form.
If I understood your question correctly that there 2600people list item and if you select 1item then a custom form will open and with selected people..then to answer question yes it is possible
Will this even work for SharePoint documents library
Hi, thanks for the video. Can you please explain how to create an index column as well.
Hello... will update you soon
Can you add additional records into the SharePoint list? can activitycount update its new data accordingly?
Basically activitycount stores the I'd of the item...you need to update it...while creating the new item you can make 2nd call to update acitivitycount
@@tech365. Thank you. But sorry I still don't understand how to make activitycount working like in this video. It will be better if you can make another video to explain activitcount.
how to get that id( generated after creating item) to ActivityCount column( which is number type)
Use this Set(Result, Patch())...so patch function returns a record and it will get saved in Result.,then you can use Result.ID
@@tech365. how that Result.ID pass to ActivityCount column in sharepoint list
So there will be multiple patch...one Set(Result,Patch(source,Defaults(source),yourdata).,then in second Patch(source,Result,yourdata to save Activity count)
@@tech365. thanks
Is it ok to use collections to fetch more than 2000 records ? They consume network and memory .
Upto 5000 I think it will be ok...It depends on what you want. You can use these solution in different way also
How do you assign activitycount otherthan using calculated column, are you using flow for an existing document library in sharepoint
I am using multiple call in powerapps to update the column.... First save id will be generated. Then update the same item with id
@@tech365. I got worked by adding a new column 'year' and used clear collect. By this I got abot 3200 files.
But when I add a new file (directly in sharepoint ), it is not showing in power apps collections.
I tried clear collect, also tried refreshing datasource, but no use.
Only showing items already there in sharepoint when the app was created, not showing any new records
How year column is getting updated?
@@tech365. using power autimate, unfortunately the flow was not working as expected, so the columns didn't updated.
It is rectified and flow is running.
@@NP-zg3hq Oh great
Amazing ,very informative, looking forward for other videos.👍
Hi, thanks for the great information. Could you help me to associate the ID column to the Indexed column that I just created? I've created the indexed column but they have no values, I'm not sure how to give the ID as the value for my indexed column. Thankyou
So, when you creating item in Sharepoint, whatever way you are using you will get the ID in return. then you need to update the same record with returned ID
@@tech365. Hi, based on your videos, column ActivityCount must has the same number with ID Column?
Yes..
@@tech365. thanks, now i can use your solution :)
Great 👍
Hi I have a date picker for searching the data but the picker is not working for previous year. only picking the current year can you please guide me how to resolve this
Hi... Yes sure... Could you please provide more details like how many records are there and how you are filtering the data.
Thanks for your video! It's very helpful! just a question that how to edit the content of this list? The data source of the EditScreen is probably ActivityColl which will be updated after submit the form. how to reflect the change to the original SharePoint list "ActivityList"?
Am I able to apply this method using excel file instead?
Hmm.. Not sure on this... Need to check
How to build akp in power app
PowerApps itself available as apk. Means you can download PowerApps from Play store. and all the apps which is developed in powerapps within your organisation and shared by the users will be visible in PowerApps application
Great Video！Thanks. And I am wondering where I can find your next video , PowerApps tip - Part 2(attachment to document library)
Thank you....Will be coming soon this week...
Hi Subham, Great Video, thanks for your efforts.
What's the maximum data limit we can get by using this method. My data source is SQL.
I never tried with SQL but with my approach if it work with indexed column, then you can get as much as you want, but remember heavy data performance will be decrease
Hi Shubham, thanks for the video! It worked out great :). Just one question: with the limit of 2000 rows I could use ThisItem.Attachment to get the images of that item. After exceeding this limit by using the method in your video the ThisItem.Attachment is not showed anymore .. Do you know how to fix this?
Need to check this...I will and get back to you soon
Thanks for the video, very elucidative ! do you think That 4000 is a good amount to Run the app without any major concerns?
For 4000 i don't think there will be any issue...
how to you configure the ActivityCount in Sharepoint?
ActivityCount is a column which can have the value Id of the item... So how can you save it... It depends on how you are saving item.... If from powerapps then first you need to create item & you will get id of the item in return... Then update the same item with the return id
Hi Shubham, could you please help with the “colum activitycount” i have 0 results at the final, regards
Yes...Create one number column and index that column.... Now whenever any item is getting created, update that index column with the item id.... So in powerapps will get the data based on that index column...
@@tech365. Hi, how do you update the index column with the item ID? Is that done in powerapps or in sharepoint? Thanks
@@hevj27 In powerapps...
Informative video, pls keep make new videos
Thank you... Yes sure...
Thank you so much briooo.. really useful
Thank you...
Great job…very helpful
Thanks for sharing knowledge
Thanks a lot!!!!!
Thank you so much Bro
It's working 👍
bro go basics to advance in power apps
Yes.. Will do soon
Nice
excelente. me funciona super para 6.000
Genial ... gracias