Month: October 2024
How to make account or laptop inaccessible at certain times?
I want to make an account not be able to be accessed at certain times of the day, how can I do this?
I want to make an account not be able to be accessed at certain times of the day, how can I do this? Read More
I would like to change the pause between sentences from 2 seconds to 4 seconds (word).
Hello, I have my document read aloud in Word. I would like to change the pause between sentences from 2 seconds to 4 seconds. Does anyone know if this is possible? Thanks in advance
Hello, I have my document read aloud in Word. I would like to change the pause between sentences from 2 seconds to 4 seconds. Does anyone know if this is possible? Thanks in advance Read More
Android Work Profile enrollment fail
Hi all,
I’ve noticed today that Android devices are not completing the enrollment process with error:
Unable to create work profile
We are unable to set up your work profile.
This was tested under 3 tenants (one of them was the Contoso tenant). No restrictions, profiles, and policies are assigned to these devices.
All the Androids are under OS 14. Tested on 5G and WiFi.
Hi all,I’ve noticed today that Android devices are not completing the enrollment process with error: Unable to create work profileWe are unable to set up your work profile. This was tested under 3 tenants (one of them was the Contoso tenant). No restrictions, profiles, and policies are assigned to these devices. All the Androids are under OS 14. Tested on 5G and WiFi. Read More
Send Bamboo HR PayStub in PDF to the related employee by email at the end of each month
We have purchased Bamboo HR system for our company. And Bamboo HR allows us to generate a PDF for the PayStub for each employee at the end of each month. Now we want to send this PayStub PDF to the employee by email. Seems Bamboo HR does not provide such as a capability out of the box. and at the same time our company have an Office 365 tenant. So we create a Power Automate scheduled flow (which run each month for example), to integrate with Bamboo HR API >> get the Pay-stub PDF and send it to the employee. But when I checked the Bamboo HR documentation, seems the API does not provide such as feature to get the Pay-stub PDF https://documentation.bamboohr.com/reference/get-employee .
So, can anyone advice if this is possible to send the Pay-stub to the employee by email using Power Automate which integrate with Bamboo HR APIs? or using built-in connectors?
Thanks
We have purchased Bamboo HR system for our company. And Bamboo HR allows us to generate a PDF for the PayStub for each employee at the end of each month. Now we want to send this PayStub PDF to the employee by email. Seems Bamboo HR does not provide such as a capability out of the box. and at the same time our company have an Office 365 tenant. So we create a Power Automate scheduled flow (which run each month for example), to integrate with Bamboo HR API >> get the Pay-stub PDF and send it to the employee. But when I checked the Bamboo HR documentation, seems the API does not provide such as feature to get the Pay-stub PDF https://documentation.bamboohr.com/reference/get-employee . So, can anyone advice if this is possible to send the Pay-stub to the employee by email using Power Automate which integrate with Bamboo HR APIs? or using built-in connectors? Thanks Read More
Minium License for Intune MDM
What is the minimum license needed for Intune mobile device management(i.e. we want to manage or Android and Apple phones)
thanks
What is the minimum license needed for Intune mobile device management(i.e. we want to manage or Android and Apple phones) thanks Read More
Il mio sito non viene più indicizzato come ma?
Ho problemi con questo sito mi risolvete il problema? Http://www.informabyte.it
Ho problemi con questo sito mi risolvete il problema? Http://www.informabyte.it Read More
Bridge to the Cloud 2 Promo–will it apply on an upgrade?
Good day,
We have a customer who has licenses under the Bridge to the Cloud 2 Promo. They recently purchased 8 Commerce Attach licenses with the promo applied to them as well. They would now like to upgrade those 8 Commerce Attach licenses to 20 full Commerce licenses so they can have the free CSU. When I do the upgrade in Partner Center, will the 40% promo apply to the 20 full Commerce licenses?
Thank you.
Good day, We have a customer who has licenses under the Bridge to the Cloud 2 Promo. They recently purchased 8 Commerce Attach licenses with the promo applied to them as well. They would now like to upgrade those 8 Commerce Attach licenses to 20 full Commerce licenses so they can have the free CSU. When I do the upgrade in Partner Center, will the 40% promo apply to the 20 full Commerce licenses? Thank you. Read More
Disable (X) Button and Force Users to Close Workbook through Userform
Hi….I found code that prevents users from closing a workbook using the X button however when they attempt to close the workbook the correct way (through a userform) it does not close. This is the code I found to prevent using the X button:
Private Sub Workbook_BeforeClose(Cancel As Boolean)
Cancel = True
MsgBox “You must use the EXIT ARMS button to close ARMS at all times.”
End Sub
This is the userform code I have:
Dim AnswerYes As String
ActiveWorkbook.Unprotect “unlockme13”
Sheets(“HOME PAGE”).Unprotect Password:=”unlockme”
AnswerYes = MsgBox(“Do you want to save & close ARMS?”, vbQuestion + vbYesNo, “User Repsonse”)
If AnswerYes = vbYes Then
Unload Me
For Each ws In ActiveWorkbook.Worksheets
ws.Visible = xlSheetVisible
Next ws
Sheets(“UserAccess”).Visible = False
Sheets(“MAX VALUES”).Visible = False
Sheets(“TIER ACCESS”).Visible = False
Sheets(“LISTS”).Visible = False
Sheets(“CLIENTS”).Visible = False
Range(“M1”).Value = “”
Range(“M3”).Value = “”
Range(“M6”).Value = “”
Sheets(“HOME PAGE”).Protect Password:=”unlockme”
ActiveWorkbook.Protect “unlockme13”
ThisWorkbook.Save
Application.Quit
Else
ThisWorkbook.Close SaveChanges:=False
Application.Quit
End If
Not sure why this is happening so any assistance would be appreciated.
Thanks!
Hi….I found code that prevents users from closing a workbook using the X button however when they attempt to close the workbook the correct way (through a userform) it does not close. This is the code I found to prevent using the X button: Private Sub Workbook_BeforeClose(Cancel As Boolean)
Cancel = True
MsgBox “You must use the EXIT ARMS button to close ARMS at all times.”
End Sub This is the userform code I have:Dim AnswerYes As String
ActiveWorkbook.Unprotect “unlockme13”
Sheets(“HOME PAGE”).Unprotect Password:=”unlockme”
AnswerYes = MsgBox(“Do you want to save & close ARMS?”, vbQuestion + vbYesNo, “User Repsonse”)
If AnswerYes = vbYes Then
Unload Me
For Each ws In ActiveWorkbook.Worksheets
ws.Visible = xlSheetVisible
Next ws
Sheets(“UserAccess”).Visible = False
Sheets(“MAX VALUES”).Visible = False
Sheets(“TIER ACCESS”).Visible = False
Sheets(“LISTS”).Visible = False
Sheets(“CLIENTS”).Visible = False
Range(“M1”).Value = “”
Range(“M3”).Value = “”
Range(“M6”).Value = “”
Sheets(“HOME PAGE”).Protect Password:=”unlockme”
ActiveWorkbook.Protect “unlockme13”
ThisWorkbook.Save
Application.Quit
Else
ThisWorkbook.Close SaveChanges:=False
Application.Quit
End If Not sure why this is happening so any assistance would be appreciated. Thanks! Read More
Multiple accounts on one device managed by different companies
I have employees who work for multiple companies and have Microsoft 365 and Intune at each of their companies. They add their work accounts to their personal devices to access Outlook and Teams.
When applying App Protection Policies, will the applications have policies relevant to the organization that owns the data have that organization’s policies applied to the data? What happens if two work accounts have App Protection Policies applied? Will one take precedence over the other?
Searching around seems to indicate this was impossible before Outlook allowed more than one work account. I cannot find an answer where multiple work accounts are now permissible in Outlook and in Teams.
Thanks in advance.
I have employees who work for multiple companies and have Microsoft 365 and Intune at each of their companies. They add their work accounts to their personal devices to access Outlook and Teams. When applying App Protection Policies, will the applications have policies relevant to the organization that owns the data have that organization’s policies applied to the data? What happens if two work accounts have App Protection Policies applied? Will one take precedence over the other? Searching around seems to indicate this was impossible before Outlook allowed more than one work account. I cannot find an answer where multiple work accounts are now permissible in Outlook and in Teams. Thanks in advance. Read More
Simplifying Securing SAP-Power Platform Connectivity with SAP OData Connector and Single Sign-on
In previous blogs on streamlining SAP processes with Azure OpenAI, Copilot Studio, and the Power Platform and then enhancing the scenarios using Principal Propagation and Adaptive cards we explored how these tools can transform business workflows. Since then, there has been an exciting new change in the SAP Power Platform connector space that simplifies and cuts down on many of the steps it takes to implementing Principal Propagation. The SAP OData connector now supports Single Sign-On (SSO) support on the Power Platform. After taking into account the feedback and requirements from customers, the SSO capability of the connector proved to be the most in-demand feature during our previews. This enhancement not only simplifies the login process but also brings a host of benefits to SAP users.
Simplified Access with Single Sign-On
The OData connector now allows users to log in using their Microsoft Identities, streamlining the authentication process. This means that users no longer need to remember multiple credentials for different systems. With SSO, once you are logged into your Microsoft account, you can access SAP data through the Power Platform or through your bot deployed on Copilot Studio without additional logins. This integration enhances security and user experience by reducing the friction associated with multiple logins.
Benefits of the OData Connector
Enhanced Security: SSO ensures that user credentials are managed centrally, reducing the risk of password-related security breaches and complications. The SAP authorizations for the Microsoft user are preserved, ensuring compliance is maintained.
Improved Productivity: With easier access to SAP data, users can focus more on their tasks rather than dealing with login issues while using Copilot Studio bots or Power Automate flows.
To demonstrate how easy it is to use and what goes on behind the scenes, let’s see how the Copilot Studio scenarios shown in the previous blogs work by replacing the ERP connector with the OData connector in Power Automate. The new architecture looks like the image below, with the addition of the Single -Sign on through the OData connector.
To implement the Single -Sign on using Microsoft Entra ID, you can follow the comprehensive guides here on the Power Platform Community post as well as the Microsoft Learn article.
After you set that up, all you need to do is add in the OData connector into the Power Platform flow and choose Entra ID as the sign-on method (as shown in the example below) and create the connection.
To access the Power Automate flows and the instructions on how to recreate the scenario in the previous blogs using the new OData connector, you can visit the GitHub repository here.
These guides will help you seamlessly integrate SSO OData Connector into your workflows, ensuring a smooth and secure user experience.
Final Thoughts
In conclusion, by simplifying the authentication process and centralizing user credentials, The OData Connector with Single Sign-On (SSO) not only improves security but also boosts productivity by reducing login-related friction. The seamless access to SAP data through Microsoft identities ensures a smooth and secure user experience, enabling users to focus on their tasks without the hassle of multiple logins. This advancement marks a significant step forward in streamlining SAP processes and enhancing overall efficiency.
Microsoft Tech Community – Latest Blogs –Read More
Change cell colors when deadline is or is not met?
I track our magazines’ copy flow. Columns D and E are tied to each individual magazine’s tab. Every article for the month is listed on its individual magazine’s tab. As those files arrive, we put a link in a separate column. That automatically updates the “Pub Info” page’s Columns D and E, and the % filed to copy also is automatic.
Right now we have to individually go into each magazine’s 50% and 100% deadline cells on the Pub Info page and make them red or green, depending on whether they met those % by deadline.
Is there a way to have Columns G and H automatically turn each cell red or green on their due dates, depending on whether they made their 50% or 100% deadline (based on Column F)?
Thanks in advance!
I track our magazines’ copy flow. Columns D and E are tied to each individual magazine’s tab. Every article for the month is listed on its individual magazine’s tab. As those files arrive, we put a link in a separate column. That automatically updates the “Pub Info” page’s Columns D and E, and the % filed to copy also is automatic. Right now we have to individually go into each magazine’s 50% and 100% deadline cells on the Pub Info page and make them red or green, depending on whether they met those % by deadline. Is there a way to have Columns G and H automatically turn each cell red or green on their due dates, depending on whether they made their 50% or 100% deadline (based on Column F)? Thanks in advance! Read More
Figure Reference different font color from body of text
Whenever I insert a reference for a figure in my document, it is a gray font color. The style it’s set to is normal body text, which is black like the text around it. I’ve tried searching through font styles to see if there’s a reference or hyperlink that looks like it, and there is not. Any tips on how to specifically change the format for an in text reference?
Whenever I insert a reference for a figure in my document, it is a gray font color. The style it’s set to is normal body text, which is black like the text around it. I’ve tried searching through font styles to see if there’s a reference or hyperlink that looks like it, and there is not. Any tips on how to specifically change the format for an in text reference? Read More
Combine a list column with a lookup column
I have two SharePoint online lists that are connected with a lookup.
Client list – specific information on a client for an event; Client name, address, etc.
Event List – This has fields for the events that occur, and also LOOKUP fields, displaying the Client name, address and such in various lookup fields. They display just fine in the Event list, so that much is working.
I actually wanted to display content from the source list (Client) in a field on the destination list (Event, the list that has the lookup columns), and concatenate them so they are a single field. Then it will go into a PowerApps app as a single field, to lookup list items from these several source fields (Event name, Client Name, etc). I can display the lookup data in a PowerApps field in the Canvas app, but since it is only displayed and not actually in the field, PowerApps will not let me look up data in that lookup part of the field. (BTW, if you have a solution for that, I’d like to hear about it.)
So now I’m trying to combine the fields on the SharePoint side, and then display that combined field in PowerApps. In SharePoint, I have a calculated column with a formula that grabs the event data in that list (Event), but in the “Insert column” box, it does not display any of the lookup fields in the Events list the fields that are looking up data from the Client list. So I’m stuck on this side too. Is there a way in SharePoint to combine list fields in one table and also include list fields from a related table?
In another application–like Power BI–I would probably use something like the RELATED() or RELATEDTABLE() function, but I don’t know of anything like that in SharePoint.
I have two SharePoint online lists that are connected with a lookup. Client list – specific information on a client for an event; Client name, address, etc.Event List – This has fields for the events that occur, and also LOOKUP fields, displaying the Client name, address and such in various lookup fields. They display just fine in the Event list, so that much is working.I actually wanted to display content from the source list (Client) in a field on the destination list (Event, the list that has the lookup columns), and concatenate them so they are a single field. Then it will go into a PowerApps app as a single field, to lookup list items from these several source fields (Event name, Client Name, etc). I can display the lookup data in a PowerApps field in the Canvas app, but since it is only displayed and not actually in the field, PowerApps will not let me look up data in that lookup part of the field. (BTW, if you have a solution for that, I’d like to hear about it.)So now I’m trying to combine the fields on the SharePoint side, and then display that combined field in PowerApps. In SharePoint, I have a calculated column with a formula that grabs the event data in that list (Event), but in the “Insert column” box, it does not display any of the lookup fields in the Events list the fields that are looking up data from the Client list. So I’m stuck on this side too. Is there a way in SharePoint to combine list fields in one table and also include list fields from a related table?In another application–like Power BI–I would probably use something like the RELATED() or RELATEDTABLE() function, but I don’t know of anything like that in SharePoint. Read More
JSON Code not working when calculating Days Since Received
I am hoping to use a Microsoft List to manage a team’s files.
I originally used the following code in my “Days Since Received” column, however, I later learned that this formula would not automatically (dynamically?) update after noticing that the days within the column never changed after being entered:
=TODAY()-[Received (date)]
To rectify this, I found a suggestion on the internet to use a JSON code to try and make it so the MS List automatically updates each day on its own. Unfortunately I am receiving the following error in the Days Since Received column:
=floor((Number(@now)-Number([$Received_x0020_(date)]))/(1000*60*60*24*12)/365*12)
The JSON I am using is as follows:
{
“$schema”: “https://developer.microsoft.com/json-schemas/sp/v2/column-formatting.schema.json”,
“elmType”: “div”,
“txtContent”: “=floor((Number(@now)-Number([$Received_x0020_(date)]))/(1000*60*60*24*12)/365*12)”
}
I am unsure what’s going wrong. This is how I’ve set it up:
I am hoping to use a Microsoft List to manage a team’s files. I originally used the following code in my “Days Since Received” column, however, I later learned that this formula would not automatically (dynamically?) update after noticing that the days within the column never changed after being entered: =TODAY()-[Received (date)] To rectify this, I found a suggestion on the internet to use a JSON code to try and make it so the MS List automatically updates each day on its own. Unfortunately I am receiving the following error in the Days Since Received column:=floor((Number(@now)-Number([$Received_x0020_(date)]))/(1000*60*60*24*12)/365*12) The JSON I am using is as follows:{
“$schema”: “https://developer.microsoft.com/json-schemas/sp/v2/column-formatting.schema.json”,
“elmType”: “div”,
“txtContent”: “=floor((Number(@now)-Number([$Received_x0020_(date)]))/(1000*60*60*24*12)/365*12)”
} I am unsure what’s going wrong. This is how I’ve set it up: Read More
Help with If/And function
Trying to calculate the age of a closed item and getting errors with the below formula. The objective is to calculate how long it took for an item to close (filtering on Closed items only). Thanks
=IF(AND(I68=”Closed”),M68<>””,M68-Q68,TODAY()-Q68)
Trying to calculate the age of a closed item and getting errors with the below formula. The objective is to calculate how long it took for an item to close (filtering on Closed items only). Thanks =IF(AND(I68=”Closed”),M68<>””,M68-Q68,TODAY()-Q68) Read More
Compatibility checker didn’t identify VSTACK as an issue for Excel 2021
I have a pretty complex spreadsheet which I developed using my Office 365 subscription. In it I used some pretty new functions including VSTACK. I needed to share the spreadsheet with someone who has the Office 2021 home and student installed, but it didn’t work for them. After a lot of digging around I found that the problem was a VSTACK function I had used. I wanted to find out if I had other instances of VSTACK and possibly other unsupported functions, so I ran the Excel compatibility checker with only the 2021 and 2023 versions selected. It failed to identify any issues even though I was already aware that I had at least one function that the 2021 version doesn’t support. It looks like I’ll have to use trial and error to find any other similar issues.
I have a pretty complex spreadsheet which I developed using my Office 365 subscription. In it I used some pretty new functions including VSTACK. I needed to share the spreadsheet with someone who has the Office 2021 home and student installed, but it didn’t work for them. After a lot of digging around I found that the problem was a VSTACK function I had used. I wanted to find out if I had other instances of VSTACK and possibly other unsupported functions, so I ran the Excel compatibility checker with only the 2021 and 2023 versions selected. It failed to identify any issues even though I was already aware that I had at least one function that the 2021 version doesn’t support. It looks like I’ll have to use trial and error to find any other similar issues. Read More
Copilot error
For the first time I am experiencing the following error: “I’m having trouble answering your question right now. Try again later.” My data is in a valid structure and Copilot detects my data range. What is the reason for this error?
For the first time I am experiencing the following error: “I’m having trouble answering your question right now. Try again later.” My data is in a valid structure and Copilot detects my data range. What is the reason for this error? Read More
Partner Case Study Series | WeWALK
“Worldwide, there are about 250 million people with visual impairments, 50 million of whom use a traditional white cane to help them get around. This is an amazing tool, don’t get me wrong, but it hasn’t really changed in nearly 100 years. Everything else has changed dramatically with technology, so we asked ourselves: why not the white cane?”
This is Jean Marc Feghali, Head of R&D at London-based start-up WeWALK. WeWALK is a company dedicated to bringing modern technology to the traditional long white cane, one of the most essential and prevalent tools used by people with visual impairments. “The long white cane is essential for many people with visual impairments, myself included, but we saw an opportunity to enhance it with technology. By adding voice control, Bluetooth, a touchpad, ultrasonic sensors, vibration, AI, and more, we’ve built a smart cane that can improve the safety of users and help them overcome key barriers to mobility, ultimately contributing to a more equitable and accessible world.”
The WeWALK smart cane
The WeWALK team, some of whom have visual impairments themselves, eat, sleep, and breathe assistive and adaptive technology. The team deeply understands the challenges facing people with visual impairments such as detecting low-hanging objects and holding a cane in one hand and bouncing between apps on a phone with the other. This experience can be exhausting, frustrating, and dangerous for users.
The WeWALK story began when co-founder Kürşat Ceylan was traveling across New York City. Ceylan, who’s been blind since birth, was speaking at the United Nations’ Convention for the Rights of Persons with Disabilities and, while making his way from the airport to his hotel with his suitcase, smartphone, and traditional white cane in hand, collided with a pole, causing him injury.
**Explore all case studies or submit your own**
Microsoft Tech Community – Latest Blogs –Read More
Problem with copilot and sidebar
Hello everyone,
I hope this message finds you well!
I recently installed Windows 10 and am using the Edge browser. However, I’m experiencing some issues: I can’t open Copilot, and the sidebar doesn’t seem to work. When I click the Copilot icon or press the sidebar shortcut (Ctrl + Shift + E), nothing happens.
Additionally, I noticed that the sidebar settings do not show the usual options for apps and notifications.
This is my first time encountering such issues, and I would appreciate any guidance or solutions.
Thank you!
Hello everyone,I hope this message finds you well! I recently installed Windows 10 and am using the Edge browser. However, I’m experiencing some issues: I can’t open Copilot, and the sidebar doesn’t seem to work. When I click the Copilot icon or press the sidebar shortcut (Ctrl + Shift + E), nothing happens.Additionally, I noticed that the sidebar settings do not show the usual options for apps and notifications.This is my first time encountering such issues, and I would appreciate any guidance or solutions.Thank you! Read More
Data in column C to split to 3 columns C, D & E to another sheet.
Hi,
I am new in using excel VBA. I can’t figure out on how to split the data from Column C (Sheet 1) to go
to Column C, D & E (Sheet 2) without the characters.
Sheet 1
Sheet 2
Hi, I am new in using excel VBA. I can’t figure out on how to split the data from Column C (Sheet 1) to goto Column C, D & E (Sheet 2) without the characters. Sheet 1 Sheet 2 Sheet 2 Read More