Hi everyone,

Wondering if this group could help answer whether it was possible to use power automate to update contents stored in a SharePoint Online Document Library. Basically update the different columns they have (eg. Description, custom columns etc) with data stored on something like a csv file?

Is that doable at all with Power Automate?

Ex. 

Doc Library:

ID           Name           Test Field

1            Test File        <Blank>

CSV File:

ID           Name           Test Field

1            Test File        Hello World

Post Power Automate state of Doc Library Content:

ID           Name           Test Field

1            Test File        Hello World

​Hi everyone, Wondering if this group could help answer whether it was possible to use power automate to update contents stored in a SharePoint Online Document Library. Basically update the different columns they have (eg. Description, custom columns etc) with data stored on something like a csv file? Is that doable at all with Power Automate? Ex. Doc Library:ID           Name           Test Field1            Test File        <Blank> CSV File:ID           Name           Test Field1            Test File        Hello World Post Power Automate state of Doc Library Content:ID           Name           Test Field1            Test File        Hello World  Read More

​

फ़्लिपकार्ट ग्राहक सेवा अधिकारी से बात करने के लिए 9831×224×914 या O983~1224~914 ▪︎डायल करें । आपको अपनी समस्या को स्पष्ट और संक्षिप्त तरीके से बताना होगा। आधिकारिक शिकायत दर्ज करने के लिए अधिकारी आपसे आपकी ऑर्डर आईडी, पंजीकृत मोबाइल नंबर..

​फ़्लिपकार्ट ग्राहक सेवा अधिकारी से बात करने के लिए 9831×224×914 या O983~1224~914 ▪︎डायल करें । आपको अपनी समस्या को स्पष्ट और संक्षिप्त तरीके से बताना होगा। आधिकारिक शिकायत दर्ज करने के लिए अधिकारी आपसे आपकी ऑर्डर आईडी, पंजीकृत मोबाइल नंबर..  Read More

​

So it seems like removing forum posts works, but removing a certificate from the Microsoft Database OR fixing this idoti.c Microsoft Partner Portal does not work within 2 MONTHS (whereas I see problems with this Partner Portal for almost a year now)?

Maybe the Forum admins should be levelled up to become backend administrators?

If Microsoft is not competent enough to fix the Microsoft Partner Portal problems, how about hiring skilled people rather than keep going with the current incompetent people who cannot and who are not willing to fix any problems?

Don’t be shocked but Microsoft AI is not up to it and will not fix it.

Why does Microsoft want to rely on cross signed Windows drivers if Microsoft is not competent enough to implement that in their eco-system?

Digicert is able to verify a company within 1 day while Microsoft is not able to fix their B2B issues within 2 month. Microsoft is not even able to verify the developer identification properly even though the developer is set as company owner which also shows up in the DUNS database.

What’s the goal of all that? Keep/make other people angry?

It’s so easy to fix those issues, why don’t you guys just fix them?

And reading .. the other department doesn’t share information, yes well then they should be laid off or getting taught to share information. The way Microsoft is going is absolute incompetent at the moment.

I really wonder how Microsoft can run a cloud service with such unreliable staff, customers joining this madness is nothing but an economical sui.cide mission.

​So it seems like removing forum posts works, but removing a certificate from the Microsoft Database OR fixing this idoti.c Microsoft Partner Portal does not work within 2 MONTHS (whereas I see problems with this Partner Portal for almost a year now)?Maybe the Forum admins should be levelled up to become backend administrators? If Microsoft is not competent enough to fix the Microsoft Partner Portal problems, how about hiring skilled people rather than keep going with the current incompetent people who cannot and who are not willing to fix any problems?Don’t be shocked but Microsoft AI is not up to it and will not fix it. Why does Microsoft want to rely on cross signed Windows drivers if Microsoft is not competent enough to implement that in their eco-system? Digicert is able to verify a company within 1 day while Microsoft is not able to fix their B2B issues within 2 month. Microsoft is not even able to verify the developer identification properly even though the developer is set as company owner which also shows up in the DUNS database. What’s the goal of all that? Keep/make other people angry?It’s so easy to fix those issues, why don’t you guys just fix them? And reading .. the other department doesn’t share information, yes well then they should be laid off or getting taught to share information. The way Microsoft is going is absolute incompetent at the moment. I really wonder how Microsoft can run a cloud service with such unreliable staff, customers joining this madness is nothing but an economical sui.cide mission.  Read More

​

