Jerry_MSFT
  • Member for 2 years, 10 months
  • Last seen more than a month ago
SharePoint Online Guest Access and Share Capability
4 votes

There is a workaround will fulfill your requirement to some extent. Go SharePoint Admin Center(new)>Policies>Sharing>Advanced settings for external Sharing. Do not choose "Allow guest users to share ...

View answer
How to format toLocaleDateString([$MyDateTimeColumn]) to return YYYY-MM-DD?
Accepted answer
3 votes

Per my test and search, it seems the toLocaleDateString() cannot convert date format. We can do it manually with an expression like this: =getYear(@currentField)+'-'+(getMonth(@currentField)+1)+'-'+...

View answer
SharePoint 2019: Moving documents between Site Collections
Accepted answer
3 votes

Try the script below with copy and remove way to do this. I changed a bit from your script. It works in my end properly. Connect-PnPOnline -Url siteURL Get-PnPList Get-PnPFeature -Scope Site $...

View answer
Image Store that is Accessible by all Subsites in Site Collection
Accepted answer
3 votes

A bit more things to add, from the doc Robert provide Adding an organization assets library will enable a content delivery network (CDN) for your organization to provide fast and reliable ...

View answer
How to check SharePoint Online site type
Accepted answer
2 votes

You can use the SharePoint Online Management Shell to run a PowerShell cmdlet to get the template id and compare to known site template values: $adminUPN=<admin account> $userCredential = Get-...

View answer
What is List Workflow
Accepted answer
2 votes

SharePoint workflow can be categorized to site workflow, list workflow and reusable workflow. List Workflow is workflow which is Associated with one particular List. It waits for events happened on ...

View answer
How do we vertically delete values from a single column?
2 votes

Here is a workaround which may be easier to carry out. Select all items with the toggle selection. Click edit button, then you will be edit the column value in bulk. Note: This operation also has ...

View answer
I accidently deleted the default Edit permission at site level
2 votes

By default the edit permission level cannot be deleted via UI. It cannot be selected to modify. How do you delete it? Anyway you can create a new permission level with the same permission settings.

View answer
Deprive all users permission from SharePoint site except specific user by Power Automate
Accepted answer
2 votes

For using flow to remove user site permission, we will need to use rest api and call the http request to do so. The most default way can be remove user from permission group, and a simple demo will be ...

View answer
How to give permission to a SharePoint Group to edit the membership of another SharePoint group (SharePoint 2016)
2 votes

I guess you want the group members be able to edit permission of other group? If so, for default permission levels, you will need to grant full control. When you edit permission level, you can find ...

View answer
Calculate Column Based On Self (Circular Reference Workaround)
2 votes

For recording the time when the status change, I will suggest you to use a flow. You cannot do a self reference in calculated column, but you can add an if condition in flow to check the Date of ...

View answer
How to restrict file extensions in document library
Accepted answer
2 votes

For now, there is no OOB approach to block certain file types in a library, Here is a User Voice where you can vote for adding this feature.

View answer
Is there a way to disable Modern List Comments?
Accepted answer
2 votes

You will need to disable it at tenant level with the cmdlet: Set-SPOTenant -CommentsOnListItemsDisabled $True Microsoft documentation: Set-SPOTenant It may take some time to update the change.

View answer
Get report of all site collections using SMAT tool
2 votes

Do you simply want to have a list to show all the site collections with subsites? If so, a PowerShell script will be enough. Like this one:https://www.sharepointdiary.com/2016/02/sharepoint-site-...

View answer
Best way to store Images in SharePoint Online
2 votes

Per my knowledge, for now SharePoint Online no longer supports reading EXIF data from images. You can vote in user Voice here: https://sharepoint.uservoice.com/forums/329214-sites-and-collaboration/...

View answer
Calculated columns cannot contain volatile functions like Today and Me
2 votes

We simply cannot use [Today] or [Me] in calculated columns. Use formulas like =DATEVALUE(TEXT(NOW(),"mm/dd/yyyy")) - DATEVALUE(TEXT([Created],"mm/dd/yyyy")) or =TEXT(NOW(),"...

View answer
Sub-site left side navigation transfer to top navigation bar?
2 votes

The navigation on the left hand-side is called Quick Launch Navigation, and SharePoint have another type of navigation called Global Navigation which is placed on the top bar. Simply we cannot move ...

View answer
How to rename multiple files in SharePoint?
2 votes

Rune's script is great. One thing to add is that you it may be better to use Connect-PnPOnline -Url https://domain.sharepoint.com/sites/sitename -Credentials (Get-Credential) There are chances user ...

View answer
SharePoint Custom form using SharePoint Designer
2 votes

As SharePoint does not have have column level permission settings. If you put everything in the same list, you will have no way to avoid mistakes like fields modified by another team. Any user who has ...

View answer
How to enable SharePoint search for partial words?
2 votes

Just like Trevor said, wildcard character will help you. For more information about the Keyword search query, please check this: Keyword Query Language (KQL) syntax reference It will help you better ...

View answer
leave balance sharepoint 000
2 votes

Tally's way is the simplest solution which will works perfect for simple calculation. Another option is to use flow. Make the leave balance list view only for the end users, then in the list where ...

View answer
Use Flow to update/delete events on Online Sharepoint's Group calendar
2 votes

In the flow you use to create event in outlook calendar, add one more step to store the event id of the event in calendar to the list Item. Then you can create a second flow to the list, when an item ...

View answer
Organization Chart in Sharepoint Online
Accepted answer
2 votes

For SharePoint online, there is no such feature as a web part. Here is a user voice vote about it, have a check and vote here. For now, you can check the organization chart via the contact card. ...

View answer
Need SharePoint 2013 Development Environment
Accepted answer
2 votes

There are trial keys for evaluation for 180 days. So you can avoid the cost of the software. Deploy it on your own machine. https://www.microsoft.com/en-us/evalcenter/evaluate-sharepoint-server-2013 ...

View answer
Given a SharePoint site collection URL, how can you determine if it is SharePoint Online or SharePoint On-Prem?
Accepted answer
2 votes

For most circumstances, If it is SPO, it is cloud SharePoint and contains 'sharepoint.com' as part of the FQDN. Anything else shall be on-prem SharePoint. If there are custom domains with a URL like ...

View answer
Most used Files View
2 votes

ed, For SharePoint Online, a new view is not the best tool to do this. The workaround I think will work better in modern experience is the Highlighted content web part which dynamically display ...

View answer
Using Flow to get Lookup Column Value and use these Value to calculate
Accepted answer
2 votes

It seems currencies is a lookup column. It can be with a flow like below. Use the currency id to find the corresponding exRate in the currency list and set the exRate to the current item Exchange Rate ...

View answer
Display a calculated Timestamp when a particular choice is selected (Sharepoint list)
Accepted answer
2 votes

Carl, Try this formula. =IF(Status="Ready to Review",TEXT(NOW(),"dd/mm/yyyy hh:mm"),IF(ISBLANK(Status),"","NULL")) It works in my online list properly. Update: It will update the timestamp every ...

View answer
Change in site structure
2 votes

Per my knowledge it is not doable to change a sub-site to the root site. Here is approach you can have a try. If you have the site collection administrator permission, visit "http://yoursite/...

View answer
Is it possible to filter search results when searching in a modern document library?
Accepted answer
2 votes

according to the official doc, there is no way to enable filtering of search results. "The modern search experience doesn't support changing the sort order of results or building refiners based on ...

View answer
1
2 3 4 5
22