Tag Archives: microsoft
!^¿Como marcar a telefono United Colombia?^!
Para marcar atención al cliente de ^United Colombia llame aquí +57 601 580 4990 /+57 601 580 4990 – luego seleccione el idioma en lo que prefiere hablar con la gente de ^United Colombia^ los ejecutivos están abiertos para asistir los clientes de Delta.
Para marcar atención al cliente de ^United Colombia llame aquí +57 601 580 4990 /+57 601 580 4990 – luego seleccione el idioma en lo que prefiere hablar con la gente de ^United Colombia^ los ejecutivos están abiertos para asistir los clientes de Delta. Read More
O365 Exporting files with multiple periods in file name using DoCmd.Transfertext stopped working
We upgraded from access 2013 to office 365 few years ago. And have been using Transfertext to export files in txt, xls, xlsx formats until last week. Many of the exported files have multiple periods in the file names.
All of a sudden we are getting error message to remove multiple periods and exports are aborting.
Few users of the application are on Access 2013 and we don’t see any issue with 2013.
Is there a solution or fix for above issue?
Thanks in Advance
Shiva
We upgraded from access 2013 to office 365 few years ago. And have been using Transfertext to export files in txt, xls, xlsx formats until last week. Many of the exported files have multiple periods in the file names.All of a sudden we are getting error message to remove multiple periods and exports are aborting.Few users of the application are on Access 2013 and we don’t see any issue with 2013. Is there a solution or fix for above issue? Thanks in AdvanceShiva Read More
System and organization controls in XDR?
A recent Service Health post in the Office 365 Admin Center, regarding a problem with Defender XDR, says “This issue impacts tenant admins and users with system and organization controls (SOC) permissions.”
Is this a mistake? Do they mean “security operations center permissions” (i.e., Entra ID roles or RBAC roles) rather than “system and organization controls?” The former would make sense.
Looking for any clarity anyone can provide on this post.
Thanks in advance!
A recent Service Health post in the Office 365 Admin Center, regarding a problem with Defender XDR, says “This issue impacts tenant admins and users with system and organization controls (SOC) permissions.” Is this a mistake? Do they mean “security operations center permissions” (i.e., Entra ID roles or RBAC roles) rather than “system and organization controls?” The former would make sense. Looking for any clarity anyone can provide on this post. Thanks in advance! Read More
Applied Skills Question – Title Plan Duration vs. learn.microsoft.com
Hi TSPP Team,
we have several questions about the new Applied Skills offerings?
* There are discrepancies between course duration in titleplan and the content on learn.microsoft.com.
e.g.
– MS4008, Title Plan Duration 1Day – Link on learn.microsoft.com Duration 1hr39min
– MS4001, Title Plan 1 day – learn.microsoft.com 3h47min
– SC5006, TP: 1day – learn.microsoft.com 3hrs
I think thats not optimal for students when they attend a 1 day ILT course (in EMEA 7 work-hours) and then they see the content is only 1hr 39min.
Thanks for any tips for to sell this stuff for Learning Partners.
Mario
Hi TSPP Team, we have several questions about the new Applied Skills offerings? * There are discrepancies between course duration in titleplan and the content on learn.microsoft.com.e.g.- MS4008, Title Plan Duration 1Day – Link on learn.microsoft.com Duration 1hr39min- MS4001, Title Plan 1 day – learn.microsoft.com 3h47min- SC5006, TP: 1day – learn.microsoft.com 3hrs I think thats not optimal for students when they attend a 1 day ILT course (in EMEA 7 work-hours) and then they see the content is only 1hr 39min. Thanks for any tips for to sell this stuff for Learning Partners.Mario Read More
Need Help for Selling Applied Skills
Hi,
we appreaciate the new offerings for copilot, AI, and more. For our understanding it would be helpful to have a learning path available which course has which content and whats the audience for it.
There are more than 20 new applied skills for copilot and ai. Is our opinion there is much content overlapping, very short new content for 1 day courses, and basics in nearly every course (e.g. responsible AI, what is Copilot, What are LLMs)
e.g. Overlapping content in the MS4004 to 4008, 4012 courses.
Some are only the “legacy” course split up in 4 courses (e.g. AI3002, 3003, 3004) is the same content as AI102.
A big picture about the new applied skills would be helpful to understand and to sell.
What about a poster: “How to successfully learn, plan, apply the copilot solutions”
Overall our students find it very frustrating to have only Click-Thru-Simulations or Demonstration Only Courses.
We are waiting for many months now to get training licenses for Copilot Training. No one is willing to give us a working answer.
It is very difficult to decide which course to offer and which one to skip. You have to check:
* learn.microsoft.com
* PPT Slides (when LDC is down)
* Course Description & Format differences
* GIT-Hub MCT Pages are almost all empty without any content. (besided the template files azuredeploy.json)
Regards,
Mario
Hi, we appreaciate the new offerings for copilot, AI, and more. For our understanding it would be helpful to have a learning path available which course has which content and whats the audience for it. There are more than 20 new applied skills for copilot and ai. Is our opinion there is much content overlapping, very short new content for 1 day courses, and basics in nearly every course (e.g. responsible AI, what is Copilot, What are LLMs) e.g. Overlapping content in the MS4004 to 4008, 4012 courses. Some are only the “legacy” course split up in 4 courses (e.g. AI3002, 3003, 3004) is the same content as AI102. A big picture about the new applied skills would be helpful to understand and to sell.What about a poster: “How to successfully learn, plan, apply the copilot solutions” Overall our students find it very frustrating to have only Click-Thru-Simulations or Demonstration Only Courses. We are waiting for many months now to get training licenses for Copilot Training. No one is willing to give us a working answer. It is very difficult to decide which course to offer and which one to skip. You have to check: * learn.microsoft.com* PPT Slides (when LDC is down)* Course Description & Format differences* GIT-Hub MCT Pages are almost all empty without any content. (besided the template files azuredeploy.json) Regards,Mario Read More
Out-of-date- connecting on-premises exchange servers
Hi
I am getting issues with sending emails. Please find snapshots. I have done Pause Enforcement for 10 days. It is working fine now but I need permanent solutions.
HiI am getting issues with sending emails. Please find snapshots. I have done Pause Enforcement for 10 days. It is working fine now but I need permanent solutions. Read More
Formula for gannt-charts in projects
Hi everyone,
I am trying to make a gannt-chart for projects and I encounter the following problem.
In the picture you see at my company we have different types of projects (full, medium , light , full ctpd). Regarding this there are different types of hours involved every week, so we have made basic scheme for each type of project(see second picture). I would like that Excel returns these rows based on a) the type of project and b) that it starts returning this row from the date (week) the project starts. The conditional formatting between start date and end date is not difficult to format. Secondly return the rows is also not the problem however let the rows start from the start date is difficult.
Does someone has thoughts on this?
Hi everyone, I am trying to make a gannt-chart for projects and I encounter the following problem. In the picture you see at my company we have different types of projects (full, medium , light , full ctpd). Regarding this there are different types of hours involved every week, so we have made basic scheme for each type of project(see second picture). I would like that Excel returns these rows based on a) the type of project and b) that it starts returning this row from the date (week) the project starts. The conditional formatting between start date and end date is not difficult to format. Secondly return the rows is also not the problem however let the rows start from the start date is difficult. Does someone has thoughts on this? Read More
Issue with retention policy with adaptive scope
Dear community,
We created an adaptive scope and a retention policy about two weeks ago. If I check the scope details on the Purview portal, the adaptive scope shows 9602 users, but the policy shows only ~9150 users. I tried to investigate the issue, but I haven’t found an error message or a list of users missing from the policy. I must find a way to list out the users who are not covered by the policy.
What I have done in a nutshell is:
– Get-ComplianceRetentionPolicy does not see this policy. We have a few other policies with static scope, and they appear on the output, but the one we want to check is not.
– I collected all the mailboxes and checked the InPlaceHolds, but there is no such policy either. This is weird since we should have 9150 users covered by this policy.
– I checked a user who has this policy with the “Policy lookup” feature on the Purview portal, and it showed that the user is covered by the policy.
I googled, Copiloted, and ChatGPTd my question, but I still have no clue what to do.
The main question is: How can I query a list of users missing from a retention policy with adaptive scope?
Thank you for your help in advance!
Dear community,We created an adaptive scope and a retention policy about two weeks ago. If I check the scope details on the Purview portal, the adaptive scope shows 9602 users, but the policy shows only ~9150 users. I tried to investigate the issue, but I haven’t found an error message or a list of users missing from the policy. I must find a way to list out the users who are not covered by the policy.What I have done in a nutshell is: – Get-ComplianceRetentionPolicy does not see this policy. We have a few other policies with static scope, and they appear on the output, but the one we want to check is not.- I collected all the mailboxes and checked the InPlaceHolds, but there is no such policy either. This is weird since we should have 9150 users covered by this policy.- I checked a user who has this policy with the “Policy lookup” feature on the Purview portal, and it showed that the user is covered by the policy.I googled, Copiloted, and ChatGPTd my question, but I still have no clue what to do. The main question is: How can I query a list of users missing from a retention policy with adaptive scope? Thank you for your help in advance! Read More
Summing an inventory list
I am new to access, but I am creating a simple inventory database for work. So far, I have a list of machines and locations feeding a parts info list. Then I made a form to easily input new parts and update the table. Now, I want to show the total quantity for each part. The Key is different, but the part name is the same for some parts so I would like the parts grouped by the Key number. I’ve used the report wizard, but it just shows every transaction not a summary. In my most recent attempt, I got it more condensed, but every part is doubled and not updating.
I am new to access, but I am creating a simple inventory database for work. So far, I have a list of machines and locations feeding a parts info list. Then I made a form to easily input new parts and update the table. Now, I want to show the total quantity for each part. The Key is different, but the part name is the same for some parts so I would like the parts grouped by the Key number. I’ve used the report wizard, but it just shows every transaction not a summary. In my most recent attempt, I got it more condensed, but every part is doubled and not updating. Read More
MS Universal Print Windows Sockets Error | error=10053
Hello,
I am trying to share queue made in MyQ solution into Universal Print but unfortunately after doing so I receive following error MS Universal Print Windows Sockets Error | error=10053, there is so sign of queue in Azure side and in MyQ status of queue is “Printer is being created in Azure”. Outbound connection to all necessary endpoints is allowed. Tls 1.2 is on. Any ideas what could be wrong?
Hello,I am trying to share queue made in MyQ solution into Universal Print but unfortunately after doing so I receive following error MS Universal Print Windows Sockets Error | error=10053, there is so sign of queue in Azure side and in MyQ status of queue is “Printer is being created in Azure”. Outbound connection to all necessary endpoints is allowed. Tls 1.2 is on. Any ideas what could be wrong? Read More
Issue with coauthoring in pages – The file (SharePoint Page) is locked for shared use by “User”
We have a custom SPFx web part added to our SharePoint pages. When users enter the required information and click on ‘Save as draft’ or ‘Submit for approval’ (with Power Automate enabled for the approval process), the information should save to the respective columns (page properties) in Site Pages, using REST API for data storage. Until yesterday, it worked fine, but since the rollout of coauthoring on site pages, we are encountering an error: “The file (SharePoint Page) is locked for shared use by ‘User’,” even though the user encountering the error is the one who edited the page.
We have a custom SPFx web part added to our SharePoint pages. When users enter the required information and click on ‘Save as draft’ or ‘Submit for approval’ (with Power Automate enabled for the approval process), the information should save to the respective columns (page properties) in Site Pages, using REST API for data storage. Until yesterday, it worked fine, but since the rollout of coauthoring on site pages, we are encountering an error: “The file (SharePoint Page) is locked for shared use by ‘User’,” even though the user encountering the error is the one who edited the page. Read More
Sharepoint list Status column
I have a sharepoint list with a status column. It has “not Started”, ” In Work”, “In Transit”, and “Complete”. I need a way to lock them in order so a step is not skipped. Any ideas on how I can do this?
I have a sharepoint list with a status column. It has “not Started”, ” In Work”, “In Transit”, and “Complete”. I need a way to lock them in order so a step is not skipped. Any ideas on how I can do this? Read More
Prompt to help me to find available slots for a meeting
Hello,
I try this prompt
Please identify two available time slots before the end of August 2024 for a 1-hour meeting with X and Y.
The slots should align with their working hours, respective time zones, and avoid any scheduling
conflicts.
However, the outcomes are not always consistent, and I typically have two types of responses:
-I have two time slots as options, but not everyone is available, or the time zone check was not considered.
Based on the available information, I have identified two potential time slots for a 1-hour meeting with X and Y before the end of August 2024:
* Thursday, August 10th at 9:00 AM CEST (X’s local time), which corresponds to Thursday,
August 10th at 3:00 AM EDT (Y’s local time)
* Tuesday, August 22nd at 4:00 PM CEST (X’s local time), which corresponds to Tuesday,
August 22nd at 10:00 AM EDT (Y’s local time).
– I received this
I’m sorry, but I couldn’t find specific availability information for X and Y before the end of August 2024.
To identify two available time slots for a 1-hour meeting, I recommend using the scheduling feature within Microsoft 365
to view their calendars and find slots that align with your working hours and time zones. If you need assistance with
scheduling or using the features, please let me know how I can help further.
Could you suggest a rewording of the Prompt or help me understand the answers?
Thanks
Matthieu
Hello, I try this prompt Please identify two available time slots before the end of August 2024 for a 1-hour meeting with X and Y. The slots should align with their working hours, respective time zones, and avoid any scheduling conflicts.However, the outcomes are not always consistent, and I typically have two types of responses:-I have two time slots as options, but not everyone is available, or the time zone check was not considered.Based on the available information, I have identified two potential time slots for a 1-hour meeting with X and Y before the end of August 2024:* Thursday, August 10th at 9:00 AM CEST (X’s local time), which corresponds to Thursday, August 10th at 3:00 AM EDT (Y’s local time)* Tuesday, August 22nd at 4:00 PM CEST (X’s local time), which corresponds to Tuesday, August 22nd at 10:00 AM EDT (Y’s local time).- I received this I’m sorry, but I couldn’t find specific availability information for X and Y before the end of August 2024. To identify two available time slots for a 1-hour meeting, I recommend using the scheduling feature within Microsoft 365 to view their calendars and find slots that align with your working hours and time zones. If you need assistance with scheduling or using the features, please let me know how I can help further.Could you suggest a rewording of the Prompt or help me understand the answers?Thanks Matthieu Read More
Combine two queries
I need to combine these two queries to receive one result:
Here is the first query
with cte as (
select ID,
assessmentdate,
Jurisdiction,
name,
studentid,
submitdate,
count(*) over (partition by studentid) as dup_count
from tblTest
)
Select m.assessmenttype, Count(m.studentid) As referredforassessment
From tblProfile m
Inner Join cte s on
m.studentid = s.studentid
Where dup_count > 1
and s.SubmitDate between ’06/01/2024′ and ’06/30/2024′
and countyid = 6
Group by assessmenttype
Order by assessmenttype
Here are the results from this query:
assessmenttype
referredforassessment
2
3
3
1
7
1
Here is the second query:
select assessmenttype,
SUM(CASE WHEN referredforassessment = 1 THEN 1 ELSE 0 END) as referredforassessment
from tblProfile
where SUBMITDATE >= ’06/01/2024′ and SUBMITDATE < ’06/30/2024′ and countyid = 6
Group By assessmenttype
order by assessmenttype
Here are the results from the second query:
assessmenttype
referredforassessment
2
2
4
1
Here are my desired results:
assessmenttype
referredforassessment
2
5
3
1
4
1
7
1
I need to combine these two queries to receive one result: Here is the first query with cte as (
select ID,
assessmentdate,
Jurisdiction,
name,
studentid,
submitdate,
count(*) over (partition by studentid) as dup_count
from tblTest
)
Select m.assessmenttype, Count(m.studentid) As referredforassessment
From tblProfile m
Inner Join cte s on
m.studentid = s.studentid
Where dup_count > 1
and s.SubmitDate between ’06/01/2024′ and ’06/30/2024′
and countyid = 6
Group by assessmenttype
Order by assessmenttype Here are the results from this query:assessmenttypereferredforassessment233171 Here is the second query:select assessmenttype,
SUM(CASE WHEN referredforassessment = 1 THEN 1 ELSE 0 END) as referredforassessment
from tblProfile
where SUBMITDATE >= ’06/01/2024′ and SUBMITDATE < ’06/30/2024′ and countyid = 6
Group By assessmenttype
order by assessmenttype Here are the results from the second query: assessmenttypereferredforassessment2241 Here are my desired results: assessmenttypereferredforassessment25314171 Read More
Getting the Most Filled Out Cells to the Top – Sort and Filter
I am new to Excel and learning how everything works, but I need to figure out how to get the rows with the most filled-in cells to the top of my sheet.
For more information – we keep track of our inventory in an excel document. I assign order numbers and customer names to the correct product as we get orders. Once the item has shipped I add the ship date to one of the columns and then have to move the whole row to a different sheet. I just need to figure out how to get the rows that have shipped to the top of the sheet each day so I can move them all at once to the new sheet.
I am new to Excel and learning how everything works, but I need to figure out how to get the rows with the most filled-in cells to the top of my sheet. For more information – we keep track of our inventory in an excel document. I assign order numbers and customer names to the correct product as we get orders. Once the item has shipped I add the ship date to one of the columns and then have to move the whole row to a different sheet. I just need to figure out how to get the rows that have shipped to the top of the sheet each day so I can move them all at once to the new sheet. Read More
FabSoft, Just Software, and Volo offer transactable partner solutions in Azure Marketplace
Microsoft partners like FabSoft, Just Software, and Volo deliver transact-capable offers, which allow you to purchase directly from Azure Marketplace. Learn about these offers below:
DeskConnect: Deliver Documents to Azure OpenAI: Automatically capture and redistribute all transactional documents involving user-level interaction and input with DeskConnect so you can eliminate costly disruptions from customers, vendors, and staff. This powerful solution from FabSoft transforms a tedious manual process into an automated knowledge base.
EasyScep: One-click PKI for Intune Endpoint Certificates: If you need a streamlined, cost-effective public key infrastructure (PKI) solution for Microsoft Intune, EasyScep from Just Software is a hassle-free way to manage WiFi and VPN certificates. Its simple configuration process and straightforward pricing let you easily improve your security without complicating your infrastructure or adding daily management tasks. EasyScep supports all devices managed by Intune, including Windows, iOS, and Android.
Volo SaaS: Cloud Foundations (Landing Zone and Shared Services): Volo automates the setup and maintenance of well-configured, up-to-date cloud landing zones and shared services without the need to hire outside experts. Reduce cloud management costs by up to 70 percent while ensuring compliance and remaining in full control of your environment.
Microsoft Tech Community – Latest Blogs –Read More
Nuget Package problem while creating a .Net MAUI application
Everytime I try to create a .net maui app, I get this error (NU1008) i am unable to fix it. can anyone help me….
Error (active) NU1008 :Projects that use central package version management should not define the version on the PackageReference items but on the PackageVersion items: Microsoft.Maui.Controls;Microsoft.Maui.Controls.Compatibility;Microsoft.Extensions.Logging.Debug.
Everytime I try to create a .net maui app, I get this error (NU1008) i am unable to fix it. can anyone help me….Error (active) NU1008 :Projects that use central package version management should not define the version on the PackageReference items but on the PackageVersion items: Microsoft.Maui.Controls;Microsoft.Maui.Controls.Compatibility;Microsoft.Extensions.Logging.Debug. Read More
Calculating COGS through FIFO method
I am trying to create an excel sheet for a small business. I have calculated and linked most of it however in order to accurately calculate the cost of goods sold, I have to use a method called FIFO method (First in first out). For example if I purchase 300 units of item A at 300,000 and 500 units of items A at a later date for 450,000, so when I sell 350 units, it is basically 300 units @ 300,000/300 and remining 50 units @ 450,000/500. Now there are multiple issues doing this in excel.
1. before anything I have to match the product code (column D)
2. I have to see that the cost of goods sold (column K) first calculates cost based on the oldest purchase and after that if needed the next purchase and so on.
3. I have to make sure that the next time I make sale, it also accounts for the previous sale as the oldest purchase might already be accounted for in a previous sale.
I looked for an attachment button but couldn’t find one so here is my sheet
S.no at column B, Purchase Date at column C, ARTICLE CODE at column D, Purchase units at column E, Purchase price at column F, Transport Expense at column G, Cost of Goods Purchased at column H, Sale Date at column I, Units Sold at column J, Cost of Goods Sold at column K.
Reading it back I realized that I have not written this in the simplest terms. Let’s hope you guys understand.
I am trying to create an excel sheet for a small business. I have calculated and linked most of it however in order to accurately calculate the cost of goods sold, I have to use a method called FIFO method (First in first out). For example if I purchase 300 units of item A at 300,000 and 500 units of items A at a later date for 450,000, so when I sell 350 units, it is basically 300 units @ 300,000/300 and remining 50 units @ 450,000/500. Now there are multiple issues doing this in excel.1. before anything I have to match the product code (column D)2. I have to see that the cost of goods sold (column K) first calculates cost based on the oldest purchase and after that if needed the next purchase and so on.3. I have to make sure that the next time I make sale, it also accounts for the previous sale as the oldest purchase might already be accounted for in a previous sale. I looked for an attachment button but couldn’t find one so here is my sheetS.no at column B, Purchase Date at column C, ARTICLE CODE at column D, Purchase units at column E, Purchase price at column F, Transport Expense at column G, Cost of Goods Purchased at column H, Sale Date at column I, Units Sold at column J, Cost of Goods Sold at column K. Reading it back I realized that I have not written this in the simplest terms. Let’s hope you guys understand. Read More
Access to subscription resources.
Hello,
I want to ask you all about subscription access for users outside.
The idea is to split our Azure subscription from one global to one per coutry. We are going to do some stuff there but we might need to give access to resources for employes from other countries to ex. show them what we did, how it works and let them play with it.
Example:
Right now we are doing some R&D on global account but it will be much better to have our own for each country. In future, we might need to share access to that environment/product etc. to other employes outside our subscription.
Why?
We want to have some kind of indicator which will tell us how many hours/connections was done and all that stuff.
Why not resource group?
It will be much easier to just give access to “our” own Azure env rather than specifying roles, telling what to edit and what not etc. We have some production stuff there etc…
So, is it possible to give access to these resources for employes from other subscriptions with “full” functionality of resources inside? Can connections to VM’s or Kube clusters will be possible?
Thank you!
Hello,I want to ask you all about subscription access for users outside. The idea is to split our Azure subscription from one global to one per coutry. We are going to do some stuff there but we might need to give access to resources for employes from other countries to ex. show them what we did, how it works and let them play with it. Example:Right now we are doing some R&D on global account but it will be much better to have our own for each country. In future, we might need to share access to that environment/product etc. to other employes outside our subscription. Why?We want to have some kind of indicator which will tell us how many hours/connections was done and all that stuff. Why not resource group?It will be much easier to just give access to “our” own Azure env rather than specifying roles, telling what to edit and what not etc. We have some production stuff there etc… So, is it possible to give access to these resources for employes from other subscriptions with “full” functionality of resources inside? Can connections to VM’s or Kube clusters will be possible? Thank you! Read More
Channel connectors not loading
Hello there,
we are using a connector to get a notification about new Azure DevOps Pull Requests to a Microsoft Teams channel. Since these connectors are deprecating soon, we wrote an PowerAutomate flow to replace the old one.
We now finished the new flow and want to remove the old connector. But unfortunately the list of configured connectors for the channel is not loading – no matter if I try to access it in the installed app or in different browsers on different operating systems. The lists for adding new connectors work, but “Configured” and “My Accounts” does not.
I already cleared the cache of Teams, I also installed new browsers (on MacOS and on Windows systems), but the list is always empty.
Does someone have any tips how to remove the old connector?
Hello there, we are using a connector to get a notification about new Azure DevOps Pull Requests to a Microsoft Teams channel. Since these connectors are deprecating soon, we wrote an PowerAutomate flow to replace the old one. We now finished the new flow and want to remove the old connector. But unfortunately the list of configured connectors for the channel is not loading – no matter if I try to access it in the installed app or in different browsers on different operating systems. The lists for adding new connectors work, but “Configured” and “My Accounts” does not. I already cleared the cache of Teams, I also installed new browsers (on MacOS and on Windows systems), but the list is always empty. Does someone have any tips how to remove the old connector? Read More
