Questions tagged [sharepoint-online]
14 questions
2
votes
0 answers
Highlight row if any value in the row cells is changed only today
I have a shared sheet called "Daily Status", people update their respective rows daily, I want to highlight row if it is not updated today.
For example below sheet, 2 out of 3 people updated their row, but John did not updated his status for the…
Sameer
- 121
2
votes
1 answer
XLOOKUP with a second condition
I have a table like the following:
In column "F", I would like to have the text from Column "C", however, only if "Condition" from column "B" is "CondB".
If I use the formula written in "F2" - "=XLOOKUP(E2; A:A; C:C)", it always just takes the…
Servus
- 107
1
vote
1 answer
=DATEVALUE() behaving different in Excel 365 online and Excel 365 local
I noticed that =DATEVALUE() behaves different in the online version of Excel 365 (i.e. it does not work) than in the local version of Excel 365 on my PC. Below are two screenshots of the two Excel Versions.
Any idea on how I can get the formula to…
Servus
- 107
1
vote
1 answer
How do you have a URL in homepage of Edge Chromium?
We set a homepage through GPO's on all PC's in the domain. When you open a new tab our SharePoint online intranet opens.
As it's a new tab, the URL field is empty, ready to go to the site you want.
But if people navigate through our intranet…
Brtrnd
- 303
- 2
- 12
0
votes
0 answers
Trying to log in to sharepoint.com yet failing
I'm logged in into my MS account at the Edge browser. Now I've done the same at Chrome browser. Yet, I fail to log into sharepoint.com (OneDrive) of MS at the Chrome browser, see the shot: https://prnt.sc/dv2Z3c49vpmk
Why is that ? Any way out ?
Igor Savinkin
- 163
0
votes
0 answers
Office online not respecting regional date setings
I work for a US based global organisation, and they host our Sharepoint. However, despite me setting local regional settings I am seeing that online regional settings are not being respected.
I believe my Microsoft /365 online settings are correctly…
Topdown
- 142
0
votes
0 answers
OneDrive "Online Files" use up all your disk space
There is a bug in some older (Build 23.xxx) versions, that are still shipping in recent Windows 11 images.
When you sync files with On Demand turned on, the sparse files are not created correctly, and all the supposedly empty files take up real disk…
Dom
- 885
- 5
- 11
- 22
0
votes
0 answers
Invoke-PnPTenantTemplate -Verbose will raise this error "Acquiring oAuth token for permission scope Group.ReadWrite.All. Access token acquired"
I have 2 office 365 tenants (Source & Destination). I used this command to get the Source communication site template inside my PowerShell 7.0 version 7.3.4:-
PS C:\Users\mohan> Connect-PnPOnline -Url "https://source.sharepoint.com/sites/PPM-test/"…
0
votes
0 answers
Allow SharePoint site owner to extend guest expiration (SPO)
I understand that by default, only site collection/SharePoint admins can extend guest expiration. But this isn't practical for my purposes. I want site owners to also be able to do this. If there is a way to customize it so some site owners can and…
Rets86
- 31
0
votes
0 answers
MS Teams: Created team with PS is not visible in admin.teams portal but is in teams app
I create all our teams in powershell. From the 900 there is 1 with problems.
It is visible in:
teams app
endpoint
in powershell with get-team -groupid " "
not visible in:
admin.teams portal
admin.sharepoint portal
admin.microsoft portal
PS…
0
votes
1 answer
Add a site language using powershell Pnponline or SPOService
I create users via a ps command like this
New-MsolUser -UserPrincipalName $user.Email -Password $user.Password [...] -PreferredLanguage fr-FR
Knowing that the tenant is in German (de-DE) all the web apps are in german (See image)
So i need to…
Andy McRae
- 376
0
votes
1 answer
How do I change my Excel online pivot table to tabular layout?
I'm building a pivot table in Excel Online. I'd like it to be in a tabular layout. Following the instructions I see online say to go to pivot table settings, but I can't see how to make the change to tabular settings. Below is an example of my…
Frank
- 139
0
votes
0 answers
Can Teams messages be searched along with Outlook Email messages?
I'm tired of having to flip back and forth between Teams and Outlook to look for communications.
Is it possible to search all of them in one place? Maybe in a web interface somewhere?
leeand00
- 23,552
0
votes
1 answer
Can a Microsoft Teams Calendar be pulled into Outlook integrated multiple Calendars?
In Microsoft Teams, one can add a Calendar tab to a Microsoft Teams channel.
Can these be pulled into Microsoft Outlook in a way that overlays all of the calendars, including your personal and other people's calendars displayed on one calendar?
leeand00
- 23,552