Hey all, just after the best way to share files with External users in SharePoint. Our users are increasingly having issues with external users not being able to access our files.

Sometimes its user issue like sending a sharing link only for employees with external users. Sometimes its external users tenant conflicting with ours. However, we’ve been having issues with many external users having dropped access or no access at all even though they were added to permissions.

We haven’t changed any setting in our tenant, and this was a lot smoother couple of months ago. Whats the process in your tenant for external sharing? It would be helpful if you could give me a step by step on how you do it at your org.

Right now, this is us:

• User fille out a form with necessary info.
• Security looks at the domain and make sure it’s safe.
• We whitelist the domain if it’s not already and if full name is specified, we add the guest through Azure and add the person to SharePoint permissions. If full name not specified, go to the SharePoint link and add the user straight to the folder permissions.

Thanks in advance all

​Hey all, just after the best way to share files with External users in SharePoint. Our users are increasingly having issues with external users not being able to access our files. Sometimes its user issue like sending a sharing link only for employees with external users. Sometimes its external users tenant conflicting with ours. However, we’ve been having issues with many external users having dropped access or no access at all even though they were added to permissions. We haven’t changed any setting in our tenant, and this was a lot smoother couple of months ago. Whats the process in your tenant for external sharing? It would be helpful if you could give me a step by step on how you do it at your org. Right now, this is us: User fille out a form with necessary info.Security looks at the domain and make sure it’s safe.We whitelist the domain if it’s not already and if full name is specified, we add the guest through Azure and add the person to SharePoint permissions. If full name not specified, go to the SharePoint link and add the user straight to the folder permissions. Thanks in advance all  Read More

​

Hi all,

I think this should be relatively straight forward, but can’t find a simple solution…My data has 2 columns, a week of the year and a ‘score’

I need to create a spill result (so I can generate a dynamic chart), which separates the result of a filter into 3 columns:

Column1: Week 

Column2: Scores >50

Column 3: Scores <50

getting the three separate columns is not an issue, but it’s combing them into a spill result that I can’t fathom – using HSTACK with three FILTE functions means the scores/weeks do not align.

Any help much appreciated

​Hi all, I think this should be relatively straight forward, but can’t find a simple solution…My data has 2 columns, a week of the year and a ‘score’ I need to create a spill result (so I can generate a dynamic chart), which separates the result of a filter into 3 columns: Column1: Week Column2: Scores >50Column 3: Scores <50 getting the three separate columns is not an issue, but it’s combing them into a spill result that I can’t fathom – using HSTACK with three FILTE functions means the scores/weeks do not align. Any help much appreciated  Read More

​

This article is part of our AZ-700 series, offering a step-by-step guide on configuring Azure Private DNS, based on the tutorial available on YouTube. I highly recommend watching the video to gain a solid understanding of the concepts covered in this article. Through this guide, you’ll gain hands-on experience in setting up and managing Azure Private DNS, enabling efficient DNS resolution, network segmentation, and seamless automation within Microsoft Azure.

In today’s cloud environment, managing network resources and ensuring secure connectivity across virtual networks (vNets) can be complex, particularly when DNS management comes into play. This article provides a comprehensive, hands-on guide to setting up and configuring Azure Private DNS for efficient DNS resolution, network segmentation, and seamless automation in Microsoft Azure. Follow along as we explore the essential elements, from linking vNets and subnets to DNS automation.

Why Azure Private DNS?

Azure Private DNS allows you to manage and resolve DNS names within a virtual network without exposing them to the public internet. It simplifies domain name resolution, enhances security, and enables automation for dynamic environments.

Key benefits of using Azure Private DNS:

• Dynamic DNS Management: Automatically updates DNS records for new or deleted resources, eliminating stale or “dangling” DNS entries.
• Domain Delegation: Allows centralized DNS management by delegating your corporate domain to Azure Private DNS.
• Enhanced Security: DNS records are automatically removed when resources are deleted, ensuring up-to-date and secure network configuration.

Quick Recap: Azure Networking Fundamentals

Before diving into Azure Private DNS, let’s revisit some foundational concepts from our previous discussions:

• vNet (Virtual Network): Similar to a traditional VLAN but without broadcast support, a vNet enables secure and scalable resource management.
• Subnet: Subdivision within a vNet, allowing more granular control over resource segmentation.

Azure allows you to set up a single vNet with multiple subnets, maximizing network organization and security without the broadcast overhead typical in traditional networks.

Step 1: Understanding Azure Private DNS

