Wednesday, June 21, 2023

Import Sharepoint People Column to Dataverse

 Please note that the option to import an excel sheet as described is not available in Dataverse for Teams.  An untested work around could be to import in a non teams environment, and then export/import the solution to the Teams environment.



Update: dont forget to make the sheet vlookup constant i.e. =VLOOKUP(L2,Sheet1!$A$1:$T$550,19,FALSE)

Wednesday, February 8, 2023

Sharepoint online: Changing the URL of a library or list

 This is what worked for me in 2023.

The difficulty arises because Sharepoint Designer has not been updated and is not across Multi Factor Authentication.

Download and install Sharepoint Designer and two updates as follows.

Sharepoint 2013 Download

Sharepoint Designer Service Pack One

Update August 2016


Then go into your account settings in Sharepoint and get an app password







Use that to switch account in Sharepoint Designer once it is installed.

IMPORTANT: To connect to the site make sure you use https:// prefix


Then in "All files" change the name of the list (it looks like a FOLDER icon) by hovering and changing within the list.



Voila!

Import Sharepoint People Column to Dataverse

 Please note that the option to import an excel sheet as described is not available in Dataverse for Teams.  An untested work around could b...