SharePoint Export to Excel data connection refresh issue
Hi Team, I have created a list on SharePoint and want to be able to create a data connection between this list and excel. The first requirement is that when infomation is updated on the SharePoint list, I need to be able to simply click refresh all in excel and the changes made in the SharePoint list will then automatically update in excel. This is working fine. My problem lies in the second requirement below. The second requirement is that I want to be able to add my own columns in the excel e.g. a Comments field so I can make my own notes for each SharePoint item I only want these notes only to be reflected in excel. Screenshot below shows that Task 1 is aligned to Comments 1 and so on. When I add a new task into the SharePoint list and then click refresh the excel file, the comments should be still aligned to the task. Screenshot shows Task 4 being added. However when I refresh the data connection, Task 4 has correctly been added to the excel file but it Task 3 comments is now blank and Task 4 has comment 3. Task 3 should have still contain comments 3 and Task 4 should have no comments as per the comments below.
How to access synced Edge profiles via MSGraph?
I've been really interested to find information on how to access Edge's synced profile data (History/Collections/Bookmarks/etc) via some remote MS API endpoint but none of my research/posting has gotten me anywhere Despite lots of googlefu (or bingfu? if that's a thing), everything I found about retrieving Edge profile/usage data involved interfacing with the local filesystem to query the installed browser's SQLite database (found in the internal program files). But seeing as Edge syncs data to a MS account, it must mean that it's stored somewhere in the MS cloud universe (although perhaps it's not being handled by the same MS accounts backend). I honestly just expected Edge data to be accessible on the MSGraph API but I've yet to find anything related to Edge profile data (or even future/abandoned/discussed integration goals). Maybe some hero on the inside could shed some light into this, any discussion would be very much appreciated! Reposted from Edge Insider community group
