Toni Pohl

When users shall have access to a PowerApp that is using Dataverse (formerly Common Data Service - CDS), they also need to have the permissions to access the data entity (nowadays called table). So, if your users get an ugly “unknown error occurred” when accessing the PowerApp, here´s the solution to assign the required security role and permissions. The data table To demonstrate how to set permissions, I switched to the environment (in my sample, it´s the “Dev environment”) and created a new table in the https://make.powerapps.com/environments/[environment-id]/entities / Data / Table menu. The table name here is atworktest with some text columns. ...

Using SharePoint Online (SPO) and Azure Logic Apps helps to automate processes. For a project, we have created some workflows with Azure Logic Apps that monitor changes to an SPO list or document library for approvals and other document workflows. We have found that the SPO connector does not always send all data in a reproducible manner: sometimes some fields were sent and sometimes not. We struggled with this behavior and found an unexpected workaround. ...

Delegate365 v9.2 will be extended with some new features this March. See the latest features here. See the latest features of Delegate365 v9.2 such as extended reports retention dates, new message tracing options, a new license order process, some fixes and more at Delegate365 changelog 9.2-improvements Schema Extensions: Another new feature is described at Introducing user schema extensions in Delegate365. This allows to add custom user data to Azure AD. The custom data can be used with PowerShell for own business processes. See more at how to use Azure AD schema extensions in Graph PowerShell. ...

Automation of small tasks is helpful for many recurring processes. Unless you regularly use Power Automate (Flow) or Azure Logic Apps, it is often not that easy to remember the correct syntax for accessing items in a loop. Here is the quick help. This sample is using a flow in Power Automate to read messages from a Microsoft Teams team (I know, this sounds strange) and outputs any field to an email. The purpose is just to see how to access data in JSON format in a “Apply to each” loop. Here´s the screenshot of the complete flow with the description of the actions. ...

Schema extensions enable to store extended custom data directly to objects in Azure AD. This article describes how to access data we defined and added in Introducing user schema extensions in Delegate365 with the Microsoft Graph PowerShell module. Prerequisites To work with Microsoft Graph and PowerShell, we need to install the Microsoft.Graph module as described at Install the Microsoft Graph PowerShell SDK. You can install the module in PowerShell Core or Windows PowerShell using the following command. ...

The current version of Delegate365 adds a new feature: Schema extensions for users. Schema extensions allow to add custom data to Azure AD objects. In Delegate365, administrators can use the Delegate365 schema extension feature to add custom properties to a user. Find out, how you can use the user schema extension in Delegate365 here. Possible areas of application are e.g. predefined job titles, cost center, employee type, other emails or managers, or other user specific data where there is no property in Azure AD existing. The Delegate365 user schema extension can be declared and used in Delegate365 and in the Azure AD. There can be multiple properties defined, as a text field, or with predefined values as a selection field. ...

As developer, it often makes sense to have multiple versions of a framework installed on a single computer. For example, when developing SPFx applications with Node,js v10.x and developing web applications using Angular and Node.js v14.x you need both versions. Thankfully, with Node Version Manager, we can. To dive directly into the commonly used Node.js versions: SPFx apps require Node.js LTS 10.x, see Set up your SharePoint Framework development environment. All other versions of Node.js are not supported with SharePoint Framework development. ...

Azure Active Directory is Microsoft´s Cloud Identity system that stores user, license, group, apps, device data and more data in a secure way. As developers, we can extend many of these resources with custom extension. This can be useful to store additional metadata, such as a cost center or personal data for a user, for a group or other resource types. Unfortunately, there isn’t much documentation on that. Here’s how to do this step-by-step for the user resource with Azure AD schema extensions in real life. ...

A particularly challenging year is coming to an end. We would like to wish happy holidays and a happy new year to all of you. Once more, we say thank you for the good cooperation in 2020 and are looking forward to a hopefully healthy and successful 2021! This year for Christmas, we support the project UNICEF Österreich: für jedes Kind. atwork will be closed from December 24th, 2020 to January 6th, 2021. Our on-call duty and our support will be able to be contacted during the holidays. Our entire team will be back for you from January 7, 2021. ...

Yesterday I documented in “Get data from SharePoint as HTML table with Azure Logic Apps” how data is retrieved from SharePoint Online with an Azure Logic app. To dig a little deeper into working with SharePoint list data, here are a few more helpful tips. Query for empty fields (eq null) To find items in an SPO list that have NO value in an Azure Logic App SharePoint Get items action, we can use “<field> eq null” (and not eq ‘’ ). Simple as that, but good to remember. So in our sample, the ODATA filter query is as here: SubscriptionEndDate lt addDays(utcNow(),-30) and Invoice eq null ...