Azure Private DNS enables the automatic registration of DNS names for resources within your vNet. For example, when you create a virtual machine (VM) in a vNet linked to a private DNS zone, the VM’s name and IP address automatically register within the zone. This streamlines DNS management, especially for dynamic environments where resources are created and deleted frequently.

Key Features

• Automatic DNS Registration: Automatically updates the DNS zone with new or removed resources.
• Domain Delegation: You can delegate your corporate domain to the private DNS zone, managing DNS records centrally within Azure.
• Support for All DNS Record Types: Azure DNS supports a full range of DNS records, including A, AAAA, CNAME, and MX records.

Step 2: Setting Up the Private DNS Zone

1. Create a Private DNS Zone

• In the Azure Portal, navigate to Private DNS Zones and create a new zone.
• Define a name for the DNS zone, such as yourdomain.private.
• Deploy the DNS zone and navigate to the resource.

2. Link vNets for Automatic DNS Registration

• Within the Private DNS Zone resource, select Virtual Network Links to connect vNets to the DNS zone.
• For each vNet (e.g., Core Services, West Europe, Asia), specify the vNet link and enable Auto Registration.
• This enables seamless DNS name resolution across linked vNets and allows automatic DNS record updates when resources are created or deleted.

Step 3: Verifying DNS Resolution and Connectivity

1. Verify DNS Records in the Private DNS Zone: Go to DNS Management under the Private DNS zone and check that the A records for the VMs appear.
2. Connect to VMs via DNS:
   • Use Remote Desktop to access one VM, then attempt to connect to the other VM by its DNS name (rather than IP address). This confirms that the Private DNS setup allows for name-based connectivity.
   • If issues arise (e.g., timeouts), ensure that firewall settings permit connectivity between the VMs.

Step 4: DNS Zone Peering Across Regions

With Azure Private DNS, you can link vNets across different regions, allowing resources in different geographic locations to resolve names and connect seamlessly.

1. Link vNets Across Regions: Connect the vNets in regions like West Europe, East US, and Asia to the Private DNS zone.
2. Verify Regional Connectivity: From a VM in one region (e.g., Asia), test connectivity to a VM in another region (e.g., East US) using DNS names. Azure Private DNS allows DNS name resolution across regions, ensuring consistent and reliable network connectivity.

Summary

Setting up Azure Private DNS is a powerful way to automate and centralize DNS management within a virtual network environment. This guide provides a practical framework for deploying Private DNS zones, linking vNets, and verifying connectivity. By configuring Azure Private DNS, organizations can streamline DNS management, secure network configurations, and enhance connectivity across geographically dispersed resources.

Next Steps

In future tutorials, we’ll explore VNet peering for advanced network configurations, allowing secure communication between isolated virtual networks. Be sure to subscribe and stay tuned for more Azure networking tips and tricks!

Let’s enhance your Azure network management with practical, hands-on solutions.

