Tag Archives: microsoft
VLOOKUP not working on table created with sharepoint query
I have a table its in a worksheet called RMs.
The table is made from a query of a sharepoint list, which is a raw materials database held on SP.
On another sheet a user can enter a raw material code which is searched for using vlookup on the Sharepoint query table in the RMs worksheet. The Numbers is in the first column of the table and the user entered cell are formatted as a number.
When I test the match using the formula =$C7=RMs!$A8 which should be a match I get a FALSE.
When I test it with =$C7=VALUE(RMs!$A8) I get TRUE.
Both cell formats are set to number with no decimals.
I have no idea what is causing the format issue here other than perhaps the data in the table is seen differently by the Vlookup function.
The Vlookup formula is…..
=IF(ISERROR(VLOOKUP($C9,RMs!$A$4:$J$2000,1,FALSE)),,VLOOKUP($C9,RMs!$A$4:$J$2000,2,FALSE))
First error checks that there is a code in the first column, then if there is, gets the name of the ingredient from the second column in the lookup.
Any Ideas
I have a table its in a worksheet called RMs. The table is made from a query of a sharepoint list, which is a raw materials database held on SP. On another sheet a user can enter a raw material code which is searched for using vlookup on the Sharepoint query table in the RMs worksheet. The Numbers is in the first column of the table and the user entered cell are formatted as a number. When I test the match using the formula =$C7=RMs!$A8 which should be a match I get a FALSE. When I test it with =$C7=VALUE(RMs!$A8) I get TRUE. Both cell formats are set to number with no decimals. I have no idea what is causing the format issue here other than perhaps the data in the table is seen differently by the Vlookup function. The Vlookup formula is…..=IF(ISERROR(VLOOKUP($C9,RMs!$A$4:$J$2000,1,FALSE)),,VLOOKUP($C9,RMs!$A$4:$J$2000,2,FALSE)) First error checks that there is a code in the first column, then if there is, gets the name of the ingredient from the second column in the lookup. Any Ideas Read More
Running Powershell Scripts – Windows 11 Laptop – Local Admin
Hi All,
I am going round in circle’s trying to deploy some powershell scripts, they are required to do some pretty simple tasks, like download a file from a suppliers website and set the wallpaper to a certain background.
The device is a Windows 11 laptop, Enrolled in Intune and deployed with Autopilot.
The device only has a local admin account (due to the laptop being off the network for long periods and customer needs).
I have a PS script that creates a local admin account and password, this works no problem.
The next script sets the welcome screen, lock screen and the user wallpaper, this work for the first two but doesn’t change for the logged in user.
The last script should download a file from a suppliers website and save it on the desktop.
This deploys with Intune but errors. I have run the script directly on the laptop and it works.
Am I missing something?
Can scripts be deployed by Intune and ran when end user is a local admin?
I have tried changing this setting and still doesn’t work “Run this script using the logged on credentials”
Any help is appreciated.
Hi All, I am going round in circle’s trying to deploy some powershell scripts, they are required to do some pretty simple tasks, like download a file from a suppliers website and set the wallpaper to a certain background. The device is a Windows 11 laptop, Enrolled in Intune and deployed with Autopilot.The device only has a local admin account (due to the laptop being off the network for long periods and customer needs). I have a PS script that creates a local admin account and password, this works no problem.The next script sets the welcome screen, lock screen and the user wallpaper, this work for the first two but doesn’t change for the logged in user.The last script should download a file from a suppliers website and save it on the desktop.This deploys with Intune but errors. I have run the script directly on the laptop and it works.Am I missing something? Can scripts be deployed by Intune and ran when end user is a local admin?I have tried changing this setting and still doesn’t work “Run this script using the logged on credentials” Any help is appreciated. Read More
Fabric Security explained in a Layered Approach
As a SaaS service, Fabric offers a complete security package for the entire platform. The Fabric platform comprises of experiences like include Lakehouse, Data Factory, Synapse Data Engineering, Synapse Data Warehouse, Power BI, and others. To understand the security in Fabric we have broken down Fabric components into the following layers:
Data – Where the data actually resides inside Fabric (Warehouse/Lakehouse/Eventhouse/OneLake/Fabric clusters)
Items – These are the building blocks of the Fabric platform. They’re the objects that you create and manage in Fabric. There are different types of items, such as data warehouses, data pipelines, semantic models, reports, and dashboards.
Workspace – A logical is a collection of items that brings together different functionality in a single tenant. It acts as a container that leverages capacity for the work that is executed, and provides controls for who can access the items in it. For example, in a sales workspace, users associated with the sales organization can create a data warehouse, run notebooks, create semantic models, create reports, etc.
Domain – A logical grouping of workspaces. Domains are used to organize items in a way that makes sense for your organization. You can group things together in a way that makes it easier for the right people to have access to the right workspaces. For example, you might have a domain for sales, another for marketing, and another for finance.
Capacity – A dedicated set of resources that is available at a given time to be used. A tenant can have one or more capacities associated with it. Capacity defines the ability of a resource to perform an activity or to produce output. Different items consume different capacity at a certain time. Fabric offers capacity through the Fabric SKU and Trials.
Tenant – A dedicated space for organizations to create, store, and manage Fabric items. There’s often a single instance of Fabric for an organization, and it’s aligned with Microsoft Entra ID. The Fabric tenant maps to the root of OneLake and is at the top level of the hierarchy.You can create any number of workspaces, which you can think of as folders, within a tenant.
One-lake – Microsoft Fabric Lake is also known as OneLake.There is OneLake per tenant. It comes automatically with every Microsoft Fabric tenant and is designed to be the single place for all your analytics data. Its the unified storage layer for Fabric
Power BI – Power BI is an online software service (SaaS, or Software as a Service) offering as part of Microsoft Fabric. Its the unified visualization layer for Fabric. When a Power BI report loads data from OneLake, the data goes through the internal Microsoft network.
Layer
Feature
Data Handling and Security
Encryption, Labelling, Customer Lockbox
Access Management
Authentication, Authorization, Workspace Identities, Guest user sharing
Item Security
Share item via link, Impact Analysis, Semantic Model, Data Warehouse, Lakehouse, Data Factory
Workspace Security
Workspace Roles, Access Management, Settings, Retention, Governance, Lineage, State
Domain Security
Domain Roles, Creation, Settings, Assignment, Endorsement, Auditing
Capacity Security
Tenant Concept and Settings, Capacity License and Features, Access Management, Consumption, Disaster Recovery
PowerBI Security
PowerBI Embedded Analytics, Row-level security, Object/Column-Level Security, Dynamic Data Masking
OneLake Security
Encryption, Restricted External Access, Shortcuts, Least Privilege, BCDR
Network Security
Private Endpoint, Private Links, Service Tags, URL’s and Ports
Microsoft Tech Community – Latest Blogs –Read More
Version 1.9 of the Microsoft 365 Licensing Report
The Microsoft 365 Licensing Report is a popular PowerShell script that’s just been updated to V1.9 with a bunch of changes to highlight different aspects such as license costs for disabled user accounts and inactive user accounts. Copious use of some very dubious color choices makes the HTML report created by the script look very nice (if you’re color blind) and the new version can generate an Excel worksheet.
https://office365itpros.com/2024/06/20/microsoft-365-licensing-report-19/
The Microsoft 365 Licensing Report is a popular PowerShell script that’s just been updated to V1.9 with a bunch of changes to highlight different aspects such as license costs for disabled user accounts and inactive user accounts. Copious use of some very dubious color choices makes the HTML report created by the script look very nice (if you’re color blind) and the new version can generate an Excel worksheet.
https://office365itpros.com/2024/06/20/microsoft-365-licensing-report-19/ Read More
Excel SQL Server connection and IP range
We have an Excel file in a teams site. The Excel connects to data in an azure sql server. We have a list of users that has access to the DB. However they got denied on their IP and we do not want to open for all ips. What is the recommended approach for such a scenario? Do we need to develop an api between?
We have an Excel file in a teams site. The Excel connects to data in an azure sql server. We have a list of users that has access to the DB. However they got denied on their IP and we do not want to open for all ips. What is the recommended approach for such a scenario? Do we need to develop an api between? Read More
Windows Update KB5037768 cause HDMI & 3 USB port to stop working
Has anyone else faced this issue where upon updating the patch KB5037768, their HDMI, and 3 USB port stopped working?
Model : HP ProBook 440 G3
OS : Windows 10
After removing the Patch, all the mentioned port is working again..
right now, am pausing windows update and waiting for possibly a revision or fix to this issue
Has anyone else faced this issue where upon updating the patch KB5037768, their HDMI, and 3 USB port stopped working? Model : HP ProBook 440 G3OS : Windows 10 After removing the Patch, all the mentioned port is working again..right now, am pausing windows update and waiting for possibly a revision or fix to this issue Read More
How to identify Azure AD B2C localization elementIDs and stringIDs for MS APIs
I’m working on localization in Azure AD B2C custom flows and I want to identify elementIDs and stringIDs to use for customizing messages displayed to users.
In general I would like to find a way to identify all the elementIDs and stringIDs for APIs like
api.selfasserted
api.selfasserted.totp
api.localaccountpasswordreset
api.signuporsignin
…
I’m using MS documentation https://learn.microsoft.com/en-us/azure/active-directory-b2c/localization-string-ids but it is incomplete specially on error messages like the ones displayed in TOTP verification page or selfasserted pages.
UserMessageIfIncorrectOTPCodeEntered is used to display a message when TOTP entered is incorrect. But what is the stringID used when the user enters an incomplete TOTP verification code (message is displayed as soon as the user starts typing the code “Enter the 6-digit verification code generated by the the Authenticator app in the box“) it might be something like UserMessageIf…. Or the stringID when the user enters a valid verification code but after the verification session has expired “The specified verification session is invalid or may have expired“
I’m working on localization in Azure AD B2C custom flows and I want to identify elementIDs and stringIDs to use for customizing messages displayed to users.In general I would like to find a way to identify all the elementIDs and stringIDs for APIs likeapi.selfassertedapi.selfasserted.totpapi.localaccountpasswordresetapi.signuporsignin…I’m using MS documentation https://learn.microsoft.com/en-us/azure/active-directory-b2c/localization-string-ids but it is incomplete specially on error messages like the ones displayed in TOTP verification page or selfasserted pages.UserMessageIfIncorrectOTPCodeEntered is used to display a message when TOTP entered is incorrect. But what is the stringID used when the user enters an incomplete TOTP verification code (message is displayed as soon as the user starts typing the code “Enter the 6-digit verification code generated by the the Authenticator app in the box”) it might be something like UserMessageIf…. Or the stringID when the user enters a valid verification code but after the verification session has expired “The specified verification session is invalid or may have expired” Read More
How to conditionally format a range of not blank cells, then check & format per category
Is there a way to conditionally format a range of cells [$C$6:$AT$25 or named range] using formula for the following? –
Firstly, check if cell is not blank [suggested code; NOT(ISBLANK($C$6:$AT$25))].
Then check column A on the same row as that cell and use the following rule:
If CATEGORY1 then format fill yellow,
If CATEGORY2 then format fill blue,
If CATEGORY3 then format fill green,
If CATEGORY4 then format fill red, and so on…
Is this possible in conditional formatting using formula and if so what is the best method?
Is there a way to conditionally format a range of cells [$C$6:$AT$25 or named range] using formula for the following? -Firstly, check if cell is not blank [suggested code; NOT(ISBLANK($C$6:$AT$25))].Then check column A on the same row as that cell and use the following rule:If CATEGORY1 then format fill yellow,If CATEGORY2 then format fill blue,If CATEGORY3 then format fill green,If CATEGORY4 then format fill red, and so on…Is this possible in conditional formatting using formula and if so what is the best method? Read More
شيخ روحاني الدفع بعد النتيجه واتس//+964 784 248 8906 جلب الحبيب الطاعة العمياء
When using a Microsoft 365 file handler add-in (OneDrive File Handlers 2.0) with two custom actions. رقم ساحرة The following inconsistency appears for the context menu in the document library “My Files”شيخة روحانية. Usually, with two custom actions there should be an expandable submenu. But this is missing only for some users and not for others,
(submenu missing)When using a Microsoft 365 file handler add-in (OneDrive File Handlers 2.0) with two custom actions. رقم ساحرة The following inconsistency appears for the context menu in the document library “My Files”شيخة روحانية. Usually, with two custom actions there should be an expandable submenu. But this is missing only for some users and not for others, Read More
Teams URL’s (coming from Onenote) give Application Error in browser
With Teams Version 24137.2216.2931.2440 we’ve expected an issue with URLs.
When i open a Onenote File inside Teams and try to open an URL i get this error
When i try to open directly from Onenote it works.
When i copy the URL and paste it to browser it works.
Only from Teams it seems to have Problems. Does anyone have this problem too??
With Teams Version 24137.2216.2931.2440 we’ve expected an issue with URLs. When i open a Onenote File inside Teams and try to open an URL i get this errorWhen i try to open directly from Onenote it works. When i copy the URL and paste it to browser it works. Only from Teams it seems to have Problems. Does anyone have this problem too?? Read More
Windows Insider HELP!!
How do I get this off my laptop!!! I can’t do anything, I open it up and get a green screen.
my laptop then tries to fix itself but can’t
How do I get this off my laptop!!! I can’t do anything, I open it up and get a green screen.my laptop then tries to fix itself but can’t Read More
Azure alert on multipel subscriptions
Hi all,
i am not sure if this is the rigt place, but here goes.
I am working on creating a monitoring solution, and are trying to create some dynamic alert rules.
I need them to look on a lot of subscriptions, but when use chose scope, you can only chose one subscription.
So i have exported the template and add’ed another subscription in the scopes section, but will it work?
This is what the properties section looks like in the template, it is looking on cpu usage over time:
Hi all, i am not sure if this is the rigt place, but here goes. I am working on creating a monitoring solution, and are trying to create some dynamic alert rules.I need them to look on a lot of subscriptions, but when use chose scope, you can only chose one subscription.So i have exported the template and add’ed another subscription in the scopes section, but will it work? This is what the properties section looks like in the template, it is looking on cpu usage over time:”properties”: { “description”: “Dynamic warning on CPU ussage”, “severity”: 2, “enabled”: true, “scopes”: [ “/subscriptions/Sub1”, “/subscriptions/Sub2” ], “evaluationFrequency”: “PT15M”, “windowSize”: “PT1H”, “criteria”: { “allOf”: [ { “alertSensitivity”: “High”, “failingPeriods”: { “numberOfEvaluationPeriods”: 4, “minFailingPeriodsToAlert”: 4 }, “name”: “Metric1”, “metricNamespace”: “microsoft.compute/virtualmachines”, “metricName”: “Percentage CPU”, “operator”: “GreaterOrLessThan”, “timeAggregation”: “Average”, “criterionType”: “DynamicThresholdCriterion” } ], “odata.type”: “Microsoft.Azure.Monitor.MultipleResourceMultipleMetricCriteria” }, Any input is more than welcome 🙂 RegardsJan L Dam Read More
Count how many people worked on a task – Dropdown menu
Hi there,
I’m trying to wrap my head around the dropdown menu function in Excel.
I’m using it this year to track which tasks were done on how many days.
F.e. the picture below are all dropdown cells.
Per day I add tasks per zone / category / detail / how many people worked on it.
After two months I want to know:
How many people worked on the food fronts: how many days / how many people?
I’ll add a filter on the column detail to search for the food fronts, but I want to be able to count the amount of people worked on it.
Does there exist a formula to count the amount of cells selected in one dropdown?
In this example the formula would say: 6 people worked on food fronts that day.
Many thanks!
Hi there, I’m trying to wrap my head around the dropdown menu function in Excel.I’m using it this year to track which tasks were done on how many days. F.e. the picture below are all dropdown cells. Per day I add tasks per zone / category / detail / how many people worked on it. After two months I want to know:How many people worked on the food fronts: how many days / how many people? I’ll add a filter on the column detail to search for the food fronts, but I want to be able to count the amount of people worked on it. Does there exist a formula to count the amount of cells selected in one dropdown? In this example the formula would say: 6 people worked on food fronts that day. Many thanks! Read More
Check-in/ check out when creating a new doc in a team site
Hello,
How to disable the check-in/ checkout when I create a document in a team site?
When I create a doc, even directly from “New+” on SharePoint, the Auto-save in on, so it’s saved in the SharePoint. But when I want to close it, it’s asking me to check-in and check-out my document.
It does the same with all the team site I’m in and not for the other members,
If I drag and drop the file from my OneDrive, it’s doesn’t ask.
Thank you
Hello, How to disable the check-in/ checkout when I create a document in a team site? When I create a doc, even directly from “New+” on SharePoint, the Auto-save in on, so it’s saved in the SharePoint. But when I want to close it, it’s asking me to check-in and check-out my document. It does the same with all the team site I’m in and not for the other members, If I drag and drop the file from my OneDrive, it’s doesn’t ask. Thank you Read More
access corporate data on an iPad without user affinity
Hello everyone,
Is it possible to access corporate data, such as a resource calendar (room), with an iPad that has been set up in Intune without user affinity? The tablet will be mounted on the wall outside our meeting rooms and display room availability. I’d like to avoid creating a generic user for this purpose.
What about licensing? A generic user would require both an Intune and an Exchange license. What licenses are needed for an iPad without a user for access?
Thank you very much for your help, and greetings from Germany
Nico
Hello everyone,Is it possible to access corporate data, such as a resource calendar (room), with an iPad that has been set up in Intune without user affinity? The tablet will be mounted on the wall outside our meeting rooms and display room availability. I’d like to avoid creating a generic user for this purpose. What about licensing? A generic user would require both an Intune and an Exchange license. What licenses are needed for an iPad without a user for access? Thank you very much for your help, and greetings from GermanyNico Read More
Custom Scripts policy breaks editing Custom Fields in PDPs (Project Online)
Hi!
Due to the recent policy applied by Microsoft about blocking the edition of Custom Scripts with the CEWP, we cannot edit Project Details Pages anymore to add/remove Enterprise Custom Fields in Project Online.
This should be working as Enterprise Custom Fields are not Custom Scripts!
Any advice?
Thanks in advance
Hi! Due to the recent policy applied by Microsoft about blocking the edition of Custom Scripts with the CEWP, we cannot edit Project Details Pages anymore to add/remove Enterprise Custom Fields in Project Online. This should be working as Enterprise Custom Fields are not Custom Scripts! Any advice? Thanks in advance Read More
Registration Microsoft Partner Problem
Hello Community,
I would like to register as a Microsoft partner with my Microsoft business ID. (Microsoft AI Cloud Partner Program) Unfortunately, I get the following error message:
{“code”:2100,”description”:”A legal entity matching the request payload already exists when creating the legal entity.”,”data”:[],”source”:”PartnerAccountEnrollmentApi”}
Does anyone have an idea?
Thanks and regards
Torsten
Hello Community,I would like to register as a Microsoft partner with my Microsoft business ID. (Microsoft AI Cloud Partner Program) Unfortunately, I get the following error message: {“code”:2100,”description”:”A legal entity matching the request payload already exists when creating the legal entity.”,”data”:[],”source”:”PartnerAccountEnrollmentApi”} Does anyone have an idea?Thanks and regardsTorsten Read More
Formatting footnote?
Hi there,
I have a real strange one, one of my users is getting the attached footnote when editing and formatting a document. Everything on her PC is in English, I can’t find any reference to the German language anywhere! ha ha ha
For the life of me I can’t replicate the message when I format any documentation, even in the same document.
I’m just trying to understand how it came about, as she is now paranoid that there is a language setting on her PC causing problems. I have asked her to test on another document, however haven’t heard back yet.
Can anyone give me guidance as to how this notation would have come about?
Thanks
Hi there, I have a real strange one, one of my users is getting the attached footnote when editing and formatting a document. Everything on her PC is in English, I can’t find any reference to the German language anywhere! ha ha ha For the life of me I can’t replicate the message when I format any documentation, even in the same document. I’m just trying to understand how it came about, as she is now paranoid that there is a language setting on her PC causing problems. I have asked her to test on another document, however haven’t heard back yet. Can anyone give me guidance as to how this notation would have come about? Thanks Read More
Microsoft AI Tour and Community Engagements in Seoul
The Microsoft AI Tour, a global event series aimed at enhancing AI skills for decision-makers and developers. The tour has been held in various locations around the world. Many attendees at these events had the opportunity to learn about the latest AI technologies, interact with Microsoft leaders and technical experts, and enjoy a unique opportunity to further utilize Microsoft AI technology in the future.
In this blog article, we present the vibrant event filled with diverse participants, along with a community gathering held the day before, featuring an executive speaker from Microsoft, Scott Hanselman (VP of Developer Community).
April 30, 2024 – Microsoft AI Tour Seoul
The Microsoft AI Tour Seoul, co-hosted with NVIDIA, was held to enhance Microsoft AI skills through technical sessions and interactions with experts, mainly targeting developers. Scott Hanselman kicked off the event with a greeting in Korean, delivering a keynote speech that energized the large crowd, who were eager to learn from him. Scott discussed essential AI knowledge for developers and how AI can contribute to organizational and career growth.
This Microsoft AI Tour Seoul saw the highest MVP participation among all previous AI Tour events held in various countries, 30 MVPs as staff members. They contributed as speakers in theater sessions, booth presenters, and workshop proctors. They helped expand the future possibilities by sharing their expertise and experiences as community leaders. One of attendees shared positive feedback, “I joined the Microsoft AI community through the AI Community Booth at the AI Tour Seoul. I’m eager to deepen my understanding of Microsoft AI and explore how to integrate AI technology into both my business and personal life.”
April 29, 2024 – Microsoft AI Tour Community Day
The day before the Microsoft AI Tour Seoul, the Microsoft AI Tour Community Day was held, a community event organized in collaboration with Microsoft Cloud Advocate Justin Yoo and Microsoft MVPs.
Four MVP speakers – JongIn Lee, Jung Hyun Nam, Jinseok Kim, and JinKwon Jeon – covered various AI-related topics, including the latest technologies in Azure, app development, and data analysis. Scott discussed useful tools for application development and engaged in a Q&A discussion with a diverse audience, from Microsoft Learn Student Ambassadors to professional developers.
April 29, 2024 – Korean AI MVPs x Startup Meetup
On the same day as the Microsoft AI Tour Community Day, another event was held by two Korean AI MVPs, YoungWook Kim and Mijeong Jeon, alongside Scott.
This event, hosted at the Seoul AI Hub, a center established by Seoul City to promote AI research, development, and industrialization, attracted many startup CEOs and CTOs. Participants learned about Microsoft AI technologies, the new language model Phi-3, and Microsoft’s startup support program, Founders Hub. They also explored business and personal growth opportunities through involvement in the AI community.
Microsoft AI Tour events have been held in various locations, with Microsoft MVPs and Regional Directors sharing their AI knowledge to support attendees’ learning. We extend our heartfelt gratitude to everyone who contributed to all the Microsoft AI Tour events and look forward to continuing to share innovative AI technologies with community members worldwide.
At the Microsoft Build held in May, numerous AI updates were announced. Besides the events, a variety of resources, including content and videos from Microsoft Learn such as the Copilot Learning Hub, are available to explore the latest Microsoft AI.
Whether you’re someone who has already embraced the latest technological advancements or someone new to AI, we encourage everyone to experience the potential of AI in their preferred way. Join the tech communities led by MVPs, learn deeply alongside other users, and together, let’s shape the future of AI!
Microsoft Tech Community – Latest Blogs –Read More