Tag Archives: microsoft
Unable to digital sign the pdf downloaded from sharepoint
Hello All ,
I have an pdf in my local machine, Normally I am able to digital sign that pdf using Adobe Acrobat reader as shown in below picture
When I upload the same pdf to Sharepoint and edit that pdf in sharepoint ad add some text on it like shown in in below image, and download the pdf to local machine and then the digital sign is not working
Digital signature is not being added after adding text into pdf using sharepoint
Here is some more info on error that i got from adobe
Hello All , I have an pdf in my local machine, Normally I am able to digital sign that pdf using Adobe Acrobat reader as shown in below picture When I upload the same pdf to Sharepoint and edit that pdf in sharepoint ad add some text on it like shown in in below image, and download the pdf to local machine and then the digital sign is not working Digital signature is not being added after adding text into pdf using sharepointHere is some more info on error that i got from adobe Read More
Sign In button stopped being shown within the Sign In prompt
Good afternoon,
Today we encountered the issue: the Sign In button stopped being shown within the Sign In prompt of OAuthPrompt class:
We use this class for SSO in MS Teams in our solution for several years without any issues and changes. The implementation is done exactly as suggested in samples and according to documentation from the links below:
Here is our code:
// Prompt for OAUTH
this.addDialog(
new OAuthPrompt(ComponentDialogConstants.OAUTH_PROMPT, {
connectionName: process.env.MS_CONNECTION_NAME,
title: ‘Sign In’,
timeout: 300000
}));
The productive usage of our clients’ integrated bots is affected. The issue is reproduced in all the environments for old, new version of MS Teams and in Web, so there is no workaround. Therefore please consider this issue with the priority very high.
Thank you,
Best regards,
Darya
Good afternoon, Today we encountered the issue: the Sign In button stopped being shown within the Sign In prompt of OAuthPrompt class:We use this class for SSO in MS Teams in our solution for several years without any issues and changes. The implementation is done exactly as suggested in samples and according to documentation from the links below: https://learn.microsoft.com/en-us/javascript/api/botbuilder-dialogs/oauthprompt?view=botbuilder-ts-latest https://github.com/microsoft/BotBuilder-Samples/blob/main/samples/javascript_nodejs/18.bot-authentication/dialogs/mainDialog.js Here is our code: // Prompt for OAUTH
this.addDialog(
new OAuthPrompt(ComponentDialogConstants.OAUTH_PROMPT, {
connectionName: process.env.MS_CONNECTION_NAME,
title: ‘Sign In’,
timeout: 300000
}));
The productive usage of our clients’ integrated bots is affected. The issue is reproduced in all the environments for old, new version of MS Teams and in Web, so there is no workaround. Therefore please consider this issue with the priority very high. Thank you,Best regards,Darya Read More
macro to insert lines when comparing 2 lists or form to update 2 lists
Hello,
i’ve currently got 2 lists :
list 1 is a catalog of toolslist 2 is a the tracking of orders from the catalog
my aim is to declare that there has been an order in the the catalog (list 1) by putting a “Y” in a column and then running a macro that will add the new lines into the list 2 without deleting the old ones and the sorting by “internal ref”
both lists are in the same work book just different pages
My main question is how can i update list 2 with out deleting the lines currently present, nor creating duplicates ?
i was thinking about going ahead this way :
1 – fetch last line of list 2
2 – copy/paste or advanced filter to fetch all the orders
3 – sort by internal ref
but that doesn’t solve the duplicate error … maybe it could be done with an “if” or ticking “unique records only” in the advanced filter?
if this option was to complicated i was thinking of a “place order” form that would update list 1 and then add the affected lines to list 2 … the form would need to be able to place multiple orders at once
list 1 looks like this :
Tool nametool versionInternal refTool priceOdered by XOrdered by YZTool 1ATool 1_ind A99 Tool 1BTool 1_ind B56 YTool 1CTool 1_ind C7Y Tool 2ATool 2_ind A456YYtool 3Atool 3_ind A456YYTool 4ATool 4_ind A46Y
List 2 looks like (once filtered by internal ref):
Internal refTool nametool versionClientinternal priceinternal order dateinternal delivery datecommentsclient ship dateTool 1_ind BTool 1BY Tool 1_ind CTool 1CX Tool 2_ind ATool 2AX Tool 2_ind ATool 2AY tool 3_ind Atool 3AX tool 3_ind Atool 3AY Tool 4_ind ATool 4AX
Hello, i’ve currently got 2 lists : list 1 is a catalog of toolslist 2 is a the tracking of orders from the catalogmy aim is to declare that there has been an order in the the catalog (list 1) by putting a “Y” in a column and then running a macro that will add the new lines into the list 2 without deleting the old ones and the sorting by “internal ref” both lists are in the same work book just different pages My main question is how can i update list 2 with out deleting the lines currently present, nor creating duplicates ? i was thinking about going ahead this way :1 – fetch last line of list 22 – copy/paste or advanced filter to fetch all the orders3 – sort by internal refbut that doesn’t solve the duplicate error … maybe it could be done with an “if” or ticking “unique records only” in the advanced filter? if this option was to complicated i was thinking of a “place order” form that would update list 1 and then add the affected lines to list 2 … the form would need to be able to place multiple orders at once list 1 looks like this :Tool nametool versionInternal refTool priceOdered by XOrdered by YZTool 1ATool 1_ind A99 Tool 1BTool 1_ind B56 YTool 1CTool 1_ind C7Y Tool 2ATool 2_ind A456YYtool 3Atool 3_ind A456YYTool 4ATool 4_ind A46Y List 2 looks like (once filtered by internal ref):Internal refTool nametool versionClientinternal priceinternal order dateinternal delivery datecommentsclient ship dateTool 1_ind BTool 1BY Tool 1_ind CTool 1CX Tool 2_ind ATool 2AX Tool 2_ind ATool 2AY tool 3_ind Atool 3AX tool 3_ind Atool 3AY Tool 4_ind ATool 4AX Read More
Addition & Multiplication in one cell?
Hi,
I’m building a formula that tracks revenue as per piece counts. The table shown would need to calculate column B, while :heavy_multiplication_x: column C10
Is there a way to do this apart from a static SUM B4:B9*C10? As some routes will not use all service fields as shown in the attached photo.
Thank you.
Hi,I’m building a formula that tracks revenue as per piece counts. The table shown would need to calculate column B, while :heavy_multiplication_x: column C10 Is there a way to do this apart from a static SUM B4:B9*C10? As some routes will not use all service fields as shown in the attached photo. Thank you. Read More
The HoloLens2 continuously plays the startup sound while charging and is unable to boot up properly
Hi everyone,
Recently, during the development process with the HoloLens 2, I encountered an issue where the device failed to boot properly. I attempted to restart the device several times, but the problem persisted.
While charging, One light fading in and out as mentioning in(https://learn.microsoft.com/en-us/hololens/hololens2-setup#lights-that-indicate-the-battery-level), followed by the startup sound playing repeatedly, and the device not functioning normally.
According to the documents, light to indicate problem, I judge the device battery might be very low, but after trying to plug in, and to charge the device, it seems not working.
Is there anything else I could try to get it working again?
Thank you kindly in advance for any suggestions.
Hi everyone,Recently, during the development process with the HoloLens 2, I encountered an issue where the device failed to boot properly. I attempted to restart the device several times, but the problem persisted.While charging, One light fading in and out as mentioning in(https://learn.microsoft.com/en-us/hololens/hololens2-setup#lights-that-indicate-the-battery-level), followed by the startup sound playing repeatedly, and the device not functioning normally.According to the documents, light to indicate problem, I judge the device battery might be very low, but after trying to plug in, and to charge the device, it seems not working.Is there anything else I could try to get it working again?Thank you kindly in advance for any suggestions. Read More
extracting a single worksheet from a file
I have been asked to consolidate information from a lot of files. I have a folder with excel files, I need to extract one single tab (or worksheet) from all of them. can this be done?
my preference would be to automatically merge these tabs(or worksheets) into one; however, I am still fine to have them as separate files, then I can merge them.
What would I need to do during set up? do all the tabs need to be named the same?
example, I have 50 budget files, each budget has a tab that summarizes the data from other tabs. do the tabs all need to be named “summary?”
I have been asked to consolidate information from a lot of files. I have a folder with excel files, I need to extract one single tab (or worksheet) from all of them. can this be done?my preference would be to automatically merge these tabs(or worksheets) into one; however, I am still fine to have them as separate files, then I can merge them.What would I need to do during set up? do all the tabs need to be named the same?example, I have 50 budget files, each budget has a tab that summarizes the data from other tabs. do the tabs all need to be named “summary?” Read More
Entra ID federation with Google Workspace
Entra ID federation with Google Workspace
Google Workspace federation allows you to manage user identities in your Entra ID tenants while authenticating these users through Google. This can be beneficial if your company wants to use a single source of identities across different cloud platforms.
This article covers the scenario where your domain is already added and verified in Entra ID.
Requirements
To use Google Workspace federation, you need to ensure that your federated users are created in the Entra ID directory. This can be done through various methods such as auto-provisioning or using the Graph API.
Keep in mind, that the out-of-the box federation for Google only works for gmail.com personal accounts. In order to federate with work accounts managed in Google Workspace, you have to configure SAML IDP federation.
Configuring SAML Federation on Google Workspace side
To configure SAML federation in Google Workspace, follow these steps:
1. Create a Web Application in Google Admin Panel:
Navigate to https://admin.google.com/
Go to Apps -> Web and mobile apps
Click Add app -> Search for apps
Search for “Microsoft Office 365” and install it.
2. Download Metadata:
After installing the app, go to the app details and download the metadata.
Save the IdP metadata file (GoogleIDPMetadata.xml) as it will be used to set up Microsoft Entra ID later.
3. Enable Auto-Provisioning:
Enable auto-provisioning inside the “Microsoft Office 365” app.
4. Configure Service Provider Details:
On the Service Provider details page:
Select the option Signed response.
Verify that the Name ID format is set to PERSISTENT.
Under SAML attribute mapping, select Basic Information and map Primary email to IDPEmail.
5. Enable the App for Users in Google Workspace:
Go to Apps -> Web and mobile apps -> Microsoft Office 365 -> User access.
Select ON for everyone and save the changes.
Adding Federation for SAML Provider in Entra ID
Using the IdP metadata XML file downloaded from Google Workspace, modify the $DomainName variable in the following script to match your environment, and then run it in a PowerShell session:
Set-ExecutionPolicy -ExecutionPolicy RemoteSigned -Scope CurrentUser -Force
Install-Module Microsoft.Graph -Scope CurrentUser
Import-Module Microsoft.Graph
$domainId = “<your domain name>”
$xml = [Xml](Get-Content GoogleIDPMetadata.xml)
$cert = -join $xml.EntityDescriptor.IDPSSODescriptor.KeyDescriptor.KeyInfo.X509Data.X509Certificate.Split()
$issuerUri = $xml.EntityDescriptor.entityID
$signinUri = $xml.EntityDescriptor.IDPSSODescriptor.SingleSignOnService | ? { $_.Binding.Contains(‘Redirect’) } | % { $_.Location }
$signoutUri = “https://accounts.google.com/logout”
$displayName = “Google Workspace Identity”
Connect-MGGraph -Scopes “Domain.ReadWrite.All”, “Directory.AccessAsUser.All”
$domainAuthParams = @{
DomainId = $domainId
IssuerUri = $issuerUri
DisplayName = $displayName
ActiveSignInUri = $signinUri
PassiveSignInUri = $signinUri
SignOutUri = $signoutUri
SigningCertificate = $cert
PreferredAuthenticationProtocol = “saml”
federatedIdpMfaBehavior = “acceptIfMfaDoneByFederatedIdp”
}
New-MgDomainFederationConfiguration @domainAuthParams
To verify that the configuration is correct, you can use the following PowerShell command:
Get-MgDomainFederationConfiguration -DomainId $domainId |fl
Test the federation
To test the federation, navigate to https://portal.azure.com and sign in with a Google Workspace account:
As username, use the email as defined in Google Workspace. The user is redirected to Google Workspace to sign in.
After Google Workspace authentication, the user is redirected back to Microsoft Entra ID and signed in.
Troubleshooting
If you configured federation after users were created in Entra ID, it is possible that users will get an error AADSTS51004
AADSTS51004: The user account XXX does not exist in the YYY directory. To sign into this application, the account must be added to the directory.
This error is most likely caused by property ImmutableId being incorrect.
For Google Workspace federation ImmutableId has to be set as a primary email adress of the user.
Follow these steps to update the ImmutableID:
Convert the federated user to a cloud-only user (update the UPN to a non-federated domain)
Update the ImmutableId
Convert the user back to a federated user
Here’s a PowerShell example to update the ImmutableId for a federated user:
Set-ExecutionPolicy -ExecutionPolicy RemoteSigned -Scope CurrentUser -Force
Install-Module Microsoft.Graph -Scope CurrentUser
Import-Module Microsoft.Graph
Connect-MgGraph -Scopes ‘User.Read.All’, ‘User.ReadWrite.All’
#1. Convert the user from federated to cloud-only
Update-MgUser -UserId test@example.com -UserPrincipalName test@example.onmicrosoft.com
#2. Convert the user back to federated, while setting the immutableId
Update-MgUser -UserId test@example.onmicrosoft.com -UserPrincipalName test@example.com -OnPremisesImmutableId ‘test@example.com’
Conclusion
In summary, Entra ID federation with Google Workspace allows seamless user identity management and authentication across different cloud platforms.
Hit me up in comments if this worked for you!
Microsoft Tech Community – Latest Blogs –Read More
EFI – Full repair needed?
I’ve already found a few posts here that explain how to repair the EFI partition. How to do that is not my question. Q1: Is this just windows being stupid? (if yes skip Q2)Q2: Should I even bother fixing this? The PC is working as fine as Windows can. I would never have known about this had I not decided to create a VHD. Read More
WAC : Installation fails with Unhandled Exception
Hi
Server: 2022 Std, 21H2 20348.2700
Clean build and activated
WAC MSI version 2311
When I try to install WAC I get a message : Unhandled Exception – System.Security.Cryptography.CrypographicException – Access is denied (see screen shot)
I am logged on as a user who is a member of the local administrator group and also Domain Admins.
The installation fails and roles back, any ideas as to what I can do?
Thanks
Ian
HiServer: 2022 Std, 21H2 20348.2700Clean build and activatedWAC MSI version 2311 When I try to install WAC I get a message : Unhandled Exception – System.Security.Cryptography.CrypographicException – Access is denied (see screen shot) I am logged on as a user who is a member of the local administrator group and also Domain Admins. The installation fails and roles back, any ideas as to what I can do?ThanksIan Read More
Exchange license removed but mailbox still active
Hi,
I`m tidying up old users from our tenant and have noticed lots of old users without exchange licenses still have mailboxes active. I thought these were soft deleted after 30 days.
We want to keep the user in our domain without a mailbox so that the user in Atlassian doesn`t become an unknown users. The user is blocked from sign in and doesn`t have any licenses attached.
Any ideas on why the mailbox is still there?
Thanks
James
Hi, I`m tidying up old users from our tenant and have noticed lots of old users without exchange licenses still have mailboxes active. I thought these were soft deleted after 30 days. We want to keep the user in our domain without a mailbox so that the user in Atlassian doesn`t become an unknown users. The user is blocked from sign in and doesn`t have any licenses attached. Any ideas on why the mailbox is still there? ThanksJames Read More
SharePoint Modern Page – Notifications when submitting Comments
On a modern page when someone post a comment, notification is sent to person who created the page. I’m looking for an option to change this so notifications are sent to another person, tried changing ‘Author’ to the desired user but notifications are still sent to ‘Created By’ user. Is this by design or is there a workaround?
On a modern page when someone post a comment, notification is sent to person who created the page. I’m looking for an option to change this so notifications are sent to another person, tried changing ‘Author’ to the desired user but notifications are still sent to ‘Created By’ user. Is this by design or is there a workaround? Read More
How can I create Windows 11 installation media for new PC?
Hi community experts,
My 10-year old MacBook Pro will be retired soon as it becomes laggy and many apps are not supported. Recently, I heard a lot of good reviews about Windows 11 and now I have the new built PC at my hand. The specs are:
CPU: Intel i5 12400FRAM: Kingston 16GBSSD: SANDISK 500GBMotherboard: Asus A520MGraphics card: 4070Ti
My question is how to create Windows 11 installation media so I can install Windows 11 on my new PC. I am not a tech savvy and don’t know how to do this. It could be great if some one point our the right direction.
Thank you
Hi community experts, My 10-year old MacBook Pro will be retired soon as it becomes laggy and many apps are not supported. Recently, I heard a lot of good reviews about Windows 11 and now I have the new built PC at my hand. The specs are: CPU: Intel i5 12400FRAM: Kingston 16GBSSD: SANDISK 500GBMotherboard: Asus A520MGraphics card: 4070TiMy question is how to create Windows 11 installation media so I can install Windows 11 on my new PC. I am not a tech savvy and don’t know how to do this. It could be great if some one point our the right direction. Thank you Read More
I have 3 computers, 1 with PIN and enter, 1 with PIN and straight in, and 1 with no PIN and straight
I’d like to know how I’ve done it. The first is with PIN and enter, probably using Microsoft, but others have OEM info. All have Windows 23H2 up to date.
I’m not bothered but I would like to know what I’ve done.
I’d like to know how I’ve done it. The first is with PIN and enter, probably using Microsoft, but others have OEM info. All have Windows 23H2 up to date.I’m not bothered but I would like to know what I’ve done. Read More
File Explorer has gone back to automatically expanding drive folders in the navigation pane . . .
Hi All –
When I got my new computer a bit over a year ago, I ordered it with Windows 11 Pro. It worked pretty well, but I had one complaint: No matter what I did in folder options, every time I opened a folder in the main pane of File Explorer, the navigation pane on the left would automatically expand the drive folders to show the same thing that was going on in the right main pane.
Then, to my amazement, I eventually got a Windows Update, and then it did not automatically expand. Now, in the last few days, it has gone back to automatically expanding again, and it is interrupting my workflow. Is there some way to keep the auto expansion from happening? I have the box checked in folder options to not automatically expand. I can, of course, click the arrow to go back to unexpanded, but it is a pain as I work in file explorer a lot.
Thanks.
Hi All -When I got my new computer a bit over a year ago, I ordered it with Windows 11 Pro. It worked pretty well, but I had one complaint: No matter what I did in folder options, every time I opened a folder in the main pane of File Explorer, the navigation pane on the left would automatically expand the drive folders to show the same thing that was going on in the right main pane. Then, to my amazement, I eventually got a Windows Update, and then it did not automatically expand. Now, in the last few days, it has gone back to automatically expanding again, and it is interrupting my workflow. Is there some way to keep the auto expansion from happening? I have the box checked in folder options to not automatically expand. I can, of course, click the arrow to go back to unexpanded, but it is a pain as I work in file explorer a lot.Thanks. Read More
AVD Hybrid joined M365 FSlogix login not saved
Hi all,
I have a Pooled hybrid joined W11 multi-session machine with office installed and configured with FSlogix. Everytime i login to the virtual machine, i have to fill in my credentials again. this counts for every office application , word, excel, one-drive etc. For a pooled . see screenshot
What do i have to configure to solve this issue ?
Hi all,I have a Pooled hybrid joined W11 multi-session machine with office installed and configured with FSlogix. Everytime i login to the virtual machine, i have to fill in my credentials again. this counts for every office application , word, excel, one-drive etc. For a pooled . see screenshot What do i have to configure to solve this issue ? Read More
Edit fillable PDF in Microsoft 365 (iOS) stopped working
For the past few days, we have been unable to edit PDF files in the MS365 iOS app. We work with a SharePoint list that contains thousands of PDF files, which were previously opened and edited directly within the MS365 app without any issues.
Since the update we are only able to anotate on the PDF files but we cannot select the fillable fields en signature fields anymore.
This feature is crucial to our workflow, and the inability to edit PDFs in the app has caused significant disruptions
For the past few days, we have been unable to edit PDF files in the MS365 iOS app. We work with a SharePoint list that contains thousands of PDF files, which were previously opened and edited directly within the MS365 app without any issues. Since the update we are only able to anotate on the PDF files but we cannot select the fillable fields en signature fields anymore. This feature is crucial to our workflow, and the inability to edit PDFs in the app has caused significant disruptions Read More