Posts

Open InfoPath form in Filler in SharePoint Server 2013/2016

To format a link to open an InfoPath 2013 form in filler form, you can use the following URL structure: ms-infopath:nft|u|https://sharepoint-site-url/Path-to-form.xml Here's what each part of the URL means: ms-infopath is a protocol handler that tells the browser to open the InfoPath form in the client application. nft is a parameter that specifies the form type. For InfoPath Filler forms, use nft=2. u is a parameter that specifies the URL of the form. https://sharepoint-site-url/Path-to-form.xml is the URL of the InfoPath form on the SharePoint site. To create the link, replace the https://sharepoint-site-url/Path-to-form.xml portion with the URL of your InfoPath form on the SharePoint site, and wrap the entire link in an <a> tag. For example, here's what the HTML code for the link might look like: <a href="ms-infopath:nft|u|https://sharepoint-site-url/Path-to-form.xml">Open InfoPath f...

Power Automate: Governance

Image
  Power Automate Governance refers to the management, administration, and control of the use of Power Automate within an organization. It includes policies, procedures, and processes that ensure that Power Automate is used effectively, securely, and in compliance with the organization's standards and regulations. Power Automate Governance helps organizations to: Ensure data security and privacy Maintain the reliability and stability of workflows Monitor and control the use of Power Automate within the organization Ensure compliance with regulatory requirements and standards Ensure that Power Automate workflows are optimized for performance Establish clear ownership and responsibility for Power Automate workflows To implement effective Power Automate Governance, organizations should establish clear policies, procedures, and processes for the use of Power Automate, and provide appropriate training and resources for users to ensure that they understand how to use Power Automate in a s...

PowerApps Governance: What to consider

Image
PowerApps governance refers to the policies, guidelines, and procedures for managing and administering PowerApps within an organization. It covers aspects such as the creation, deployment, and management of PowerApps, as well as the security and data management considerations. Some of the key components of PowerApps governance include data source management, user access and permissions, development and testing practices, and change management processes. The goal of PowerApps governance is to ensure that PowerApps are used effectively and efficiently while also protecting the organization's data and resources. Here are some steps to consider when implementing PowerApps governance: Define the Purpose: Clearly define what PowerApps will be used for within your organization and the expected outcomes. Establish Ownership: Assign a PowerApps administrator to oversee the platform and ensure compliance with governance policies. Define Security Requirements: Set up data security and privacy...

Create Azure AD groups from a CSV file

Image
To create Azure AD groups from a CSV file, you can use Microsoft Graph API and the Azure AD Graph API to programmatically create groups in your Azure Active Directory tenant. Here are the steps to follow: Authenticate to Azure AD: You need to authenticate to Azure AD by acquiring a token using OAuth 2.0. Read the CSV file: Read the CSV file containing the group information into your code. Create the groups: Use the Microsoft Graph API or the Azure AD Graph API to create the groups in your Azure AD tenant. The API requires you to send an HTTP request to create a group, which includes the group name and other properties such as description and mailNickname. Import the members: You can also import the members of each group from the CSV file by sending an HTTP request to add members to a group. Note: To avoid making multiple API calls for each group, you can also batch multiple group creation and member addition requests in a single API call, if supported by the API you are using. Here...

Get current GPS location in PowerApps

Image
To get the current GPS location in PowerApps, you can use the Location function. Here's an example of how you could use this function: Add a button to your app and give it a label such as "Get GPS Location". In the OnSelect property of the button, add the following formula: Set(LocationValue, Location.Latitude & "," & Location.Longitude) Add a Label control to your app and bind its Text property to the LocationValue variable. When you run the app and tap the button, the Label control should display your current GPS location in the form of latitude and longitude. Note: The Location function requires that you grant PowerApps access to your device's location services.

InfoPath to PowerApps: Best Practices

Image
 Here are some best practices for converting InfoPath forms to PowerApps: Plan the conversion: Start by mapping out the fields and controls that are used in the InfoPath form and how they will be translated into PowerApps controls. This will help you understand the scope of the conversion and what needs to be done. Evaluate the form data: Determine where the data from the InfoPath form is stored and if it is accessible from PowerApps. If not, consider using an alternative data source that is accessible. Choose the right PowerApps control: Consider the type of data being entered and choose the appropriate control that matches the data type, such as text input, checkbox, drop-down, etc. Use custom formulas and expressions: PowerApps has a rich set of formulas and expressions that can be used to perform complex data manipulations. Utilize these to replace the InfoPath form rules and custom code. Test the conversion: Once the form has been converted, test it thoroughly to ensure that a...

PowerShell script to create a Managed Metadata Service Application in SharePoint

Image
Here is the PowerShell script to create a Managed Metadata Service Application in SharePoint $serviceAppName = "Managed Metadata Service Application" $serviceAppProxyName = "Managed Metadata Service Application Proxy" $appPoolAccount = Get-SPManagedAccount "<Service Account>" $appPool = New-SPServiceApplicationPool -Name "$serviceAppName App Pool" -Account $appPoolAccount $serviceApp = New-SPMetadataServiceApplication -Name $serviceAppName -ApplicationPool $appPool -DatabaseName "$serviceAppName DB" $serviceAppProxy = New-SPMetadataServiceApplicationProxy -Name $serviceAppProxyName -ServiceApplication $serviceApp Get-SPServiceApplicationProxyGroup | Set-SPServiceApplicationProxyGroup -DefaultProxyGroup Replace "<Service Account>" with the appropriate service account for the application pool. Also, replace "$serviceAppName" and "$serviceAppProxyName" with your desi...