🔔HUGE SHAREPOINT NEWS! CLICK TO LEARN MORE🔔: bit.ly/3yIiE9D GET YOUR FREE COPY OF MY THREE SHAREPOINT TIPS TO SUPERCHARGE YOUR PRODUCTIVITY HERE: bit.ly/3Q921sH
Thanks for the video. Question for you if I may. If you exported a list into Excel and some of the entries from that list had comments attached to them how can those comments be added to the Excel file so that when the Excel file is then used to create a new list the comments are also included in the new list entries ?
Hello, what if i already have a Sharepoint List made from excel file and then i add a new column does that reflect to the existing list? If not is there a way?
If you want to import an Excel spreadsheet, but don't want all of the columns, should the spreadsheet be adjusted in Excel prior to import or is there a way to select the specific columns that you want prior to executing the import?
Hi there, if you skip to 5:02 of the tutorial, you'll notice that when I click on the data type drop down, the last option is "Do Not Import". Selecting that value will skip that specific column on the import process. Hope this helps! Thanks for watching.
Thanks for the video. Can I assume that if the Excel file being read from Library, any changes made in the file would be automatically reflected in the list? Or do we need Power Automate to set it up somehow to get updated in desired intervals? By changes I mean adding new rows mostly with no change in columns. Thanks.
Hi, no changes made to the source file would not update the List. If using a list stored in a library, SP would reference that file once during creation and that is it. You would need to setup a Power Automate flow to try & update the list after the fact. Hope this helps!
GM, nice video, Once the list is created will this be a editable input from within SharePoint? I have a user who wants data pulled from SharePoint to look like the Excel SS that they created. Your video helps me understand but just want to make sure or would we need to create a new view in SharePoint to display what they are asking for? Appreciation in advance!!
Hi there, yes would the list is created you will be able to edit the data within the list. You can edit items individually using the form view. Alternatively, you can use the quick edit function to allow for editing the data in a tabular view (similar to editing data in Excel). I've just posted this new video showing how to copy and paste data from an Excel spreadsheet to a SharePoint list which shows how to edit the data in a tabular format. ua-cam.com/video/vVaO6xBh36s/v-deo.html Hope this helps!
Thanks for video, Once the Computer list is imported on SP, can I import the excel file again with same name to SP whenever there is change in excel file through VBA. (In short can I import the excel file to replace the existing list with same name or update it from document library using VBA) I appreciate your help in advance thanks
Hi there, unfortunately you cannot update a Sharepoint List through importing an Excel Spreadsheet. To do this, you would need to build a workflow using Microsoft Power Automate. I am going to be posting a tutorial in the next few weeks outlining how to do this. What you can do is copy and paste the days from your spreadsheet to the Sharepoint list. Hope this helps! Thanks for watching
Hi Chris, my apologies for the delay. Unfortunately there is no way to update a list using out of the box functionality in SharePoint. There are some solutions posted on the Microsoft Tech Community that detail workflows you can build in Power Automate to do this and there are a few third party tools that can also do it. Although these are rather costly. I do have in my backlog to post a tutorial outlining how to create a workflow to do this in the future. Hope this helps and thanks for watching
🔔HUGE SHAREPOINT NEWS! CLICK TO LEARN MORE🔔: bit.ly/3yIiE9D
GET YOUR FREE COPY OF MY THREE SHAREPOINT TIPS TO SUPERCHARGE YOUR PRODUCTIVITY HERE:
bit.ly/3Q921sH
Love your video. No messing around and straight to the point
Glad you found it helpful! I try to get right to the point!
Does the sharpeoint list stay synced to the spreadsheet? So if people are updating the spreadsheet it always update the list?
Thanks for the video. Question for you if I may. If you exported a list into Excel and some of the entries from that list had comments attached to them how can those comments be added to the Excel file so that when the Excel file is then used to create a new list the comments are also included in the new list entries ?
Hello, what if i already have a Sharepoint List made from excel file and then i add a new column does that reflect to the existing list? If not is there a way?
If you want to import an Excel spreadsheet, but don't want all of the columns, should the spreadsheet be adjusted in Excel prior to import or is there a way to select the specific columns that you want prior to executing the import?
Hi there, if you skip to 5:02 of the tutorial, you'll notice that when I click on the data type drop down, the last option is "Do Not Import". Selecting that value will skip that specific column on the import process. Hope this helps! Thanks for watching.
Thanks for the video. Can I assume that if the Excel file being read from Library, any changes made in the file would be automatically reflected in the list? Or do we need Power Automate to set it up somehow to get updated in desired intervals? By changes I mean adding new rows mostly with no change in columns. Thanks.
Hi, no changes made to the source file would not update the List. If using a list stored in a library, SP would reference that file once during creation and that is it. You would need to setup a Power Automate flow to try & update the list after the fact. Hope this helps!
GM, nice video, Once the list is created will this be a editable input from within SharePoint? I have a user who wants data pulled from SharePoint to look like the Excel SS that they created. Your video helps me understand but just want to make sure or would we need to create a new view in SharePoint to display what they are asking for? Appreciation in advance!!
Hi there, yes would the list is created you will be able to edit the data within the list. You can edit items individually using the form view. Alternatively, you can use the quick edit function to allow for editing the data in a tabular view (similar to editing data in Excel). I've just posted this new video showing how to copy and paste data from an Excel spreadsheet to a SharePoint list which shows how to edit the data in a tabular format. ua-cam.com/video/vVaO6xBh36s/v-deo.html Hope this helps!
Thanks for video, Once the Computer list is imported on SP, can I import the excel file again with same name to SP whenever there is change in excel file through VBA. (In short can I import the excel file to replace the existing list with same name or update it from document library using VBA) I appreciate your help in advance thanks
Hi there, unfortunately you cannot update a Sharepoint List through importing an Excel Spreadsheet. To do this, you would need to build a workflow using Microsoft Power Automate. I am going to be posting a tutorial in the next few weeks outlining how to do this. What you can do is copy and paste the days from your spreadsheet to the Sharepoint list. Hope this helps! Thanks for watching
@@LuiIacobellis waiting for the Power Automate video!! :)
@@kristiandemian3955 Its next up on my list! I'm hoping it will be live in a week or so! Thanks for the comment and for watching!
Thank you but how to update an existing list from Excel is missing. Good tutorial though.
Hi Chris, my apologies for the delay. Unfortunately there is no way to update a list using out of the box functionality in SharePoint. There are some solutions posted on the Microsoft Tech Community that detail workflows you can build in Power Automate to do this and there are a few third party tools that can also do it. Although these are rather costly. I do have in my backlog to post a tutorial outlining how to create a workflow to do this in the future. Hope this helps and thanks for watching
How can I delete this list, this is not what I wanted
support.microsoft.com/en-us/office/delete-a-list-2a7bca5b-b8fd-4e5b-8f4b-2ac034f3070d