Tag Archives: microsoft
How do I download Instagram video to mp4 on Windows 11?
Hi folks! I’m stuck trying to download videos from Instagram and save Instagram video to MP4s on my Windows 11 laptop. I’ve hit a few dead ends with methods I found online, and nothing seems to stick. Is there a secret sauce or a go-to tool I’m not aware of? Would really appreciate it if someone could point me in the right direction. Cheers for any help you can give!
Hi folks! I’m stuck trying to download videos from Instagram and save Instagram video to MP4s on my Windows 11 laptop. I’ve hit a few dead ends with methods I found online, and nothing seems to stick. Is there a secret sauce or a go-to tool I’m not aware of? Would really appreciate it if someone could point me in the right direction. Cheers for any help you can give! Read More
Basic understanding on Microsoft Entra custom claims provider
TOC
What is it
Architecture
How to use it
References
What is it
When a user authenticates to an app (e.g., MS Entra ID application), a custom claims provider can be used to add claims into the token. A custom claims provider is made up of a custom authentication extension that calls an external REST API (e.g., a Function App), to fetch claims from external systems (e.g., a Database). A custom claims provider can be assigned to one or many applications.
Claim: Please imagine it as features (or attributes) that belong to the end user. As it may involve sensitive information within the enterprise, the enterprise owner wishes to store this user information in the on-premises environment, while also hoping to retrieve and utilize it through the authentication process.
This service is suitable for the following scenarios:
1) It can be used as a transition for gradually migrating on-premises Active Directory to Microsoft Azure AD.
2) When user-sensitive information needs to be stored in an on-premises environment for various reasons.
Architecture
Procedure:
User login to the Application
If this AAD includes a custom claims provider, then the relevant features need to be obtained from the custom claims provider before generating the token.
The Custom claims provider asking our own system (e.g., a Function App) for the claims (e.g., criminal record) related to that user.
Our system get the related claims (e.g., by querying DB) and return it to the Custom claims provider.
The custom claims provider packages the default user information along with the additionally obtained claims, encodes them into a token, and returns it to the user.
How to use it
A-1: Create a Function App from Azure portal
Choose “.NET 6 (LTS), in-process model” as the runtime and “Windows” as the OS.
A-2: Setup a local project via VSCode
Open VSCode.
Create a new folder for your project (e.g., ccp-func)
Under the Workspace bar, select the Azure Functions icon > Create New Project.
Select C# as the language, and .NET 6.0 LTS as the .NET runtime.
Select HTTP trigger as the template.
Provide a name for the trigger (e.g., AuthEventsTrigger)
Accept Company.Function as the namespace, with AccessRights set to Function.
Open the terminal, navigate to the project folder and enter the following:
dotnet add package Microsoft.Azure.WebJobs.Extensions.AuthenticationEvents –prerelease
A-3: Add/Modify the sample code
Open the *.csproj file, change the AuthenticationEvents version to “1.0.0-beta.6”
Open the AuthEventsTrigger.cs file, copy and paste the following code to replace
using System;
using System.Threading.Tasks;
using Microsoft.AspNetCore.Mvc;
using Microsoft.Azure.WebJobs;
using Microsoft.Extensions.Logging;
using Microsoft.Azure.WebJobs.Extensions.AuthenticationEvents.TokenIssuanceStart.Actions;
using Microsoft.Azure.WebJobs.Extensions.AuthenticationEvents.TokenIssuanceStart;
using Microsoft.Azure.WebJobs.Extensions.AuthenticationEvents.Framework;
using Microsoft.Azure.WebJobs.Extensions.AuthenticationEvents;
namespace AuthEventTrigger
{
public static class Function1
{
[FunctionName(“onTokenIssuanceStart”)]
public static AuthenticationEventResponse Run(
[AuthenticationEventsTrigger(AudienceAppId = “TBA”,
AuthorityUrl = “https://login.microsoftonline.com/TBA”,
AuthorizedPartyAppId = “99045fe1-7639-4a75-9d4a-577b6ca3810f”)]TokenIssuanceStartRequest request, ILogger log)
{
try
{
if (request.RequestStatus == RequestStatusType.Successful)
{
request.Response.Actions.Add(new ProvideClaimsForToken(
new TokenClaim(“dateOfBirth”, “01/01/2000”),
new TokenClaim(“customRoles”, “Writer”, “Editor”),
new TokenClaim(“apiVersion”, “1.0.0”),
new TokenClaim(“correlationId”, request.Data.AuthenticationContext.CorrelationId.ToString())
));
}
else
{
log.LogInformation(request.StatusMessage);
}
return request.Completed();
}
catch (Exception ex)
{
return request.Failed(ex);
}
}
}
}
As you can see that there are two instances of “TBA” in the code, indicating that some of the configuration content needs to be acquired in subsequent operations. Therefore, we will maintain this status for now.
Publish the project to the Function App
On Azure Portal, go to that Function App and onTokenIssuanceStart trigger, copy the Function URL for further use.
B-1: Register a custom authentication extension
In Azure Portal, go to Microsoft Entra ID and select Enterprise applications.
Select Custom authentication extensions, and then select Create a custom extension.
In Basics, select the TokenIssuanceStart event type and select Next.
In Endpoint Configuration, fill in the following properties:
Name: (e.g., CCP Token issuance event)
Target Url: The URL you’ve get from A-3 step 5.
Select Next.
In API Authentication, select the Create new app registration option to create an app registration that represents your function app.
Give the app a name (e.g., CCP Azure Functions authentication events API)
Select Next.
In Claims, enter the attributes (Claims) that you expect your custom authentication extension to parse from your REST API and will be merged into the token. Add the following claims:
dateOfBirth
customRoles
apiVersion
correlationId
Select Next, then Create.
Note the App ID under API Authentication, which is needed for setting environment variables in your Azure Function app.
Under API Authentication, select Grant permission.
A new window opens, and once signed in, it requests permissions to receive custom authentication extension HTTP requests. This allows the custom authentication extension to authenticate to your API. Select Accept.
C-1: Configure an App to receive enriched tokens
In Azure Portal, go to Microsoft Entra ID and select App registrations.
Select New registration.
Enter a Name for the application (e.g., CCP test application)
Under Supported account types, select Accounts in this organizational directory only.
In the Select a platform dropdown in Redirect URI, select Web and then enter https://jwt.ms in the URL text box.
Select Register to complete the app registration.
Copy Application ID and Tenant ID for further use.
Back to the app in Azure portal, go to Manage, select Authentication.
Under Implicit grant and hybrid flows, select the ID tokens (used for implicit and hybrid flows) checkbox.
Select Save.
Back to the app in Azure portal, go to Manage, select Manifest.
Set the acceptMappedClaims to true.
Set the accessTokenAcceptedVersion to 2.
Select Save to save the changes.
B-2: Assign a custom claims provider to your app
In Azure Portal, go to Microsoft Entra ID and select Enterprise applications.
Under Manage, select All applications. Find and select (e.g., CCP test application) from the list.
From the Overview page, navigate to Manage, and select Single sign-on.
Under Attributes & Claims, select Edit.
Expand the Advanced settings menu.
Next to Custom claims provider, select Configure.
Expand the Custom claims provider drop-down box, and select the (e.g., CCP Token issuance event) you created earlier.
Select Save.
Next, assign the attributes from the custom claims provider, which should be issued into the token as claims:
Select Add new claim to add a new claim. Provide a name to the claim you want to be issued, for example dateOfBirth.
Under Source, select Attribute, and choose customClaimsProvider.dateOfBirth from the Source attribute drop-down box.
Repeat this process to add the customClaimsProvider.customRoles, customClaimsProvider.apiVersion and customClaimsProvider.correlationId attributes, and the corresponding name.
A-4: Protect your Azure Function
In Azure Portal, go to the Function App
Under Settings, select Authentication.
Select Add Identity provider.
Select Microsoft as the identity provider.
Select Workforce configuration (current tenant).
Under App registration select Pick an existing app registration in this directory for the App registration type, and pick the (e.g., CCP Azure Functions authentication events API).
Enter the following issuer URL, https://login.microsoftonline.com/{tenantId}/v2.0, where {tenantId} is the tenant ID you’ve get from C-1 step 4.
Under Client application requirement, select Allow requests from specific client applications, in Allowed client applications click edit button and add 2 app ids (The id you’ve get from B-1 step 8 and a fixed one 99045fe1-7639-4a75-9d4a-577b6ca3810f).
Under Identity requirement, select Allow requests from any identity.
Under Tenant requirement, select Use default restrictions based on issuer.
Under Unauthenticated requests, select HTTP 401 Unauthorized as the identity provider.
Unselect the Token store option.
Select Add to add authentication to your Azure Function.
A-5: Modify the sample code
We have noticed that there are 2 TBA in the code and already know what is the related value. So we could deploy it again to the Function App.
B-3: Test
We could have a test on the whole process, open a browser and visit the following URL
{tenantId} stands for the Tenant ID you’ve get from C-1 step 4
{App_to_enrich_ID} stands for the Application ID you’ve get from C-1 step 4
After the login we could see the result, which the returned token containing the related claims
References
Custom claims provider overview – Microsoft identity platform | Microsoft Learn
Microsoft Tech Community – Latest Blogs –Read More
Sum Help
How to sum a column if another contains a text. The issue I am running into is that the text is found in the column repeatedly. Attached is an example of the workbook I am working with.
How to sum a column if another contains a text. The issue I am running into is that the text is found in the column repeatedly. Attached is an example of the workbook I am working with. Read More
Can we use VPN to connect from Azure devops microsoft-hosted agent to VMs in Google Cloud?
Hello,
I have Azure devops with microsoft-hosted agents. The agents need to connect to VMs in Google Cloud to deploy the application. I have a VPN connection set up between Azure and GCP.
So, my question is “Can Microsoft-Hosted agents use VPN connection to connect to VMs in Google Cloud? If so, how do we set up the network design?
Thanks.
Hello,I have Azure devops with microsoft-hosted agents. The agents need to connect to VMs in Google Cloud to deploy the application. I have a VPN connection set up between Azure and GCP. So, my question is “Can Microsoft-Hosted agents use VPN connection to connect to VMs in Google Cloud? If so, how do we set up the network design? Thanks. Read More
Use Case: Complete a survey
Hi,
New to CoPilot and not there are a lot of vids where data is retrieved but wondering if a use case could be completing a survey and passing answers to Dataverse?
Thanks
Todd
Hi, New to CoPilot and not there are a lot of vids where data is retrieved but wondering if a use case could be completing a survey and passing answers to Dataverse? Thanks Todd Read More
Outlook Not Recognizing Outlook Data Fail
Hello,
I had to reinstall Office 365 on my home PC and now Outlook is not recognizing my Outlook Data File found at C:UsersDellAppDataLocalMicrosoftOutlook.
The file type is shown as Outlook Data File. Yet the file type ends in .com – (I thought it would be .ost)
I ran scanpst.exe and it repaired a few minor errors, still Outlook won’t recognize it.
The error message is “The file you chose is not an Outlook Data File. You must select a new file of this type.
What should I try next please?
Thank you.
Randy
Hello,I had to reinstall Office 365 on my home PC and now Outlook is not recognizing my Outlook Data File found at C:UsersDellAppDataLocalMicrosoftOutlook. The file type is shown as Outlook Data File. Yet the file type ends in .com – (I thought it would be .ost) I ran scanpst.exe and it repaired a few minor errors, still Outlook won’t recognize it. The error message is “The file you chose is not an Outlook Data File. You must select a new file of this type. What should I try next please? Thank you. Randy Read More
Extremely slooooooow
Extremely slow on both iPhone To Do app and desktop Outlook. These performance issues have been present for a long time. Is there a plan to address those issues?
Extremely slow on both iPhone To Do app and desktop Outlook. These performance issues have been present for a long time. Is there a plan to address those issues? Read More
SQL Server Standard Evaluation to Standard
Hi,
I would like to ask some help regarding changing the SQL Standard 2019 Evaluation to Standard only. We have followed the steps on how to change the product key via setup wizard and reboot the server couple of times but the Product ID/Code from registry and the expiration still unchanged.
Any recommendation would be truly appreciated.
Thank you,
Vsp
Hi, I would like to ask some help regarding changing the SQL Standard 2019 Evaluation to Standard only. We have followed the steps on how to change the product key via setup wizard and reboot the server couple of times but the Product ID/Code from registry and the expiration still unchanged. Any recommendation would be truly appreciated. Thank you,Vsp Read More
Black screen after login after update. Cannot rollback update.
Normally I roll back the update and everything is fine, but this time it says that it could not uninstall the update. Task manager opens from ctrl shift esc, and apps can run from win r but there is no Internet. Wusa says that the latest update is needed by windows, and dism has too many packages. Restore points also fail. I just want windows back.
Normally I roll back the update and everything is fine, but this time it says that it could not uninstall the update. Task manager opens from ctrl shift esc, and apps can run from win r but there is no Internet. Wusa says that the latest update is needed by windows, and dism has too many packages. Restore points also fail. I just want windows back. Read More
create a master template with insrtable sections with prefilled lists to select to create docs easy
I need to create a word template for a fillable document with pre-outlined sections and structure for quick document creation for each job we do.
The document is a JSA (Job Safety Analysis and set up) the outline of the document will have the following sections
Required Tools and supplies for jobsite”
then have a list of some sort of any and all tools and supplies we have and use so you can pick the items needed for this specific job and it stays structured on the document every time.. example : (5 gal drums, screw driver, shop vac, hammer, etc) so
the next section would be PPE Required
training required (list of various trainings needed for specific job site example : Confined Space entry, LOTO, Fork Lidt, Respiratory,)
engineering controls (supervisor tasks, to dos, processes et
job site hazards
clickable hazards for the following categories with all relevent info for the main hazards and then ability to add new custom hazards
-chemical hazards
(potential hazard, task/steps to do to avoid, consequences of hazard)
-safety hazards
(potential hazard, task/steps to do to avoid, consequences of hazard)
enviromental hazards
(potential hazard, task/steps to do to avoid, consequences of hazard)
Before and end of job tasks
finally it would be saved and renamed and printed for our employees to check off any sections that require checkboxes such as supplies needed then can fill in anything on document during job and be turned in to office once complete.
How can I achieve creating this template and what controls/fields/document properties / form controls etc are required and how to i do it ?
Attached is a sample JSA for reference
I need to create a word template for a fillable document with pre-outlined sections and structure for quick document creation for each job we do. The document is a JSA (Job Safety Analysis and set up) the outline of the document will have the following sections Required Tools and supplies for jobsite” then have a list of some sort of any and all tools and supplies we have and use so you can pick the items needed for this specific job and it stays structured on the document every time.. example : (5 gal drums, screw driver, shop vac, hammer, etc) so the next section would be PPE Requiredtraining required (list of various trainings needed for specific job site example : Confined Space entry, LOTO, Fork Lidt, Respiratory,) engineering controls (supervisor tasks, to dos, processes et job site hazards clickable hazards for the following categories with all relevent info for the main hazards and then ability to add new custom hazards-chemical hazards(potential hazard, task/steps to do to avoid, consequences of hazard)-safety hazards(potential hazard, task/steps to do to avoid, consequences of hazard)enviromental hazards(potential hazard, task/steps to do to avoid, consequences of hazard) Before and end of job tasks finally it would be saved and renamed and printed for our employees to check off any sections that require checkboxes such as supplies needed then can fill in anything on document during job and be turned in to office once complete. How can I achieve creating this template and what controls/fields/document properties / form controls etc are required and how to i do it ? Attached is a sample JSA for reference Read More
Traditional Sockets communication in Azure
I have an in-Store server that is using traditional socket communications to an on-prem IBM IIB MQ service to request data from an Azure hosted eComm backend. IIB receives the request made through sockets, transforms the data and makes a RESTful call to our Azure backend.
I am looking to migrate the IIB actions to Azure in favour of an Azure service, something like Azure Web PubSub.
Any suggestions?
Not sure if this drawn quite correctly, but hopefully you get the idea.
I have an in-Store server that is using traditional socket communications to an on-prem IBM IIB MQ service to request data from an Azure hosted eComm backend. IIB receives the request made through sockets, transforms the data and makes a RESTful call to our Azure backend. I am looking to migrate the IIB actions to Azure in favour of an Azure service, something like Azure Web PubSub. Any suggestions?Not sure if this drawn quite correctly, but hopefully you get the idea. Read More
Teams call queue serial routing
if i have a call queue
where there is an agent in the list, and below that a group of users, set as serial routing
will the call hit the first person and when not answered ring dist group members simutatenously
so, we want the receptionist to the be the first port of call, then when not answered, go to a group of ppl
then eventually we will land it in a voice mailbox
if i have a call queuewhere there is an agent in the list, and below that a group of users, set as serial routingwill the call hit the first person and when not answered ring dist group members simutatenouslyso, we want the receptionist to the be the first port of call, then when not answered, go to a group of pplthen eventually we will land it in a voice mailbox Read More
Excel to copy rows of the same unique ID and their values to another workbook
Hello,
I have 2 workbooks that I would like to link and do some automation. I would like to copy all rows with the same ID (Cindy) and their values from one workbook to another workbook with a spreadsheet named Cindy and Kim to a spreadsheet named Kim.
Any help is appreciated.
Hello, I have 2 workbooks that I would like to link and do some automation. I would like to copy all rows with the same ID (Cindy) and their values from one workbook to another workbook with a spreadsheet named Cindy and Kim to a spreadsheet named Kim.Any help is appreciated. Read More
outlook doesnt work
yahoo mail has taken over cox webmail now outlook does not work also i have an app (simplywise) it does not work i can not get outlook to open
yahoo mail has taken over cox webmail now outlook does not work also i have an app (simplywise) it does not work i can not get outlook to open Read More
RANDARRAY
Hi All,
I want to know about the RANDARRAY usecases and how creatively we can use the RAND, RANDBETWEEN and RANDARRAY formulas in excel.
Regards,
Shashwat
Hi All, I want to know about the RANDARRAY usecases and how creatively we can use the RAND, RANDBETWEEN and RANDARRAY formulas in excel. Regards, Shashwat Read More
From Copilot Pro to Copilot for Microsoft 365
Hello Friends:
Since 4 months ago I bought Copilot Pro from the Play Store on my Android and I would like to change the same account to Copilot for Microsoft 365.
What should I do?
Sign up for Copilot for Microsoft 365 and then unsubscribe from Copilot Pro?
Is there any way to switch my account directly to Copilot for Microsoft 365?
Thank you in advance for your help.
Hello Friends:Since 4 months ago I bought Copilot Pro from the Play Store on my Android and I would like to change the same account to Copilot for Microsoft 365. What should I do?Sign up for Copilot for Microsoft 365 and then unsubscribe from Copilot Pro?Is there any way to switch my account directly to Copilot for Microsoft 365? Thank you in advance for your help. Read More
Taskbar pinned Microsoft ToDo no longer has an icon.
Even after reboot it’s still a blank black box. The “assets” are still in the Assets folder under C:Program FilesWindowsAppsMicrosoft.Todos_2.114.7122.0_x64__8wekyb3d8bbwe
Even after reboot it’s still a blank black box. The “assets” are still in the Assets folder under C:Program FilesWindowsAppsMicrosoft.Todos_2.114.7122.0_x64__8wekyb3d8bbwe Read More
Use Sharepoint to record and file client information
Hey guys!
I am wanting to create a kind of CRM in Sharepoint to record customer information and activity.
I am aware of the Lists option, however I am wanting somewhere where I can update client information so that if an agent goes to this clients record they can see things that other agents have done (eg. 3/11/2022 – Client rang Agent 01 and asked about this. 05/04/2023 – Client emailed, Agent 02 responded and assisted with that…., etc)
It would also be nice that any email that comes in from this contact can be added to this Client’s information.
So I would like it to include:
– Client Information (Name, email, phone number, etc)
– Client History (phone calls, emails, information provided to the client, etc)
– Client Emails (connected from Outlook)
NOTE: I am not wanting anything fancy or complex. Just for it to store basic information and history as mentioned. I’d prefer not to have to go to a third-party CRM.
Hopefully this is doable and someone knows. I am pretty good at figuring things out for myself – just need to be pointed in the right direction and given basic points and I’ll be good to go. Thanks !
Hey guys! I am wanting to create a kind of CRM in Sharepoint to record customer information and activity. I am aware of the Lists option, however I am wanting somewhere where I can update client information so that if an agent goes to this clients record they can see things that other agents have done (eg. 3/11/2022 – Client rang Agent 01 and asked about this. 05/04/2023 – Client emailed, Agent 02 responded and assisted with that…., etc) It would also be nice that any email that comes in from this contact can be added to this Client’s information. So I would like it to include: – Client Information (Name, email, phone number, etc) – Client History (phone calls, emails, information provided to the client, etc) – Client Emails (connected from Outlook) NOTE: I am not wanting anything fancy or complex. Just for it to store basic information and history as mentioned. I’d prefer not to have to go to a third-party CRM. Hopefully this is doable and someone knows. I am pretty good at figuring things out for myself – just need to be pointed in the right direction and given basic points and I’ll be good to go. Thanks ! Read More
Converting Google Sheet formula into excel
Hi All!
I have a unique google sheet formula that a very kind person created for me. My issue is I need to see if there is a way to get this formula to work in excel. Now the interesting thing is it looks like the formula ALMOST works. If you put a ‘ in front of this formula it works, however the formula stays in the cell that we put it in. For example we have are putting this formula in K2 and the data populates in K3-K52, but the formula stays in K2 instead of how it works in google sheets where the formula moves to the background and the data populates in the cell.
I’m not sure if that’s just a compatibility issue or what.
Here is the google sheet formula:
=BYROW($J$2:$J,LAMBDA(d,IF(d=“”,,SUM(MAP({1440,60,1},{“d”,“h”,“m”},LAMBDA(m,t,m*IFERROR(REGEXEXTRACT(d,“(d+)(?: “&t&“)”))))))))
Here is a link to the excel spreadsheet
Hi All!I have a unique google sheet formula that a very kind person created for me. My issue is I need to see if there is a way to get this formula to work in excel. Now the interesting thing is it looks like the formula ALMOST works. If you put a ‘ in front of this formula it works, however the formula stays in the cell that we put it in. For example we have are putting this formula in K2 and the data populates in K3-K52, but the formula stays in K2 instead of how it works in google sheets where the formula moves to the background and the data populates in the cell.I’m not sure if that’s just a compatibility issue or what.Here is the google sheet formula:=BYROW($J$2:$J,LAMBDA(d,IF(d=””,,SUM(MAP({1440,60,1},{“d”,”h”,”m”},LAMBDA(m,t,m*IFERROR(REGEXEXTRACT(d,”(d+)(?: “&t&”)”))))))))Here is a link to the excel spreadsheet Read More
need help to fix sharepoint for Microsoft office 365
Hi MS, I need need help to fix sharepoint for Microsoft office 365
Sorry, something went wrong
An unexpected error has occurred.
Technical Details
Troubleshoot issues with Microsoft SharePoint Foundation.
Correlation ID: 80c725a1-7095-3000-335b-98ab79ed7fc7
Hi MS, I need need help to fix sharepoint for Microsoft office 365 Sorry, something went wrongAn unexpected error has occurred.Technical DetailsTroubleshoot issues with Microsoft SharePoint Foundation.Correlation ID: 80c725a1-7095-3000-335b-98ab79ed7fc7 Read More