9,055 questions
0
votes
2
answers
65
views
Incorrect currency being displayed using Stock Data Type
The inbuilt stock data type in Excel is not correctly displaying the price of the stock. The issue is with stocks on the LSE as they are reported in pence and not dollars, Excel is reporting it as ...
2
votes
1
answer
65
views
How can I reliably detect when a message is moved between folders in a shared mailbox using Microsoft Graph?
I’m building a workflow on top of a shared mailbox where each email acts as a ticket, and its folder represents its current state (New, In Progress, Waiting, Closed, etc.). To make this work, I need a ...
0
votes
0
answers
65
views
Outlook Office addin onMessageSendHandler on Mac and Web
I'm currently struggeling to get my onMessageSendHandler to work on Outlook Web and Mac. When the user sends a message, I want the user to have the option to open taskpane instead of sending the mail. ...
-1
votes
1
answer
65
views
Call SharePoint Api using Power Automate "Http" by passing App registration clientID/Secret
I have created an Azure App registration, and granted it permissions to manage SharePoint sites. then i want to query the SharePoint sites' users, using SharePoint API, here the first request to get ...
0
votes
0
answers
67
views
Using Sharepoint Rest API _api/web/GetFolderByServerRelativeUrl('Shared Documents/test test/test#') ..Error Bad Request
I have this REST API call to SharePoint online, to check if a folder already exists in a document library :
GET _api/web/GetFolderByServerRelativeUrl('Shared Documents/test test/test#')
I am getting ...
0
votes
1
answer
113
views
Microsoft 365 Access VBA DoCmd.TransferText Error
I am running Office 365 on a Windows 11 machine.
I created an Access database that loads tables from csv files, runs two queries and creates a CSV formatted report file through the use of modules, ...
0
votes
0
answers
55
views
Unable to get webLink for Microsoft 365 Group messages using Microsoft Graph
If a user is added to a Microsoft 365 group, they receive new mails in their inbox,
but previous mails remain inside the group mailbox (visible in Outlook under Groups).
I want to search a work order ...
0
votes
0
answers
49
views
Sharepoint look up column returning blank
So I have three lists in a Sharepoint. User list, Customer tracker and Engagement list. I have made a look up column in engagements that looks up to or from customer tracker list, name column to be ...
0
votes
0
answers
72
views
How to get text from all selected cells in a table?
I'm working on a Word add-in using the Office JS API and am building a converter that changes the selected text into a different format.
I’m not encountering any issues when the selection is a ...
1
vote
1
answer
57
views
Office 365 PowerPoint add-in not showing up online, but works on desktop [closed]
We built Office Add-Ins for Outlook, Word and PowerPoint. They mostly look and work OK on the desktop and online. We load them via Admin Portal => "Integrated apps". This works for ...
1
vote
1
answer
161
views
"Insert Python" in Excel's Formula section, to read another Excel file
In Excel's Formula section, when using "Insert Python", I want to read another Excel file as data frame.
However as screenshot below, it seems wrong with the file path. I've try double ...
0
votes
0
answers
32
views
Service Worker is terminated immediately after event.completed, so final network call never runs (Classic Outlook Win32 & New Outlook for Mac)
Summary
I have an Outlook on-send add-in that modifies the current message and then calls event.completed({ allowEvent: true }). Right before completing, I post a final message to a Service Worker so ...
2
votes
1
answer
164
views
Download ICS from outlook.com using HttpClient
Does anyone see what I'm doing wrong? Why can't I download a calendar file from outlook.com using HttpClient?
Whatever I try, Outlook will throw a http 302 error and redirect to an OWA error page ...
-3
votes
1
answer
97
views
Totally close an Excel file [duplicate]
I am running Office 365 on both Windows 11. I am trying to totally close an Excel program from VBA. I tried Workbooks.Close and also ActiveWindow.Close in both instances I still have an Excel ...
0
votes
0
answers
153
views
Outlook Add-in Sideloading fails with AADSTS500200 on Personal Account & NoMailboxAndNoLicenseAssignedError on Org Account
Hello Stack Overflow Community,
I am developing an Outlook Add-in using the official Yeoman generator (yo office) with React and TypeScript. I am currently blocked during the development and testing ...
-1
votes
4
answers
177
views
Excel - Sorting textual versions using dynamic arrays
I need to sort versions of software, and like you can see in this picture, the source is in 6 colomns (it can change), stored in a dynamic array.
I need only one colomn with the higher versions in ...
1
vote
1
answer
120
views
Filter a table with a list of value with dynamic array formula
I tried to filter a table using a list. Using Office 365 dynamics array like A1#.
Like a picture sometime is more simple than a long explanation, here my problem :
It look simple, but, i'm stuck.
I ...
0
votes
1
answer
126
views
Excel VBA code "Application.OnTime" skips seconds
I have a timer within Excel VBA code which did run smooth untill 6 weeks ago. Please see the code below. I use this timer in a workbook. I use 2 identical copies of this workbook (with different names)...
2
votes
0
answers
143
views
Uploading a file to SharePoint using the Office365-REST-Python-Client library
I want to upload a file to my SharePoint site using Python. And the Office365-REST-Python-Client module is apparently the way to go. The code I am using is as follows:
def ...
1
vote
1
answer
150
views
Unable to Export Power Automate Flow as Zip File
I have created a Power Automate Flow to send an Email when an item has been created in the SharePoint list. The flow is working as expected.
Now, I need to implement the same flow to another tenant. ...
0
votes
0
answers
48
views
Mailkit for SMTP office365 results in 535: 5.7.139 "SmtpClientAuthentication is disabled for the Tenant"
As our software has to support office365 I'm trying the mailkit example to connect to our office365 mailboxes.
However, by using OAuth2, it still keeps ending up in a "SmtpClientAuthentication is ...
1
vote
1
answer
108
views
Using Python / MSGraph to list a Office365 Email Conversation
We have a shared Office365 mailbox and I’m trying to write some Python code using MSGraph to identify emails which have been responded to.
In Outlook, if you attempt to reply to a message that has ...
0
votes
0
answers
35
views
bookingBusiness endpoint in Microsoft Graph giving "Bad Gateway"
I'm trying to create a Booking Business (Conference Room) in Microsoft Booking using the Graph REST API endpoint. I receive a "Bad Gateway" when I send the below. If I send a GET request, ...
1
vote
0
answers
110
views
Office365 SMTP with OAuth2, error "STARTTLS required but not supported"
We are trying to make SMTP work with oauth2 for office365 mailboxes on our java client. TLS version is 1.2.
We are able to get a token using the following parameters:
URL url = new URL("https://...
0
votes
1
answer
72
views
How can I test if a Powerpoint 2003 file is password-protected?
I'm trying to create a Powershell script to iterate over files on a NAS to create custom properties on files fulfilling certain criteria. The bulk of the script is fine and working as expected. I came ...
0
votes
1
answer
161
views
Actionable Messages not working on mobile
I am trying to create an informative email for users with multiple collapsible sections that would work primarily with Outlook. I figured the best way to achieve this would be to create an Actionable ...
0
votes
1
answer
242
views
Power Shell script to remove a user from all the groups the user is a member of and owner of
I want to write a power shell script to remove the user from all the groups the user is added to as a Member or as Owner , including those :-
1- Distribution list
2- Security Group
3- Mail-Enabled ...
1
vote
1
answer
53
views
Trying to unprotect a worksheet, add a row 2 rows down and then re-protect the worksheet
I am trying to unprotect a worksheet, check that the selected cell is in Column C and has one of 3 strings (People's names) and then add a row two rows down and then reprotect the worksheet. I am ...
0
votes
1
answer
105
views
Modify Mailbox Access via C#
So I've been creating an application using C# and I can make changes to my Microsoft 365 Tenant using both the Azure.Identity and Microsoft.Graph namespaces and so far it's been working great with ...
1
vote
1
answer
106
views
CUBEVALUE and CUBERANKEDMEMBER not retrieving data from model when used as part of dynamic array
I have a number of dashboard-type workbooks which contain charts and summary tables which - in theory - are supposed to update when new data is introduced to the Data Model or when a user filters the ...
0
votes
2
answers
92
views
Microsoft graph api create group for contacts
I need to create an o365 group for internal members and contacts using the graph api.
I tried and did not work:
Distribution lists and security groups allow contacts but graph api can't create DL.
...
0
votes
1
answer
394
views
Error when trying to remove members of groups:- Cannot Update a mail-enabled security groups and or distribution list
I have a list of Groups IDs, which include; Security Groups, Mail-Enabled Security group, Distribution lists, Office 365 groups.
now i have a user email and the user ID. and i want to remove the user ...
0
votes
1
answer
63
views
How to get the screen coordinates of a Microsoft.Office.Interop.Word.Range
How do I convert a given Range's coordinates to Screen coordinates for another window to show?
Microsoft.Office.Interop.Word.Range targetRange = window.Selection.Range;
timeForm.Location = new System....
0
votes
1
answer
142
views
Get Manager V2 is raising this error:- "Action 'Get_manager_ (V2)_2' failed"
I have a Get Manager V2 action inside a flow that get called from Power Apps, but it is raising this error:-
InvalidTemplate. Unable to process template language expressions in
action 'Get_manager_(V2)...
0
votes
0
answers
29
views
How can I see if Microsoft Excel 16.0 Object Library is "installed" [duplicate]
I have clicked the checkbox next to it, and then ok... but how do I know I now have this library available?
I have office 365.
i had a look at this post: How to open an Excel file in C#? but get ...
0
votes
0
answers
31
views
Manifest file to create a button on the ribbon in Outlook
I am very new to any form of coding, and I am trying to generate a manifest file so that I can deploy a button to our organization to add a button to their ribbon in Outlook.
The function is simple, I ...
0
votes
1
answer
61
views
Issues with personal Microsoft Sharepoint upload from Python
I am trying to use a Python script to upload a CSV file to a SharePoint personal directory, with a URL like:
https://{tenant}-my.sharepoint.com/personal/{user}_{tenant}_com/Documents/{path}
I have ...
0
votes
1
answer
213
views
outlook version 1.2025.328.300 causes OLE error running on code that quite happily runs against previous version
We have a powerbuilder application that runs OLE automation on outlook with
li_rc = lole_outlook.ConnectToNewObject("outlook.application")
This code works fine with previous versions of ...
-1
votes
1
answer
96
views
Outlook Automation from Access 'exhausting resources' [closed]
I have a MS Access application that sends email via outlook automation using vba code found here: Create an email with Outlook-Automation. I am using the code almost entirely unaltered under the ...
0
votes
1
answer
61
views
getting templates from Microsoft 365 admin center with ps
I'm trying to write a script that gets the predefined templates that I've created in Microsoft 365 admin center.
The problem is that I'm getting users list as templates, and not the templates.
Is ...
0
votes
1
answer
150
views
Create Appointment with Graph API without sending invitations?
Is it possible to create an event with Graph APIs without sending the calendar invitation to the attendees? I am using this create event endpoint, but I cannot prevent the invitation from being sent ...
0
votes
1
answer
90
views
Trying to fix an 3rd party application calendar access issue for an M365 user
To begin, I have limited knowledge regarding the Microsoft Graph and permissions associated with various applications. Please bear with me as I attempt to outline the situation and identify potential ...
0
votes
0
answers
58
views
How to find and highlight the exact word in Office JS word plugin
I am working on a word add-in project for Office JS. I have been trying to implement the specific word highlight using my tool. So when a user selects any word from my tool it will get selected on the ...
0
votes
1
answer
60
views
Limit/Block access to all SharePoint sites except one based on device enrollement in Entra
My company wants to roll out the Viva Connections home site to users with personal devices. We have the home site set up in Teams are able to use MAM policies on personal devices to get Teams in ...
0
votes
0
answers
90
views
Failure to authenticate a SharePoint connection with AuthenticationContext
I have the following python code in my Matillion PythonScript component:
from office365.sharepoint.client_context import ClientContext
from office365.runtime.auth.authentication_context import ...
0
votes
0
answers
47
views
Why is there a gamma symbol missing in the formula displayed when I use this latex code in word?
Why is there a gamma symbol missing in the formula displayed when I use this latex code in word? I have tried to display the gamma symbol alone, but the gamma symbol cannot be displayed in this ...
0
votes
0
answers
77
views
word 404 - File or directory not found. The resource you are looking for might have been removed, had its name changed, or is temporarily unavailable
I have a problem with Microsoft Word on the web app. I used to be able to export my files to PDF and download them. However, now I can't do it. This problem has been going on for 3 days. I can still ...
0
votes
1
answer
206
views
In Excel, how can I make a live connection to a table that is in another sheet?
Let say I have two sheets, one Database and another one NewSheet. I want to have a reference to the database so I can put some filters to the columns and be able to search for certain words or phrases ...
0
votes
0
answers
99
views
Power Automate Microsoft Forms to Google Sheets
I'm new to Power Automate and trying to transfer form responses to a Google Sheet. I've set up the workflow, but when a respondent submits a form, only the response ID appears in the sheet. How can I ...
0
votes
0
answers
26
views
Set-MgUserLicense cmdlet returns 'One or more parameters of the operation 'assignLicense' are missing from the request payload' in a script [duplicate]
I've been having real problems with Powershell's Set-MgUserLicense cmdlet running in elevated PSv7.
The intent of the script is to set M365 E3 licenses for new hires. I've been able to get the ...