User Profile
PhilFancyAndMe
Iron Contributor
Joined Jun 05, 2018
User Widgets
Recent Discussions
Control "preferredLanguage" for local AD synced accounts
We got a single tenant for several branches around the world. There is a single forest, single domain with Entra ID Connect in place. In AD the properties of the user accounts that are related to user location are populated according to this standard: branch AD attribute c AD attribute co AD attribute countryCode AD attribute msDS-preferredDataLocation Switzerland CH Switzerland 756 EUR Germany DE Germany 276 DEU Italy IT Italy 380 EUR Netherlands NL Netherlands 528 EUR Poland PL Poland 616 EUR UK GB United Kingdom 826 EUR US US USA 840 NAM There is a Entra ID user attribute called "preferredLanguage". This is not set for most of our users. How could we solve this? Which attribute in local AD do we have to use? Do we need to change anything in Entra ID Connect? Hopefully someone could give advice and the information needed to achieve being able to configure the Entra preferredLanguage for our synced users out of our local AD. Thanks in advance!Azure Web App - Connect to Azure Managed Instance SQL DB
Hi there, need ideas how to let a Azure Web App connect to a Azure SQL DB (managed by Azure Managed Instance). Web App has public network access but no private endpoint: SQL Managed Instance is added to Azure virtual network/subnet. So, Web App is facing to the internet only. SQL Server is connected to the internal network only. Web App cannot connect to sql instance. I tried to create a private endpoint on the managed instance to get it work. But without success. As I am not too deep into the networking part of Azure I hoped to get help how to approach this. I need to be able to connect the web app to the managed instance. Just creating a private endpoint on the Web App ressource shows a warning that this undermines security. So I am looking for a secure way how to achieve connection from Web App to SQL instance/database. Thanks in advance. Additional information: The sql instance and databases are reachable from in Azure running virtual machines that have network adapters in the virtual network where the sql server is running. It's only the web app that is not able to connect (most likely because of missing internal network connection). Microsoft.Data.SqlClient.SqlException (0x80131904): A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: TCP Provider, error: 0 - An attempt was made to access a socket in a way forbidden by its access permissions.) ---> System.ComponentModel.Win32Exception (10013): An attempt was made to access a socket in a way forbidden by its access permissions.Self Service Password Reset without being forced to have MFA enabled
We have enrolled MFA for parts of our company (Guests, IT department, parts of the administration) so far and are slowly pushing forward. MFA is controlled by a Conditional Access policy where users or groups are added manually. At the same time we are currently implementing SSPR for our company. SSPR is set to "selected" and not to "all". That means we have a group where we add users to get SSPR enabled for them. This is how it is set up: If we enable SSPR for a user that has not being enabled for MFA by conditional access yet then this user is facing issues to set up his Self Service Password Reset questions. He is forced to register MFA what we do not want at this point (that is why we have not added him to the MFA Conditional Access policy at this point). Is there a way to make the users register SSPR for their account but not being forced to register MFA yet? Is it even possible to enable SSPR without MFA? We know that MFA is highly recommended. We are working on the full rollout. But there are users that are not ready yet. This is what the user is facing when SSPR is enabled for him but MFA is not yet enforced by conditional access: Says: Protect your account. Microsoft Authenticator. Get the app first.Re: Provide Company Contacts in Teams (for Teams Phone)
Possible solution: Create AD user account (AD hybrid synced or Entra ID account) for each phone number you want to be available in Teams and add telephone number to that account. You do not need to add a license to that user. Just being available in Entra ID is doing the trick. Note: It takes some time for new users to be available in Teams app. Check Teams on the web for cache free experience. Be aware that users will find this accounts in Teams search and chat will be available. Name this users in a way everyone understands that chat will not reach out to this entity but calling them will do. If there are any other ways to solve this issue feel free to post your solution.Provide Company Contacts in Teams (for Teams Phone)
Is there a way to provide centralized contacts for the whole company in Microsoft Teams? This could be such phone numbers like non-Teams landline phones somewhere in the facility or important external PSTN contacts. If there was no "centralized" way to do this maybe there is a workaround like creating users with this line phone numbers attached in Entra ID or something like that? Thanks.Re: Teams caller ID is not showing the caller's name, only the phone number
This references to outbound caller ID. For more information see "Override the caller ID policy" here: https://learn.microsoft.com/en-us/microsoftteams/caller-id-policies BUT - NinjaLee describes the issue that inbound calls TO Teams Phone only show the incoming number but not the name of the caller who could be some internal user calling. Entra ID should know all users with there telephone numbers (as they use their user and phone number in Teams as well) and should show the name of the caller instead of the phone number. Sorry NinjaLee for posting on this thread, but I am facing the same issue and hoped to hear from you how you solved it.Re: Project Online / SharePoint Modern UI
It's 2023 now and the https://www.microsoft.com/en-us/microsoft-365/roadmap?filters=Microsoft%20Project%2CIn%20development Looks like Microsoft is not investing in Project Online any more. 4+ years after this discussion was coming up there is still no modern look or nice Microsoft Teams integration for Project Online (not Project on the Web). Very disappointing.Re: Sharepoint list not refreshing after flow writes info.
KevDavies Now more than a year later we are still facing this behavior. Items changed by a flow (started from button within the list) get changed, but it takes up to 30 seconds until the list view refreshes. Confuses our users badly. Any solution or workaround for this known?SharePoint Online Custom Search on OnPrem SQL Server
Hi, within our SharePoint 2016 on prem environment we connected local SQL servers via BCS then added a search content source for that and used custom search templates to visualize this SQL data in SharePoint search. Recently Microsoft provided https://www.youtube.com/watch?v=2eOazbV2qLI after they showed https://www.youtube.com/watch?v=SG3ngNXGUX8 in 2020. As it is possible to use https://www.youtube.com/watch?v=GRwqvobkRHQ as well, I see a way how to show SQL based data in modern SharePoint sites. As the data I want to use in on prem and I have no chance of getting them to Azure I wonder if it was possible to connect External Content Type in SharePoint Online to local SQL over the "https://docs.microsoft.com/en-us/power-bi/connect-data/service-gateway-onprem" that Power Bi and Power Apps use easily. Or do you see another way of getting lots of local SQL data to be shown in modern SharePoint Search? Would be pleased to hear your opinion about how to do that or if it was possible. Thanks in advance! PhilippSearch for "Office Location" in M365 - shows up in Delve
Lots of our users have set their office location (property physicalDeliveryOfficeName in Active Directory) and/or Microsoft Delve profile. See red mark: This shows up fine in any Delve profile. Is there any way to see this in other locations than the delve profile? (Teams or SharePoint maybe?) Is there any way to search this property? Delve is a product that exists somewhere in the M365 universe. It is not a product that is used by the majority of our users. So the office location which is important for us (lots of branches) is something the users would like to see and search.Searchable App/List with 65000 Contacts - Power Apps? SharePoint? something else?
Hi, we got a contact search with 65000+ contacts in a SQL table that can be searched on SharePoint 2016 on premise search. This works fine. As we have switched to modern SharePoint Online, Teams, Lists and stuff we would like to get rid of the SharePoint 2016 on premise search. Therefore I need to enable the users to search this database in the modern world. The SQL table in on Azure. Items in this contact list are kept up to date from SAP data every night. Microsoft E3 plans are standard. What could be a way to achieve this? PowerApps? Has limitations when searching. As far as I experienced this limit is 2000 items - not suitable for my problem? Microsoft Lists? Views in SharePoint lists have 50k item theshold (as far as I experienced). In addition Lists would have problems to keep the list up to date as the contact data is from SAP and changes every day - at least some of the items. Has anyone an idea how to solve my problem? Maybe again some search driven solution? Thanks in advance! PhilippRe: Teams Desktop App not loading sharepoint List in Guest account
> 2 - make sure the guest user has the Microsoft lists app installed on his/her team's desktop app since if that is not available it will not work. PDostiyar: How can someone install the Lists app on his desktop app? The Lists app can only be installed to a channel/team as far as I know. Got the same problem here. Guests cannot open Microsoft Lists added as tab in channel (via the Lists app, not as website). EDIT: Did some digging and was able to figure out a workaround. In Teams on the web guests can use Microsoft Lists in Teams without any issues. When they use the current stable version on Teams App (Windows) then Microsoft Lists will not work in Microsoft Teams. Workaround: If the guests enable the developer preview (currently 1.4.00.4167) then Microsoft Lists will work in Microsoft Teams teams.Re: Unable to assign numbers to users
ChonoN I got the exact same issue. There are no users shown in the search box when trying to assign a phone number (type "Users") to any user account with phone system license. Location: Germany, but not German Cloud Tenant, normal Western Europe tenant. Users have E5 or E3 with phone system activated. Domestic calling plans are available. When editing a number (Type "Users") and trying to add a user in the user select control there are no users available to select. Have you been able to resolve the issue? EDIT: Found the problem on our side! In 365 Admin Center please double check: User needs to have Phone System AddOn activated User needs to have Calling Plan activated (that was missing in our case) User needs to have Teams enabled in Apps
