Category: Microsoft
Category Archives: Microsoft
Viewing Draft Version
Good morning everyone,
I’ve configured a custom list with specific versioning settings as follows:
Content approval for submitted items is required: YesCreate a new version each time an item is edited in this list: YesVisibility of draft items: Only users who can edit items
Each user is assigned to a different SharePoint Group + READ GROUP (For views), referred to as an “Entity.” The business owner has the authority to change the assigned Entity for an item.
When an Entity is changed, an event handler is triggered to revoke the previous permissions and grant EDIT permissions to the new Entity. Consequently, the item’s Approval status transitions from Approved to Pending.
The issue arises when the Entity is changed, and despite the event handler removing the old permissions and assigning EDIT permissions to the new Entity, the Approval status remains Pending. Furthermore, the user who initiated the Entity change continues to see the item as a draft, even if their Entity lacks permissions for it.
E.G:
Business created an item on behalf an Entity XXXXX (Approval Status remaining all the time Pending)
Was given EDIT item permissions to Entity XXX Only the Entity XXX and business can see it -> CorrectEntity XXX change the item to Entity YYYOnly the Entity YYY and business can see it -> CorrectThe user who change the entity also can see -> WRONG
I cannot understand what is wrong in the configuration or code, since the draft security is:
Visibility of draft items: Only users who can edit items
Good morning everyone,I’ve configured a custom list with specific versioning settings as follows:Content approval for submitted items is required: YesCreate a new version each time an item is edited in this list: YesVisibility of draft items: Only users who can edit itemsEach user is assigned to a different SharePoint Group + READ GROUP (For views), referred to as an “Entity.” The business owner has the authority to change the assigned Entity for an item. When an Entity is changed, an event handler is triggered to revoke the previous permissions and grant EDIT permissions to the new Entity. Consequently, the item’s Approval status transitions from Approved to Pending. The issue arises when the Entity is changed, and despite the event handler removing the old permissions and assigning EDIT permissions to the new Entity, the Approval status remains Pending. Furthermore, the user who initiated the Entity change continues to see the item as a draft, even if their Entity lacks permissions for it. E.G:Business created an item on behalf an Entity XXXXX (Approval Status remaining all the time Pending)Was given EDIT item permissions to Entity XXX Only the Entity XXX and business can see it -> CorrectEntity XXX change the item to Entity YYYOnly the Entity YYY and business can see it -> CorrectThe user who change the entity also can see -> WRONGI cannot understand what is wrong in the configuration or code, since the draft security is:Visibility of draft items: Only users who can edit items Read More
Setting an invoice tracker up and looking to have ‘due date’ highlight in green and ‘past due’ red
Hi All,
As title suggests I’m trying to set up a sheet to track paid and unpaid invoices.
Example:
Date (A6), Client (B6), Invoice number (C6), Location (D6), Date Completed (E6), Rate (F6), Due Date (G6) and Date Paid (H6)
Can anyone help me work out how to have cell (G6) turn red if it goes over seven days from (E6) so I can send a friendly reminder to my clients.
Formulas for this have me stumped.
Hi All, As title suggests I’m trying to set up a sheet to track paid and unpaid invoices. Example:Date (A6), Client (B6), Invoice number (C6), Location (D6), Date Completed (E6), Rate (F6), Due Date (G6) and Date Paid (H6) Can anyone help me work out how to have cell (G6) turn red if it goes over seven days from (E6) so I can send a friendly reminder to my clients. Formulas for this have me stumped. Read More
How to open entire SharePoint Subsite in Popup
I am using SP online and doing customizations using SPFx technology.
Is there any way OOTB or through SPFx which allow to open entire subsite in a popup window?
I am using SP online and doing customizations using SPFx technology.Is there any way OOTB or through SPFx which allow to open entire subsite in a popup window? Read More
Using VBA to filter 2 slicers
Hi.
I have 2 Pivot tables in a worksheet, both connected to their own query from an SQL database. What i am looking to do is filter both pivots using 1 slicer. After extensive research, i discovered this couldn’t be done (even by amending the report connections). So my plan now is to add a slicer to each pivot and link the 2 using VBA, however my code isn’t working:
Private Sub Worksheet_PivotTableUpdate(ByVal Target As PivotTable)
Dim ws As Worksheet
Dim pt As PivotTable
Dim slc1 As slicer
Dim slc2 As slicer
Dim slc1Name As String
Dim slc2Name As String
Dim slc1Item As String
Dim foundSlicer1 As Boolean
On Error Resume Next
Set ws = ThisWorkbook.Sheets(“Query1”)
slc1Name = “sumarised_name”
slc2Name = “sumarised_name 1”
Debug.Print “Sheet name: ” & ws.Name
For Each pt In ws.PivotTables
foundSlicer1 = False
For Each slc1 In pt.Slicers
If slc1.Name = slc1Name Then
Debug.Print “First slicer found: ” & slc1.Name
foundSlicer1 = True
slc1.ClearAllFilters
If slc1.HasSelectedItems Then
slc1Item = slc1.slicerCache.VisibleSlicerItemsList(1)
Debug.Print “Selected item from first slicer: ” & slc1Item
For Each slc2 In pt.Slicers
If slc2.Name = slc2Name Then
Debug.Print “Second slicer found: ” & slc2.Name
slc2.ClearAllFilters
slc2.SlicerItems(slc1Item).Selected = True
Debug.Print “Corresponding item in second slicer selected: ” & slc1Item
Exit For
End If
Next slc2
Else
Debug.Print “No items selected in first slicer.”
End If
Exit For
End If
Next slc1
If foundSlicer1 Then Exit For
Next pt
On Error GoTo 0
End Sub
Can anyone shed any light on why this isn’t working, or any other suggestions?
Hi. I have 2 Pivot tables in a worksheet, both connected to their own query from an SQL database. What i am looking to do is filter both pivots using 1 slicer. After extensive research, i discovered this couldn’t be done (even by amending the report connections). So my plan now is to add a slicer to each pivot and link the 2 using VBA, however my code isn’t working: Private Sub Worksheet_PivotTableUpdate(ByVal Target As PivotTable)Dim ws As WorksheetDim pt As PivotTableDim slc1 As slicerDim slc2 As slicerDim slc1Name As StringDim slc2Name As StringDim slc1Item As StringDim foundSlicer1 As BooleanOn Error Resume NextSet ws = ThisWorkbook.Sheets(“Query1”)slc1Name = “sumarised_name”slc2Name = “sumarised_name 1″Debug.Print “Sheet name: ” & ws.NameFor Each pt In ws.PivotTablesfoundSlicer1 = FalseFor Each slc1 In pt.SlicersIf slc1.Name = slc1Name ThenDebug.Print “First slicer found: ” & slc1.NamefoundSlicer1 = Trueslc1.ClearAllFiltersIf slc1.HasSelectedItems Thenslc1Item = slc1.slicerCache.VisibleSlicerItemsList(1)Debug.Print “Selected item from first slicer: ” & slc1ItemFor Each slc2 In pt.SlicersIf slc2.Name = slc2Name ThenDebug.Print “Second slicer found: ” & slc2.Nameslc2.ClearAllFiltersslc2.SlicerItems(slc1Item).Selected = TrueDebug.Print “Corresponding item in second slicer selected: ” & slc1ItemExit ForEnd IfNext slc2ElseDebug.Print “No items selected in first slicer.”End IfExit ForEnd IfNext slc1If foundSlicer1 Then Exit ForNext ptOn Error GoTo 0End Sub Can anyone shed any light on why this isn’t working, or any other suggestions? Read More
Not able to get app roles assigned to groups
Hi everyone,
I’m trying to get the app roles assigned to a certain group but I’m only able to get the ObjectId, ResourceDisplayName and PrincipalDisplayName and not the actual role assigned. I’m using the following command ‘Get-AzureADGroupAppRoleAssignment -ObjectId’. Does anyone know how I can get the actual roles assigned?
Hi everyone, I’m trying to get the app roles assigned to a certain group but I’m only able to get the ObjectId, ResourceDisplayName and PrincipalDisplayName and not the actual role assigned. I’m using the following command ‘Get-AzureADGroupAppRoleAssignment -ObjectId’. Does anyone know how I can get the actual roles assigned? Read More
SharePoint List drop-down changing values randomly
Hey,
I have a drop-down in a list which a few options. I’ve noticed that randomly the value of this drop-down is changing in random items at random times to a number which means nothing. I have attached screenshots of the options available, and the random number being added.
Any ideas where this is coming from?
Hey, I have a drop-down in a list which a few options. I’ve noticed that randomly the value of this drop-down is changing in random items at random times to a number which means nothing. I have attached screenshots of the options available, and the random number being added. Any ideas where this is coming from? Read More
Copy-Paste of contact details in new Outlook
Hi there
Can anyone tell me why I cant copy and paste details like e-mailadress, phone numbers, names or notes with specifics, when adding a new contact to my lists? This is VERY annoying, and takes forever with clicking back and forth between a document with the information, and the Outlook-form.
Any advice would be greatly appriciated, Thank you
Sincerly
Johnny
Hi thereCan anyone tell me why I cant copy and paste details like e-mailadress, phone numbers, names or notes with specifics, when adding a new contact to my lists? This is VERY annoying, and takes forever with clicking back and forth between a document with the information, and the Outlook-form.Any advice would be greatly appriciated, Thank youSincerlyJohnny Read More
How Fix quickbooks multi user mode not working error windows 11
Encountering issues with QuickBooks multi-user mode on Windows 11—it’s not functioning correctly. How can I resolve this to ensure seamless collaboration?
Encountering issues with QuickBooks multi-user mode on Windows 11—it’s not functioning correctly. How can I resolve this to ensure seamless collaboration? Read More
MS Project Resource Graph
In MS Project Resource Graph, how can I show the Bold Horizontal line indicating the Maximum Units number?
In MS Project Resource Graph, how can I show the Bold Horizontal line indicating the Maximum Units number? Read More
How to Fix Quickbooks Error 1327 Windows 10 after update
I’m facing ‘QuickBooks Error 1327’ on my Windows 10 system. How can I resolve this issue to proceed with installing or updating QuickBooks?
I’m facing ‘QuickBooks Error 1327’ on my Windows 10 system. How can I resolve this issue to proceed with installing or updating QuickBooks? Read More
Outlook not synching with web calendar
I want to (re-)subscribe to a web calendar from icloud.com that stopped synching.
iCloud provides a URL (beginning with webcal://p101-caldav.icloud.com/published/2/…)
that I can enter on the Outlook web client on outlook.office.com (Add calendar > Subscribe from internet > enter URL).
Unfortunately Outlook is not fully synching the calendar any more.
To identify the culprit I used the same link on Google calendar and it could sync without a problem.
So the problem seems to be on the O365 side.
Are there any solutions to this problem?
I want to (re-)subscribe to a web calendar from icloud.com that stopped synching.iCloud provides a URL (beginning with webcal://p101-caldav.icloud.com/published/2/…)that I can enter on the Outlook web client on outlook.office.com (Add calendar > Subscribe from internet > enter URL).Unfortunately Outlook is not fully synching the calendar any more.To identify the culprit I used the same link on Google calendar and it could sync without a problem.So the problem seems to be on the O365 side.Are there any solutions to this problem? Read More
Spam “tips” banners inside Outlook
Hi, please can you let me know how to turn off these spam “tips” banners every time I start Outlook. I can’t find a way to do it and it’s worse than the days of the Office assistant. I have no interest at all in replying with emojis at work – if I did I may get in trouble for doing so – and these spam messages are getting very frustrating. Many thanks.
Hi, please can you let me know how to turn off these spam “tips” banners every time I start Outlook. I can’t find a way to do it and it’s worse than the days of the Office assistant. I have no interest at all in replying with emojis at work – if I did I may get in trouble for doing so – and these spam messages are getting very frustrating. Many thanks. Read More
Copilot meeting recap/summary not working with channel meeting
The meeting recap function from copilot seems not to work with channel meetings.
We arrange meetings through teams channels, but meetings from channels to not have the meeting recap function as in regular meetings. After the meeting is over, we are not able to use the copilot for these transkripts and meetings.
How can we solve this issue? Is this on purpose from MS?
The meeting recap function from copilot seems not to work with channel meetings.We arrange meetings through teams channels, but meetings from channels to not have the meeting recap function as in regular meetings. After the meeting is over, we are not able to use the copilot for these transkripts and meetings.How can we solve this issue? Is this on purpose from MS? Read More
Excel
I would like to delete the numbers in column C and move them row by row to column D, in a number of different sheets and files. What would be the best way to do it? Can anyone help please. Thank you
I would like to delete the numbers in column C and move them row by row to column D, in a number of different sheets and files. What would be the best way to do it? Can anyone help please. Thank you Read More
2 way sync with Samsung Tasks
Hi,
I’ve got To Do synced with Samsung Tasks.
To Do shows up in Samsung Tasks but Samsung Tasks don’t show up in To Do. These are Tasks I created through Bixby Voice.
Is there a way to sync both ways?
Thanks!
Hi,I’ve got To Do synced with Samsung Tasks. To Do shows up in Samsung Tasks but Samsung Tasks don’t show up in To Do. These are Tasks I created through Bixby Voice. Is there a way to sync both ways? Thanks! Read More
AVD Outlook error
Hi,
I am getting a major issue on AVD with Outlook for multiple users at different times intermittently where outlook is just stuck “connecting”
There is an authentication error visible not specific to any AVD host
Setup is as follows
host pool with 3 avd hosts (that have already been rebuilt)
FSlogix(not using ODFC or cloud cache) – Premium SSD storage
Antivirus is disabled
conditional access/MFA is disabled
windows firewall is disabled
Traffic routes through a fortigate NVA – but Any outbound in place with nothing being applied so thats ruled out.
Any help would be appreciated.
Thanks
Hi,I am getting a major issue on AVD with Outlook for multiple users at different times intermittently where outlook is just stuck “connecting”There is an authentication error visible not specific to any AVD host Setup is as followshost pool with 3 avd hosts (that have already been rebuilt)FSlogix(not using ODFC or cloud cache) – Premium SSD storageAntivirus is disabledconditional access/MFA is disabledwindows firewall is disabledTraffic routes through a fortigate NVA – but Any outbound in place with nothing being applied so thats ruled out.Any help would be appreciated.Thanks Read More
OneDrive android stopped uploading photos, gives no indication that anything is wrong
After working more or less okay for a coupe of years, the onedrive app stopped uploading photos from my phone. It doesn’t report any errors or anything, in fact it tells you everything got synced, but photos do not get uploaded.
I have also checked traffic on my router to make sure it really isn’t uploading (to rule out the case where it’s uploading the files to somewhere I don’t expect).
I have tried all the troubleshooting guides I could find from MS (and other online places) but nothing seem to work.
Stuff i’ve tries-
Stopping app
clearing cache
deleting data
uninstalling the app
reinstalling the app
renaming the onedrive camera folder
unlinking and relinking the account.
And looking online, I do not seem to be the only person who got hit with types of issues.
After working more or less okay for a coupe of years, the onedrive app stopped uploading photos from my phone. It doesn’t report any errors or anything, in fact it tells you everything got synced, but photos do not get uploaded.I have also checked traffic on my router to make sure it really isn’t uploading (to rule out the case where it’s uploading the files to somewhere I don’t expect).I have tried all the troubleshooting guides I could find from MS (and other online places) but nothing seem to work.Stuff i’ve tries-Stopping appclearing cachedeleting datauninstalling the appreinstalling the apprenaming the onedrive camera folderunlinking and relinking the account. And looking online, I do not seem to be the only person who got hit with types of issues. Read More
Measuring the progress of KRs as a percentage.
I’m creating a sales objective with 4 KRs. I choose “number” as the metric because the currency I need (SAR) isn’t available (thank you very much, Microsoft!). Anyway, the mode of update is automatic through Excel Online. The problem is, the progress of each KR is calculated as an achievement out of a total number without specifying the percentage of that achievement!
How can I get it to also display the percentage?
I’m creating a sales objective with 4 KRs. I choose “number” as the metric because the currency I need (SAR) isn’t available (thank you very much, Microsoft!). Anyway, the mode of update is automatic through Excel Online. The problem is, the progress of each KR is calculated as an achievement out of a total number without specifying the percentage of that achievement! How can I get it to also display the percentage? Read More
A Border Shown when Opened/Closed a Tab
when i close a tab, a border shown in middle of a tab, and when i open a tab a shape shown in last tab.
when i close a tab, a border shown in middle of a tab, and when i open a tab a shape shown in last tab. Read More
How to Fix Quickbooks Error 1327 Windows 11 after update
I’m encountering ‘QuickBooks Error 1327’ specifically on Windows 11. How can I address this issue to successfully install or update QuickBooks?
I’m encountering ‘QuickBooks Error 1327’ specifically on Windows 11. How can I address this issue to successfully install or update QuickBooks? Read More