​This article is part of our AZ-700 series, offering a step-by-step guide on configuring Azure Private DNS, based on the tutorial available on YouTube. I highly recommend watching the video to gain a solid understanding of the concepts covered in this article. Through this guide, you’ll gain hands-on experience in setting up and managing Azure Private DNS, enabling efficient DNS resolution, network segmentation, and seamless automation within Microsoft Azure.    In today’s cloud environment, managing network resources and ensuring secure connectivity across virtual networks (vNets) can be complex, particularly when DNS management comes into play. This article provides a comprehensive, hands-on guide to setting up and configuring Azure Private DNS for efficient DNS resolution, network segmentation, and seamless automation in Microsoft Azure. Follow along as we explore the essential elements, from linking vNets and subnets to DNS automation.Why Azure Private DNS?Azure Private DNS allows you to manage and resolve DNS names within a virtual network without exposing them to the public internet. It simplifies domain name resolution, enhances security, and enables automation for dynamic environments.Key benefits of using Azure Private DNS:Dynamic DNS Management: Automatically updates DNS records for new or deleted resources, eliminating stale or “dangling” DNS entries.Domain Delegation: Allows centralized DNS management by delegating your corporate domain to Azure Private DNS.Enhanced Security: DNS records are automatically removed when resources are deleted, ensuring up-to-date and secure network configuration.Quick Recap: Azure Networking FundamentalsBefore diving into Azure Private DNS, let’s revisit some foundational concepts from our previous discussions:vNet (Virtual Network): Similar to a traditional VLAN but without broadcast support, a vNet enables secure and scalable resource management.Subnet: Subdivision within a vNet, allowing more granular control over resource segmentation.Azure allows you to set up a single vNet with multiple subnets, maximizing network organization and security without the broadcast overhead typical in traditional networks.Step 1: Understanding Azure Private DNSAzure Private DNS enables the automatic registration of DNS names for resources within your vNet. For example, when you create a virtual machine (VM) in a vNet linked to a private DNS zone, the VM’s name and IP address automatically register within the zone. This streamlines DNS management, especially for dynamic environments where resources are created and deleted frequently.Key FeaturesAutomatic DNS Registration: Automatically updates the DNS zone with new or removed resources.Domain Delegation: You can delegate your corporate domain to the private DNS zone, managing DNS records centrally within Azure.Support for All DNS Record Types: Azure DNS supports a full range of DNS records, including A, AAAA, CNAME, and MX records.Step 2: Setting Up the Private DNS Zone1. Create a Private DNS ZoneIn the Azure Portal, navigate to Private DNS Zones and create a new zone.Define a name for the DNS zone, such as yourdomain.private.Deploy the DNS zone and navigate to the resource.2. Link vNets for Automatic DNS RegistrationWithin the Private DNS Zone resource, select Virtual Network Links to connect vNets to the DNS zone.For each vNet (e.g., Core Services, West Europe, Asia), specify the vNet link and enable Auto Registration.This enables seamless DNS name resolution across linked vNets and allows automatic DNS record updates when resources are created or deleted.Step 3: Verifying DNS Resolution and ConnectivityVerify DNS Records in the Private DNS Zone: Go to DNS Management under the Private DNS zone and check that the A records for the VMs appear.Connect to VMs via DNS:Use Remote Desktop to access one VM, then attempt to connect to the other VM by its DNS name (rather than IP address). This confirms that the Private DNS setup allows for name-based connectivity.If issues arise (e.g., timeouts), ensure that firewall settings permit connectivity between the VMs.Step 4: DNS Zone Peering Across RegionsWith Azure Private DNS, you can link vNets across different regions, allowing resources in different geographic locations to resolve names and connect seamlessly.Link vNets Across Regions: Connect the vNets in regions like West Europe, East US, and Asia to the Private DNS zone.Verify Regional Connectivity: From a VM in one region (e.g., Asia), test connectivity to a VM in another region (e.g., East US) using DNS names. Azure Private DNS allows DNS name resolution across regions, ensuring consistent and reliable network connectivity.SummarySetting up Azure Private DNS is a powerful way to automate and centralize DNS management within a virtual network environment. This guide provides a practical framework for deploying Private DNS zones, linking vNets, and verifying connectivity. By configuring Azure Private DNS, organizations can streamline DNS management, secure network configurations, and enhance connectivity across geographically dispersed resources.Next StepsIn future tutorials, we’ll explore VNet peering for advanced network configurations, allowing secure communication between isolated virtual networks. Be sure to subscribe and stay tuned for more Azure networking tips and tricks!Let’s enhance your Azure network management with practical, hands-on solutions.  Read More

​

I have been patiently waiting for the checkbox tab to appear on my excel application. As of today, 11/4/2024, it is still not showing up. I have Office 365, and my Version 2404 (Build 17531.20140 Click-to-Run) is what I am showing. When I click on Update Now, nothing happens. When I click View Updates, it takes me to the current changes page informing me “We fixed an issue where some users couldn’t see checkboxes getting rendered after inserting them.”, but it isn’t even populating on my ribbon to view.

I pay for Office 365 on two different accounts and I am not showing it on either account. If someone could walk me through getting this to populate on my ribbon, I would greatly appreciate it.

​I have been patiently waiting for the checkbox tab to appear on my excel application. As of today, 11/4/2024, it is still not showing up. I have Office 365, and my Version 2404 (Build 17531.20140 Click-to-Run) is what I am showing. When I click on Update Now, nothing happens. When I click View Updates, it takes me to the current changes page informing me “We fixed an issue where some users couldn’t see checkboxes getting rendered after inserting them.”, but it isn’t even populating on my ribbon to view.I pay for Office 365 on two different accounts and I am not showing it on either account. If someone could walk me through getting this to populate on my ribbon, I would greatly appreciate it.  Read More

​

