Impossible to open Autocad files using desktop instead of Web App in SharePoint Online doc library?
We are now running SharePoint Online (SPO). Our company has decided to get rid of a shared network file storage and move our Autocad files over to (SPO). I hit a bit of a snag with non-MS applications while trying to open them through the browser. We have AutoCAD files in our document library. When users try and click on it, it automatically tries and open it thorough Autodesk web app, which we never have. Is this already built-in for SPO? Why does it give me that option? I have activated the setting for the site to open using client application instead of the browser through the site collection settings and also the same in the document library settings advanced settings. I believe it only OPENS Microsoft based applications if we turn this on and not any other applications, correct? My questions are: Why did SPO show us the autodesk wep app option? Is it by default built into share point? How or why did that appear? Is the "open with client applications" only work for Microsoft products and nothing else like acrobat pdf, autocad, or other programs installed on the users computer? For example, if we have an application called ABC and creates a file with an extension .123 and we try and click in it we n share point, would it not show or gives us the option to “open with” ABC application on the user’s desktop? For example an autocad (.dwg) or acrobat (.pdf) or photoshop (.psd) or illustrator (.eps), etc... file via the web browser, won't open their desktop apps, correct? So how I can I make it open automatically using the desktop application and NOT the web app stored on the sharepoint online document library then like the ones I listed above if these applications were installed on that desktop? Can this be done or does the library have to be sync'd for it to work first? if sync'd to our personal one drive or organizational onedrive? How can we have users just click on an AutoCAD file, .dwg in SharePoint and have AutoCAD automatically open via the browser? Same with say a .pdf file via the browser? Or do we have to sync it and then open the file that way via file explorer and it will automatically open and use Autocad similar to that of a regular or network drive? The sync is soooo unbearably and unacceptably slow unlike Dropbox. Any suggestions? or impossible to use with Autocad desktop with SharePoint Online document library?
SharePoint Online: Get the Site Owner using PowerShell
Need powershell code to Get the Site Owner using PowerShell . I tried to using below code but the data is no accurate and no incorrect . #Variables for Admin Center $AdminCenterURL = https://89889-admin.sharepoint.com $CSVPath = "c:/temp/danny.csv" #Get Credentials to connect $Cred = Get-Credential #Connect to SharePoint Online and Azure AD Connect-SPOService -url $AdminCenterURL -Credential $Cred Connect-AzureAD -Credential $Cred | Out-Null #Get all Site Collections $Sites = Get-SPOSite -Limit ALL $SiteOwners = @() #Get Site Owners for each site collection $Sites | ForEach-Object { If($_.Template -like 'GROUP*') { $Site = Get-SPOSite -Identity $_.URL #Get Group Owners $GroupOwners = (Get-AzureADGroupOwner -ObjectId $Site.GroupID | Select -ExpandProperty UserPrincipalName) -join "; " } Else { $GroupOwners = $_.Owner } #Collect Data $SiteOwners += New-Object PSObject -Property @{ 'Site Title' = $_.Title 'URL' = $_.Url 'Owner(s)' = $GroupOwners } } #Get Site Owners $SiteOwners #Export Site Owners report to CSV $SiteOwners | Export-CSV -path $CSVPath -NoTypeInformation -Encoding utf8 -Append Need other code to help catch the sharepoint owner/site admin with accurate .
How to Upload file and the metadata of the document library properties using spfx react
I have create the spfx react webpart to to upload the the files and the metatdata of the document library but when i post the columns using the sphttprequest i have facing the issue of error 500 and throw a messeage To add an item to a document library, use SPFileCollection.Add() . please help me to resolve the iisue or any other solution to upload a document and create metadata of document library. Image sequence : Create the document Library Api response Webpart Structure Upload buttons function write in the code console error any other solution to perform CRUD Operation perform on document Library suggest me
How to edit a choice column data in sharepoint online
Hi, I have a list in SharePoint online with a choice column. When I tried to update the choice column data (already added some values), it is not changing on the list items grid. But when we go into the choice column in the list settings, we can see the changes. Is there any way I can edit/update a choice column data so that it will reflect the entire list. Any help is appreciated. Thank You, Jamuna
PnP Modern Search Filter - Managed Metadata fields display additional properties
The PnP Filter webpart uses the managed Property "RefinableString01" mapped to a "Fiscal Year" term set. There are additional properties being displayed that may seem confusing to end user and we would like only to display the years. There is a description of the Property bag properties values. https://microsoft-search.github.io/pnp-modern-search/usage/search-filters/
PowerShell script for SharePoint Audit
Hi all, I've been trying to run a script on PowerShell that will loop through each site on my company SharePoint and get all the users in each site and their user permission for the site (read, write, owner, etc.). Initially I ran this script: #Site collection URL $AdminSiteURL = "my site" $CSVPath = "my path" #Connect to SharePoint Online Admin Center Connect-PnPOnline -Url $AdminSiteURL -UseWebLogin #Array to store group data from all site collections $AllGroupsData = @() #Get all site collections in the SharePoint environment $SiteCollections = Get-PnPTenantSite #Loop through each site collection foreach ($SiteCollection in $SiteCollections) { $SiteURL = $SiteCollection.Url Write-Host "Processing Site Collection: $SiteURL" #Connect to the current site collection Connect-PnPOnline -Url $SiteURL -UseWebLogin #Get All Groups from the site collection - Exclude Hidden, Limited Access, and SharingLinks Groups $Groups = Get-PnPSiteGroup | Where { $_.LoginName -notlike "Limited Access*" -and $_.LoginName -notlike "SharingLinks*"} $GroupsData = @() foreach ($Group in $Groups) { $GroupsData += New-Object PSObject -Property @{ 'Group Name' = $Group.Title 'Permissions' = $Group.Roles -join "," 'Users' = $Group.Users -join "," } } #Add the group data of the current site collection to the array for all site collections $AllGroupsData += $GroupsData } #Export the data to CSV $AllGroupsData | Export-Csv $CSVPath -NoTypeInformation Write-Host "Group data for all site collections has been exported to: $CSVPath" This returned the permissions of some users that were on the site but not part of the site group. For the the users who were part of the site group, they showed up on the report as GUID's like this ('4cbc76d6-7da9-42bb-a403-85594b1a4cf9'). I then edited the script to display user names instead of GUID's using this script: #Site collection URL $AdminSiteURL = "my site" $CSVPath = "my path" #Connect to SharePoint Online Admin Center Connect-PnPOnline -Url $AdminSiteURL -UseWebLogin #Array to store group data from all site collections $AllGroupsData = @() #Get all site collections in the SharePoint environment $SiteCollections = Get-PnPTenantSite #Loop through each site collection foreach ($SiteCollection in $SiteCollections) { $SiteURL = $SiteCollection.Url Write-Host "Processing Site Collection: $SiteURL" #Connect to the current site collection Connect-PnPOnline -Url $SiteURL -UseWebLogin #Get All Groups from the site collection - Exclude Hidden, Limited Access, and SharingLinks Groups $Groups = Get-PnPSiteGroup | Where { $_.LoginName -notlike "Limited Access*" -and $_.LoginName -notlike "SharingLinks*"} $GroupsData = @() foreach ($Group in $Groups) { $Users = $Group.Users | ForEach-Object { $UserGUID = $_.Id $User = Get-PnPUserProfileProperty -Account $UserGUID -PropertyName 'PreferredName' $User.PreferredName } $GroupsData += New-Object PSObject -Property @{ 'Group Name' = $Group.Title 'Permissions' = $Group.Roles -join "," 'Users' = $Users -join "," } } #Add the group data of the current site collection to the array for all site collections $AllGroupsData += $GroupsData } #Export the data to CSV $AllGroupsData | Export-Csv $CSVPath -NoTypeInformation Write-Host "Group data for all site collections has been exported to: $CSVPath" However, this resulted in the users showing up as commas on the report like this ',' or ',,'. My understanding is that this suggests that there might be an issue with how the user data is being processed and concatenated and that it's possible that the '$Group.Users' array contains empty or null values, leading to these commas in the output. If anyone could provide me with any information on how I could resolve this, I would be very grateful.
