วีดีโอ

Yes you can add records by using this. Just paste it below the table. The new rows should get included int he table automatically. If not, resize the table to include all the data you have pasted and click on save.

Thanks, glad you liked it!

Correct. We would have to control the number of columns visible on the screen at a time.

it seems that it does not inherit the ID Created by SharePoint, is there any workaround? Many thanks.

Can you help me

@@HaHoang-c7e Yes Please make sure auto save is off. Load the table after turning off auto save.

Thanh you very much. I followed your instructions and I can able to save changes share point list

Đó you have any video tutorial on how to download only part of the data to excel? Since my data is very large, ít takes a long time to download the whole data tổ excel while I only change some in the tâble

Never encountered this error while using the file. Will upload a template with unlocked vba shortly

have removed the password from the file. You can download it on this link - th-cam.com/users/redirect?event=comments&redir_token=QUFFLUhqbTMwYzYybTJrMm5iTW1DV0tPUE1HVVdUZVFXZ3xBQ3Jtc0tsV2RRc2N4bTZQbTUxVUFxVHNRdndrYlo0R2g3Skd2Q0xwYWJGWE9pbmNlUVFjbWpOVWU1ZXVzWGVQUzFuYzJhZWhVTUEzNmZCdHhQNTNtS0xCeVdKWFdQdjZMQmxoSlUyZEVxOWx4M1ZwMEhvekVwaw&q=https%3A%2F%2Fdrive.google.com%2Fuc%3Fexport%3Ddownload%26id%3D1XyuyD2zIHuyPxoypF5cs4aEestDMXec7

I resolved this by saving the file to my local machine and running it from there. I found storing the file in sharepoint and running it threw this error also..

Getting the same error at updatechanges - please help

Seems updatechanges method is deprecated after office 2007

Hi Sorry to hear that. Have never encountered this error. There is not much about this error online. Try out this forum. (forums.autodesk.com/t5/inventor-programming-ilogic/quot-expecting-object-to-be-local-quot/td-p/11761494)

Hi, Did you manage to solve it? I got the same and trying to but have no idea how to manage it

@@DataMasterDizaster Did you renamed the sheet from the VB Editor. "HomeSh". Can you share a screenshot of the project explorer here. So we see how the sheets are named

Hi Erica, compose_Input would not be available in Powerapps (V2) trigger. In that if you expand the trigger you would see "Add an input" option. Once you click on it, you would see options to select type of input. You would need to select "Text" type. Then give it any name. You can use this newly created input in compose from the dynamic content instead of "compose_input", and then continue with the same steps as in the video. Cheers. Thank you for watching :)

Thank you for watching. You can download the file using this link - drive.google.com/uc?export=download&id=1XyuyD2zIHuyPxoypF5cs4aEestDMXec7 Regarding crashing file, that might happen if too many excel files are open and there isn't enough memory. You can try closing all files and try this or try opening another instance of excel. Try to use the file downloaded from this link, that would solve in case anything was missed in the code. Hope this works out :)

@@thepowertutorials the excel file is locked, how to enable this.

​@@AnandPenmatcha The VBA has been unlocked now. Please download using the same link

@@thepowertutorials thank you

hey there thanks for watching. I am sorry, I didn't get the question. Compile error is due to invalid syntax. You can use "compile VBAProject" option under debug to locate the line causing the issue.

​@@thepowertutorials I solve it. it was a typing mistake . thx for you video a lot

Yes it can be done. Will try to post a video explaining that asap. :)

@@thepowertutorials Awesome! I can't wait. It's been such a headache trying to figure out how to collect everything into a new collection that looks just like the pivot table (with headers and everything). My main goal is to export that collection into a csv file with power automate.

@@thepowertutorials any updates sir regarding export

@@user-bx3op7nl4c Hi Would be uploading it shortly.

@@thepowertutorials Any news on this?

What is the error?

I would need much more info for that. The structure of you SharePoint table including data types and exact functions you are using.

Thank you! I personally use it a lot.

You would need to use delegable operators in your functions. Plus you would need to make sure none of the functions return more than max 2000 rows. Would need to see the exact function to provide an exact answer

good luck with that

Sure will try to create one

What is the link you are using to download?

Please download again. Have removed the password

Had removed the password please try again

there can be multiple reasons for that. Most common would be incorrect site link or GUID. Please make sure they are correct as explained in the video.

Hi there. It is available on this link: drive.google.com/uc?export=download&id=1XyuyD2zIHuyPxoypF5cs4aEestDMXec7

Please download again. Have removed the password

@@thepowertutorials still proteced by password. did you have a new link. I tried the 2 links in the comments

Can you explain how to get the "Load" button on the sheet?

insert a shape. Then right click on it. click on assign macros. then select the macro you would like to link to it.

you can download it using this link - drive.google.com/uc?export=download&id=1XyuyD2zIHuyPxoypF5cs4aEestDMXec7

Template is protected, need password to use it

You can put a filter on default view of ur sharepoint. Like Id =0. If you load the table after applying this filter, a table with 0 rows would be loaded. You can add your data and save

Thank you! Sure will try to upload it as soon as possible.

Thank you! : ) That's the plan