The Marketplace Summit UK, #MarketplaceSummitUK, recently brought together over 300+ Microsoft partners, including ISVs, systems integrators, and channel partners, to explore and capitalize on the rapidly growing opportunities within the Microsoft commercial marketplace. Here are 5 takeaways from the keynote which shared marketplace opportunities and insights from Jason Rook– Senior Director, Lead for channels sales for the marketplace, Andy Whyte– CEO, MEDDIC, Nick Ross– UK&I Channel leader, Wiz, and Amit Sinha– President and Co-Founder, WorkSpan.

Marketplace Growth:

• Microsoft commercial marketplace is experiencing substantial growth, with nearly 100% year-over-year sales increases from ISVs and Fortune 500 customers, particularly in the UK. This reflects a significant momentum and opportunity for partners to expand their reach and impact.
• By 2028, cloud marketplaces are projected to generate $85 billion in revenue*, underscoring the importance of joint selling and collaboration between ISVs, channel partners, and enterprise customers to capture this growth potential.
  • *Hyperscale cloud marketplace sales to hit US$85 billion by 2028. Canalys, August 15, 2024.

MEDDPICC Framework:

• MEDDPICC stands for Metrics, Economic buyer, Decision criteria, Decision process, Paper process, Identify pain, Champion, and Competition.
• The MEDDPICC framework is used as a common language for co-selling across the entire customer lifecycle streamlining communication, improving collaboration, and enhancing the effectiveness of sales strategies. It emphasizes the understanding of customer pain points, decision criteria, and stakeholder engagement

Multiparty Private Offers:

• Multiparty private offers enable customers to purchase software through trusted channel partners, and ISVs to sell through channel partners, streamlining the buying experience and boosting sales opportunities.  They are currently available in the US, Canada, and the UK.  These offers are set to expand to Western Europe and Japan.
• Over 90% of multiparty private offer deals originate from channel partners interacting with customers.

Insights from Nick Ross of Wiz:

• Commitment to Channel Partners for Growth: Wiz has adopted a global strategy to always work with a channel partner on customer engagements, viewing it as essential for scaling, customer retention, and market expansion.
• Marketplace as a Key Growth Driver: With over 90% of revenue going through cloud marketplaces, Wiz emphasizes that adopting a marketplace-centric approach accelerates deal cycles, enhances customer reach, and is critical for sustained growth.
• Wiz’s marketplace-first, channel-first strategy accelerates scaling, shortens time-to-value for customers, and boosts deal efficiency by closely partnering with Microsoft and providing CSPs early pipeline insights. This integrated approach strengthens customer relationships and drives market expansion, providing a roadmap to becoming a leader in marketplace-driven growth.

Ecosystem Integration and Insights- Discussion with Amit Sinha from WorkSpan

• End-to-End Ecosystem Orchestration: WorkSpan serves as a platform connecting ISVs, channel partners, and service partners with Microsoft and other marketplaces, enabling seamless co-selling, co-building, and integration into existing CRM systems for a unified experience
• Enhanced Deal Velocity and Data Insight: By automating partner integrations and embedding marketplace processes into CRM systems, WorkSpan increases deal registration rates and enables data collection on sales performance, providing actionable insights in real-time. 

To learn more, you can view the full Keynote session here: Marketplace Summit learnings: Maximizing marketplace success.

____________________________________________________________________________________________________

Additional Resources:

• Marketplace community
• Marketplace Blog
• Join ISV Success

​Microsoft Tech Community – Latest Blogs –Read More 

I am admin on my companies booking calendar, we have multiple technicians that are booked out to services by myself and the scheduler. There are technical team leads that can view their specific team’s availability and advise myself and the scheduler for work assignments.

Technicians are set up as guests on the calendar to be booked but without being able to view others calendars, team leads are set up as viewers to facilitate advising on scheduling. Recently there have been two technicians that were promoted to team leads, I updated their roles to viewer and they can’t see the calendar, they can find it by searching it for name but when they try to open it they are told they don’t have access to it.

Any advice on what may be causing this?

​I am admin on my companies booking calendar, we have multiple technicians that are booked out to services by myself and the scheduler. There are technical team leads that can view their specific team’s availability and advise myself and the scheduler for work assignments. Technicians are set up as guests on the calendar to be booked but without being able to view others calendars, team leads are set up as viewers to facilitate advising on scheduling. Recently there have been two technicians that were promoted to team leads, I updated their roles to viewer and they can’t see the calendar, they can find it by searching it for name but when they try to open it they are told they don’t have access to it.Any advice on what may be causing this?  Read More

​

Anyone know when 2025 can be purchased through the CSP program?

​Anyone know when 2025 can be purchased through the CSP program?  Read More

​