Category: Microsoft
Category Archives: Microsoft
📢 Announcement!! Azure Open AI and Azure AI Search connectors are now Generally Available (GA)
Announcing General Availability: Azure Open AI and AI Search Connectors for Logic Apps
We are thrilled to announce the General Availability of the Azure Open AI and AI Search connectors for Logic Apps. These new connectors integrate the power of Azure Open AI’s natural language processing with Azure AI Search’s intelligent search capabilities, enabling developers to build intelligent, AI-driven applications seamlessly.
Innovate where you Integrate
Data is the cornerstone of any AI application, unique to each organization. Business processes, whether in the cloud or within a VNET, rely on this data and can be managed by modern or legacy applications. Regardless of where your data resides, Azure Logic Apps offers the ability to easily infuse AI into both new and existing business processes.
With over 1000 connectors to various applications and services, Logic Apps simplifies the integration of AI, enabling the development of Retrieval-Augmented Generation (RAG) applications. This seamless integration enhances the functionality and intelligence of your business processes, ensuring that your applications are both innovative and efficient.
By leveraging these connectors alongside AI services, organizations can transform their operations and generate intelligent insights like never before. Whether it’s automating routine tasks, enhancing customer interactions and support, or generating insights, Azure Logic Apps provides a robust platform for embedding AI into your enterprise’s fabric.
RAG-based Patterns for AI Applications using Azure Logic Apps
Using Logic Apps and these AI connectors, you can quickly build and productionize AI applications based on RAG pattern. Retrieval-Augmented Generation (RAG) combines retrieval and generative models to improve the accuracy and relevance of AI-generated content. This pattern is particularly useful in scenarios where precise information retrieval is crucial, such as:
Customer Support Automation
Automate customer support by generating accurate responses using Azure Open AI and retrieving relevant information from knowledge bases with Azure AI Search.
Document Processing
Streamline document-heavy processes by summarizing, extracting key information, and translating documents with Azure Open AI, while Azure AI Search enables quick document retrieval.
Content Generation
Create high-quality content for blogs and social media with the help of Azure Open AI, and ensure its accuracy and relevance using Azure AI Search.
Personalized Recommendations
Build personalized recommendation systems by analyzing user behavior with Azure Open AI and retrieving matching products, services, or content using Azure AI Search.
Healthcare Data Management
Enhance healthcare data management by summarizing patient records and extracting critical information with Azure Open AI, while Azure AI Search helps in quickly locating specific patient information or research articles.
Financial Analysis and Reporting
Improve financial analysis by generating comprehensive financial reports using Azure Open AI and retrieving relevant financial data and market trends with Azure AI Search.
Key Features and Capabilities
The connectors simplify backend processes with a codeless setup, reducing the complexity of integrating AI capabilities into workflows.
The Azure OpenAI Connector provides powerful AI functionalities such as generating embeddings, summarization, and chat completion, which are pivotal for creating sophisticated AI applications. Meanwhile, the Azure AI Search Connector enhances data retrieval with advanced vector and hybrid search operations.
You can ingest and retrieve both structured and unstructured data and in various formats such as documents, pdfs, json, text and more.
Getting Started
To get started with the Azure OpenAI and Azure AI Search connector for Logic Apps, visit the MS Learn documentation. Here, you will find detailed guides on how to set up and integrate these powerful tools into your workflows.
What’s Next
The General Availability of the Azure OpenAI and Azure AI Search connector for Logic Apps marks a significant step forward in the integration of AI into business processes. By leveraging these cutting-edge technologies, businesses can unlock new levels of efficiency, intelligence, and innovation. We are excited to see how you will use these capabilities to transform your workflows and drive success.
Stay tuned for more updates and case studies showcasing the impact of Azure OpenAI and Azure AI Search on various industries. As always, we are committed to supporting your journey towards a more intelligent and automated future.
Microsoft Tech Community – Latest Blogs –Read More
Steps to Manually Add PowerShell Modules in Function App
Function App lets you leverage PowerShell gallery for managing dependencies. Your PowerShell modules defined in requirements.psd1 file will be downloaded automatically if you enable dependency management. However, if your Function App runs on Consumption plan and the size of dependent modules is too large, chances are the download would fail. During the installation, the modules would be unziped and saved in the “D:localTemp”, which is the temp storage on the plan worker. Due to the 500 MB limit of temp storage on consumption plan, the installation would fail with not enough space error:
System Log: { Log-Level: Warning; Log-Message: Save-Module(‘Microsoft.Graph’, ‘2.18.0’): Package ‘Microsoft.Graph.Files’ failed to be installed because: There is not enough space on the disk. : ‘C:localTemp282636592Microsoft.Graph.Files.2.18.0binMicrosoft.Graph.Files.private.dll’ }
The easiest workaround is to scale up the function app plan to premium plan, as premium plan has much larger temp file size. However, this is not the most cost-saving option. You can install the module seperately to the app without depending on the dependency management feature either from local deployment or manual installation from the portal. Here I provide the steps with the second option to add the PowerShell modules directly using “Advanced Tools”.
Find and download modules from PowerShell Gallery to your local system. You should choose “manual download” and download the .nupkg files of the modules.
Unzip the .nupkg files and rename the folder to the module official name without the version number.
Open “App Service Editor” and create a new folder with name “Modules” under “wwwroot” folder.
Go to SCM site of the Function App and navigate to “C:homesitewwwrootModules” path on the file system.
Drag and drop the module package that you have downloaded before to the “Modules” folder on the SCM site.
Go to “App Files”, modify the “requirements.psd1” as the following, with the corresponding version number of the module:
In “host.json file”, verify the managedDependency setting has a value of “Enabled” and is set to “False”.
Restart the app, which is very important.
Now, you have successfully added the PowerShell modules to the Function App running on consumption plan, minus the “not enough space” error.
Microsoft Tech Community – Latest Blogs –Read More
How Does MS Word default display characteristics
I have a docx that contains the following two fragments <w:r> <w:rPr> <w:rFonts w:ascii=”Times” w:hAnsi=”Times”/> <w:b w:val=”1″/> <w:bCs w:val=”1″/> <w:sz w:val=”24″/> <w:szCs w:val=”24″/> <w:rtl w:val=”0″/> <w:lang w:val=”es-ES_tradnl”/> </w:rPr> <w:t>Bold Text 1</w:t></w:r>…<w:r> <w:rPr> <w:rFonts w:ascii=”Times” w:hAnsi=”Times”/> <w:b w:val=”1″/> <w:bCs w:val=”1″/> <w:rtl w:val=”0″/> </w:rPr> <w:t>Bold Text 2</w:t></w:r> Both “Bold Text 1” and “Bold Text 2” are displayed (and defined) as 12 Point text, yet both the sz and szCs tags are missing from the definition of “Bold Text 2” I cant help thinking that MS Word implements a mechanism for defaulting tag values. Can anyone provide insight into this mechanism. I realize I havnt provided much contextual information, and can provide this if required. But I cant help thinking that this is a general implmentation issue for MS Word. Grevillea Read More
How do you customize Start Menu pins of an AD user?
I’ve got a bit of an issue. Windows 11 Pro, and this is an Active Directory user. We use Group Policy, not Intune. Also, right-click is disabled on the Start Menu and Desktop.
I’d assumed that customizing the Start Menu was as easy as creating a .JSON file and importing it via Powershell. That, or applying the .JSON file via Group Policy. It turns out you can’t apply a .JSON file using Group Policy.
Currently, the Start Menu pins are default, so they link a bunch of random Windows apps. None of the existing Start Menu pins are of use, so I’d like to remove them all and create my own.
I could not find a working solution to remove the pins, as I tried a Powershell script. I also couldn’t add any shortcuts.
I want to avoid the use of third-party software. How can I customize the Start Menu?
I’ve got a bit of an issue. Windows 11 Pro, and this is an Active Directory user. We use Group Policy, not Intune. Also, right-click is disabled on the Start Menu and Desktop.I’d assumed that customizing the Start Menu was as easy as creating a .JSON file and importing it via Powershell. That, or applying the .JSON file via Group Policy. It turns out you can’t apply a .JSON file using Group Policy.Currently, the Start Menu pins are default, so they link a bunch of random Windows apps. None of the existing Start Menu pins are of use, so I’d like to remove them all and create my own.I could not find a working solution to remove the pins, as I tried a Powershell script. I also couldn’t add any shortcuts.I want to avoid the use of third-party software. How can I customize the Start Menu? Read More
Windows 11 not refreshing
Recently I installed Windows 11 and hence then my windows doesn’t refresh automatically. Every time I have to refresh manually to see any chances both in desktop and in folders.
Tried everything found in the net. Nothing working.
I run windows update, does some tweaks in the registry, run certain commands in the command prompt… nothing working.
Please help.
Recently I installed Windows 11 and hence then my windows doesn’t refresh automatically. Every time I have to refresh manually to see any chances both in desktop and in folders.Tried everything found in the net. Nothing working.I run windows update, does some tweaks in the registry, run certain commands in the command prompt… nothing working.Please help. Read More
Windows 11 just started to chew up RAM. ~15 GB unaccounted for.
Hey guys, possible this is a known thing, but in the last few days, I’ve noticed a huge amount of memory getting consumed by seemingly nothing or some background service. Which I only really noticed since Star Citizen complained about having less than 8 GB of free memory.
I have 64 GB of RAM here, and ~15 GB is not accounted for. The consumption got so out of hand that I had to restart my computer to keep it at bay….
I sort of wonder if this is that new Windows 11 recording feature.
not sure, any ideas?
Is there any software that can tell me what’s happening in the background?
Hey guys, possible this is a known thing, but in the last few days, I’ve noticed a huge amount of memory getting consumed by seemingly nothing or some background service. Which I only really noticed since Star Citizen complained about having less than 8 GB of free memory. I have 64 GB of RAM here, and ~15 GB is not accounted for. The consumption got so out of hand that I had to restart my computer to keep it at bay….I sort of wonder if this is that new Windows 11 recording feature.not sure, any ideas?Is there any software that can tell me what’s happening in the background? Read More
Disable “Share to Outlook” options in Microsoft teams for tenant
Hello Everyone,
I am looking for assistance in disabling the “Share to Outlook” option across our tenant, either through the Teams admin center or via PowerShell. Despite my efforts to search for a solution, I haven’t been able to find the correct approach.
If anyone could provide guidance or share a method to accomplish this, it would be greatly appreciated.
Thank you in advance for your help!
Hello Everyone, I am looking for assistance in disabling the “Share to Outlook” option across our tenant, either through the Teams admin center or via PowerShell. Despite my efforts to search for a solution, I haven’t been able to find the correct approach. If anyone could provide guidance or share a method to accomplish this, it would be greatly appreciated.Thank you in advance for your help! Read More
Azure SQL Database Contained user creation Issue
I am working on a solution to integrate the Azure FunctionApp with Azure SQL Database using Managed Identity. Resources are provisioned through terraform and the function app is now having a user assigned managed Identity. However the final step to add the managed identity as a contanied user inside the Azure SQL Database is failing/user is not created inside the Azure SQL database. Here are the steps I have tried.
Approach 1.
Got the below error
I am working on a solution to integrate the Azure FunctionApp with Azure SQL Database using Managed Identity. Resources are provisioned through terraform and the function app is now having a user assigned managed Identity. However the final step to add the managed identity as a contanied user inside the Azure SQL Database is failing/user is not created inside the Azure SQL database. Here are the steps I have tried. Approach 1. – task: AzureCLI@2 displayName: Determine SQL Server SID for managed identity created for Az Func inputs: azureSubscription: ${{variables.devServiceConnection}} scriptType: pscore scriptLocation: inlineScript failOnStandardError: false inlineScript: | # We need to have the ApplicationId of the App Registration that represents the # WebApp. The SID is calculated based on the ApplicationId $apiSp = az ad sp list –display-name mi-afsintegration-dev | ConvertFrom-Json $appId = $apiSp.appId [guid]$guid = [System.Guid]::Parse($appId) foreach ($byte in $guid.ToByteArray()) { $byteGuid += [System.String]::Format(“{0:X2}”, $byte) } $sid = “0x” + $byteGuid Write-Host “##vso[task.setvariable variable=mi-afsintegration-dev.Sid]$sid” – task: SqlAzureDacpacDeployment@1 displayName: ‘Create login for managed identity’ inputs: azureSubscription: ${{variables.devServiceConnection}} ServerName: ‘$(SQL_ServerName)’ DatabaseName: ‘$(DB_Name)’ SqlUsername: ‘$(SQL_Username)’ SqlPassword: ‘$(SQL_Password)’ deployType: ‘inlineSqlTask’ sqlInline: | IF NOT EXISTS (SELECT * FROM sys.database_principals WHERE name = ‘mi-afsintegration-dev’) BEGIN CREATE USER [mi-afsintegration-dev] WITH sid = $(sid), TYPE = E ALTER ROLE db_datareader ADD MEMBER [mi-afsintegration-dev]; ALTER ROLE db_datawriter ADD MEMBER [mi-afsintegration-dev]; END IpDetectionMethod: ‘AutoDetect’ Got the below error Exception calling “Parse” with “1” argument(s): “Unrecognized Guid format.” At D:a_tempazureclitaskscript1717787636114_inlinescript.ps1:7 char:1 + [guid]$guid = [System.Guid]::Parse($appId) + ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ + CategoryInfo : NotSpecified: (:) [], ParentContainsErrorRecordException + FullyQualifiedErrorId : FormatException ##[error]Script failed with exit code: 1 Have no idea, why this error is coming up. Approach 2. Removing the Azure CLI task and trying to create the SQL User with the managed Identity directly. However the user is not still created in the DB, but there are no errors this time. – task: SqlAzureDacpacDeployment@1 displayName: ‘Create login for managed identity’ inputs: azureSubscription: ${{variables.devServiceConnection}} ServerName: ‘$(SQL_ServerName)’ DatabaseName: ‘$(DB_Name)’ SqlUsername: ‘$(SQL_Username)’ SqlPassword: ‘$(SQL_Password)’ deployType: ‘inlineSqlTask’ sqlInline: | IF NOT EXISTS (SELECT * FROM sys.database_principals WHERE name = ‘mi-afsintegration-dev’) BEGIN CREATE USER [mi-afsintegration-dev] FROM EXTERNAL PROVIDER ALTER ROLE db_datareader ADD MEMBER [mi-afsintegration-dev]; ALTER ROLE db_datawriter ADD MEMBER [mi-afsintegration-dev]; END IpDetectionMethod: ‘AutoDetect’ Can someone please provide any guidance on how to get this done? ThanksDD Read More
Referencing items in a document
Hi all,
I seek guidance on the best and easiest practices to achieve the following.
First, let me paint the use case.
I have a template that around 50 people will use to create new and ongoing instances of this document.
In this document, they detail how a system will be set up for their client. This setup includes many details that they document in a process flow methodology. They will mention key things like reports, rules, in-product queries, screen changes, and so on that need to be done as part of the solution.
What I am looking to achieve is that a list of each of these reports, rules, in-product queries, and screen changes are captured at the end of the document, creating a succinct list of what is needed for each. For example, the user creating the document may mention ten different reports that are needed. I, therefore, need a section called Reports, which will reference every report mentioned and the page(s) on which it was mentioned. Then, I want the same for the rules, in-product queries, and screen changes.
Since the users creating this document are not Word experts, I want it to be easy for them to “mark” in the text they are typing that this is a report. Marking this will then add it to the reports section at the end of the document.
I would love to hear people’s ideas on achieving this.
Thanks,
Hi all,I seek guidance on the best and easiest practices to achieve the following. First, let me paint the use case.I have a template that around 50 people will use to create new and ongoing instances of this document.In this document, they detail how a system will be set up for their client. This setup includes many details that they document in a process flow methodology. They will mention key things like reports, rules, in-product queries, screen changes, and so on that need to be done as part of the solution. What I am looking to achieve is that a list of each of these reports, rules, in-product queries, and screen changes are captured at the end of the document, creating a succinct list of what is needed for each. For example, the user creating the document may mention ten different reports that are needed. I, therefore, need a section called Reports, which will reference every report mentioned and the page(s) on which it was mentioned. Then, I want the same for the rules, in-product queries, and screen changes. Since the users creating this document are not Word experts, I want it to be easy for them to “mark” in the text they are typing that this is a report. Marking this will then add it to the reports section at the end of the document. I would love to hear people’s ideas on achieving this. Thanks, Read More
Can I transfer files after work and school’s OneDrive account is out of service.
My university has stopped supporting OneDrive storage. I would an annual subscription to transfer those data out of Onedrive. Can I do it? I don’t want to lose all of them.
My university has stopped supporting OneDrive storage. I would an annual subscription to transfer those data out of Onedrive. Can I do it? I don’t want to lose all of them. Read More
Architecture of teams tab app?
I’m looking into a teams tab integration for a web app. The idea is this teams tab app will just be a static page for now with some buttons that redirects users. When reading the docs on getting started building I noticed they tell you to provision and deploy your app. I’m wondering if this means the app is actually deployed somewhere (running on a machine) and teams just embeds it or if teams is downloading the source code when you install an app on your client? The ultimate goal is to submit this to MS to publish to the MS store but I’m having trouble understanding what is actually being hosted and how teams accesses the content. Any information would be helpful!
I’m looking into a teams tab integration for a web app. The idea is this teams tab app will just be a static page for now with some buttons that redirects users. When reading the docs on getting started building I noticed they tell you to provision and deploy your app. I’m wondering if this means the app is actually deployed somewhere (running on a machine) and teams just embeds it or if teams is downloading the source code when you install an app on your client? The ultimate goal is to submit this to MS to publish to the MS store but I’m having trouble understanding what is actually being hosted and how teams accesses the content. Any information would be helpful! Read More
New Outlook Desktop 365 Add-ins Not Showing on Secondary Mailboxes
I’m testing the New Outlook desktop version, and I have encountered an issue with add-ins. My primary inbox is Jeff@furni*******.com, and when I create a new email from this account, the signature add-ins load fine. I am using the CodeTwo 365 Signatures add-in, but it seems that the add-ins are displayed only for the primary default inbox and not for any other mailboxes. However, when I create a new email from another inbox, such as Jeff@edro*******.com, the add-in pane doesn’t load, and the signatures are not imported.
This problem seems specific to the new Outlook desktop version. When I use the Outlook web app at https://outlook.office365.com/ or the old Outlook desktop version, the add-ins load correctly for all mailboxes.
It appears that the new Outlook desktop version only loads add-ins based on the primary mailbox. Even if I switch to another mailbox account, the add-ins do not load, unlike in the desktop and web versions where they load as expected once I choose another mailbox on the left pane and click compose email ill see the addins assigned to that mailbox on the editor pane.
Now if I actually change one of the mailboxes to “Set as Primary Account” the addins will load fine but only for that mailbox.
Version Details:
New Outlook Desktop Version:
Microsoft Outlook Version: 1.2024.529.200 (Production)Client Version: 20240531006.09WebView2 Version: 125.0.2535.85Session ID: bd1b8ccd-6d00-5b4b-bb4a-1307f365c0bf
Old Outlook Desktop Version:
Microsoft® Outlook® for Microsoft 365 MSO Version 2405 Build 16.0.17628.20006 64-bit
Is this a known issue, and are there any workarounds or solutions available?
I’m testing the New Outlook desktop version, and I have encountered an issue with add-ins. My primary inbox is Jeff@furni*******.com, and when I create a new email from this account, the signature add-ins load fine. I am using the CodeTwo 365 Signatures add-in, but it seems that the add-ins are displayed only for the primary default inbox and not for any other mailboxes. However, when I create a new email from another inbox, such as Jeff@edro*******.com, the add-in pane doesn’t load, and the signatures are not imported. This problem seems specific to the new Outlook desktop version. When I use the Outlook web app at https://outlook.office365.com/ or the old Outlook desktop version, the add-ins load correctly for all mailboxes.It appears that the new Outlook desktop version only loads add-ins based on the primary mailbox. Even if I switch to another mailbox account, the add-ins do not load, unlike in the desktop and web versions where they load as expected once I choose another mailbox on the left pane and click compose email ill see the addins assigned to that mailbox on the editor pane. Now if I actually change one of the mailboxes to “Set as Primary Account” the addins will load fine but only for that mailbox. Version Details:New Outlook Desktop Version:Microsoft Outlook Version: 1.2024.529.200 (Production)Client Version: 20240531006.09WebView2 Version: 125.0.2535.85Session ID: bd1b8ccd-6d00-5b4b-bb4a-1307f365c0bfOld Outlook Desktop Version:Microsoft® Outlook® for Microsoft 365 MSO Version 2405 Build 16.0.17628.20006 64-bitIs this a known issue, and are there any workarounds or solutions available? Read More
Request By shows by creator and not person who requested
I have created a leave request flow in PowerAutomate.
Employees fill out a form (on Microsoft Forms) and this gets sent to the department manager to approve and then to the Managing Director to finalise approval.
For some reason, in Teams, it is showing that it was requested by me (as I created the flow) and not the person requesting the leave.
Is there a way I can change this?
I have created a leave request flow in PowerAutomate. Employees fill out a form (on Microsoft Forms) and this gets sent to the department manager to approve and then to the Managing Director to finalise approval. For some reason, in Teams, it is showing that it was requested by me (as I created the flow) and not the person requesting the leave. Is there a way I can change this? Read More
server 2022 suddenly shutdown
I have a Windows server 2022 standard that suddenly shutdown and I can’t find the reason why. I have the two events that have numbers saying why, but I can’t find a definition of what they mean. What do the two following events say about why a server just shutdown.
Information
6/7/2024 11:07:19 AM
Microsoft-Windows-Kernel-Power
566
-268
The system session has transitioned from 181 to 183. Reason: 21
Information
6/7/2024 11:07:19 AM
User32
1074
None
The process C:Windowssystem32winlogon.exe (MYSERVER) has initiated the power off of computer MYSERVER on behalf of user NT AUTHORITYSYSTEM
for the following reason: No title for this reason could be found
Reason Code: 0x500ff
Shutdown Type: power off
Comment:
Thanks.
I have a Windows server 2022 standard that suddenly shutdown and I can’t find the reason why. I have the two events that have numbers saying why, but I can’t find a definition of what they mean. What do the two following events say about why a server just shutdown. Information6/7/2024 11:07:19 AMMicrosoft-Windows-Kernel-Power566-268The system session has transitioned from 181 to 183. Reason: 21 Information6/7/2024 11:07:19 AMUser321074NoneThe process C:Windowssystem32winlogon.exe (MYSERVER) has initiated the power off of computer MYSERVER on behalf of user NT AUTHORITYSYSTEMfor the following reason: No title for this reason could be foundReason Code: 0x500ffShutdown Type: power offComment: Thanks. Read More
Entra Cloud Sync Not Applying Assigned OU Filters
I am working to setup Entra Cloud Sync to sync a single OU from my on-premises AD to Entra AD. I have installed the latest Entra Cloud Sync agent on my single DC and setup the necessary configuration in the Entra Cloud Sync portal area. I have applied a scoping filter for the single OU that I need to sync for two AD security groups. This all saves properly. However, when I go to enable the configuration, I get an overview of what changes will occur and the scoping filters section at the bottom shows clearly “All Users” even though my configuration has defined scoping filters setup. I cannot proceed with all users as I have some areas and users that I cannot modify AD permissions. I have deleted and re-setup my configuration multiple times but the same continues.
Any input and suggestions are appreciated.
Scoping filters
Object scope filters
All users
I am working to setup Entra Cloud Sync to sync a single OU from my on-premises AD to Entra AD. I have installed the latest Entra Cloud Sync agent on my single DC and setup the necessary configuration in the Entra Cloud Sync portal area. I have applied a scoping filter for the single OU that I need to sync for two AD security groups. This all saves properly. However, when I go to enable the configuration, I get an overview of what changes will occur and the scoping filters section at the bottom shows clearly “All Users” even though my configuration has defined scoping filters setup. I cannot proceed with all users as I have some areas and users that I cannot modify AD permissions. I have deleted and re-setup my configuration multiple times but the same continues. Any input and suggestions are appreciated.Scoping filtersObject scope filtersAll users Read More
Info about account recovery form
Long story short, it’s been three whole weeks since I’ve been locked out of my email. Microsoft detected suspicious activity into my account cause I’ve switched broadband provider and this error started occuring the day I was done with the migration.
I’ve tried to compile the recovery form several times now but the response I got is that there weren’t enough informations to work with.
Now, I’ve managed to recover a Skype account tied with my blocked email, the only thing is this account was created before the live and outlook domains were even merged, so I’m wondering if it’s still okay if I provide information relevant to that account?
Also, am I supposed to write down my contact’s skype name or usernames?
Thanks in advance.
Long story short, it’s been three whole weeks since I’ve been locked out of my email. Microsoft detected suspicious activity into my account cause I’ve switched broadband provider and this error started occuring the day I was done with the migration.I’ve tried to compile the recovery form several times now but the response I got is that there weren’t enough informations to work with. Now, I’ve managed to recover a Skype account tied with my blocked email, the only thing is this account was created before the live and outlook domains were even merged, so I’m wondering if it’s still okay if I provide information relevant to that account? Also, am I supposed to write down my contact’s skype name or usernames? Thanks in advance. Read More
New Here!! Glad to be here!
Hello Everyone.
I just joined the techcommunity. I am glad to be a part of this community.
Hello Everyone. I just joined the techcommunity. I am glad to be a part of this community. Read More
switch counts for each item
Dear Experts,
I have a Data (as attached ),
In column “D”, we have item name as “rnti” and each rnti can have switch in ueBwpId (from 0>1>2),
in sheet2, I want to make a summary for each rnti how many switches happened example as below
for rnti = [28559] in column “E”, should have count of all the switches from ueBwpId from 2->1 ,
Thanks in Advance,
Br,
Anupam
Dear Experts, I have a Data (as attached ),In column “D”, we have item name as “rnti” and each rnti can have switch in ueBwpId (from 0>1>2),in sheet2, I want to make a summary for each rnti how many switches happened example as belowfor rnti = [28559] in column “E”, should have count of all the switches from ueBwpId from 2->1 ,Thanks in Advance,Br,Anupam Read More
chanvannak2211.powerappsportals.com
chanvannak2211.powerappsportals.com
chanvannak2211.powerappsportals.com
chanvannak2211.powerappsportals.com chanvannak2211.powerappsportals.com Read More
Help with weekly data project
Hi! I work with attendance data every week and don’t know much about Excel or how I can make things quicker and easier. I work with attendance data, which comes from our ticketing service in three columns – amount of tickets registered in each order, visitor zip code for those tickets, and the day of the week the tickets were for (see example below). Basically, I need the zip codes to each appear in a separate column the amount of times that a ticket is made with that zip code (so if there are 9 total tickets for the zip code 19107, the new column would have nine cells reading 19107). These new columns would represent the day of the week the ticket occurred (see second image below) From this point, I have shortcuts that make the data easy to work with for the purposes of my reporting, so no recommendations are needed for how to take the data forward from there. I just don’t want to have to individually type zip codes for the amount of times they occur. Please let me know what I can do or if further explanation is needed.
Hi! I work with attendance data every week and don’t know much about Excel or how I can make things quicker and easier. I work with attendance data, which comes from our ticketing service in three columns – amount of tickets registered in each order, visitor zip code for those tickets, and the day of the week the tickets were for (see example below). Basically, I need the zip codes to each appear in a separate column the amount of times that a ticket is made with that zip code (so if there are 9 total tickets for the zip code 19107, the new column would have nine cells reading 19107). These new columns would represent the day of the week the ticket occurred (see second image below) From this point, I have shortcuts that make the data easy to work with for the purposes of my reporting, so no recommendations are needed for how to take the data forward from there. I just don’t want to have to individually type zip codes for the amount of times they occur. Please let me know what I can do or if further explanation is needed. Read More
