“SortByColumns” on a column from a relationship among tables.

Question? Can we sort gallery filtered values on data located in a table connected to the gallery source?ERD table example: Issue. When using the gallery control to display and filter information based on a selection could be sometimes tricky. One gallery will display the information of the table "Room Class." The second table needs to…

Environment variables with SharePoint data source and Support tip.

When building applications on the Power Platform, using development, test, user acceptance testing, and production environment is best practice. Therefore configuration settings or parameters or needed to move the application between those environments. Environment variables store particular application objects' parameters and values and can be adjusted when moving a solution to another Power Platform environment.…

Item level security on a SharePoint list. What’s the behavior in a Canvas App?

The following question was posted last week on LinkedIn:Is it possible to authorise by item-level security in the SharePoint list?Each row contains three or four email ids in different columns (Text type). Only the people of those email ids should be able to edit or view the record when they come to SharePoint list view…

When using a canvas app, how do we restrict application users to change data in a SharePoint list from the SharePoint GUI?

Citizen Developers, Power users and champions often using SharePoint lists to store their data. They can use Power Apps, and Power Automate within their Office 365 Business Basic, Standard, E1 and E3 license.Because without restriction, when sharing the canvas app, they have permissions to the list and can change the data in the SharePoint GUI.…

Canvas App – Multi-selection combo box with date values in a Forms control.

Issue Using a Forms control to collect information from the end-user in a canvas app is a best practice. However, it is not often straightforward to display the data in a combo box, and this is because of certain limitations of the combo box - control itself. Let us explain the issue.Overview of the resources used to…

Using Azure Active Directory groups to give access to Power Apps applications.

Many of you have questions about giving access to a Power Apps application from Azure Active Directory groups. How do we manage access to a model app in Power Apps from AAD?How can we assign a role in Dataverse to a user? Without doing it for each active user.Where can I find the AAD security…

Use “shared mailbox” in Power Automate to send emails.

Often I get this question if a "shared mailbox" can be used in Power Automate to send emails and below concurs: What are the advantages and disadvantages?Do we need a Microsoft 365 license? Is it secure to use a shared mailbox? Do we need an account and password in the Power Automate flow? In this…

Behaviour of a Power Automate Flow after “Import” with “recurrence” – trigger

I get following question very often "what's the behaviour of a flow that has been imported as a new flow or have been updated, with a recurrence - trigger". A scheduled cloud flow, with trigger "Recurrence", more information. Listed up some test scenarios and created a very simple flow "Hello World", that is sending an…

Azure Blueprints – Create custom connector for Power Automate

Within Azure, we have a free service called Azure Blueprints. Azure Blueprints helps us in simplify largescale Azure deployments by packaging key environment artifacts, such as Azure Resource Manager templates, role-based access controls, and policies, in a single blueprint definition. Easily apply the blueprint to new subscriptions and environments, and fine-tune control and management through…

Get your custom logs from a Power App into Azure Log Analytics

Azure Log Analytics is a service that can collect logs from any resource, within Azure. Having the possibility to send custom logs, leads us seamlessly to the next point. Sometimes there's that need to check what's happening during a process, logging to a text file or keeping historical logs in a SQL database is mostly…

Trigger a Power Automate Flow from PowerShell script

Lately I was wondering how I can connect from a PowerShell script to a MS flow? Is this possible and how I can transfer variable(s) information from the script towards the Flow and use these values. In the simple blog example I will transfer variable values towards a MS Flow. What is needed? TypeNameInfoLicensingPowerShell Invoke-WebRequest…

Timesheet check for Project Service Automation (PSA – Microsoft Dynamics 365)

Losing a lot of time by checking everyone's timesheet if the work week has been completely registered in the PSA timesheet portal. In Belgium, most of the employees have 40 hours working week. In this MS Flow, a check will be performed every Friday evening around 8 PM.  Set time schedule Defining some variables that…

Environments and Data Protection – How-to!

Intro Power Platform of Microsoft (Power Apps, Microsoft Flow and Power BI) are tools that will help you, with your digital transformation 4.0. Microsoft Power Platform In the coming years, we will look at digital transformation 4.0 to optimize are business processes, production environments, healthcare, ... Currently I hear a lot of customers that are…

Buttons, Excel, Approvals and notifications

Intro Buttons, Excel, Approvals and notification in Power Automate. Tracking a starting and end point into Excel, by triggering a button. This is a flow that I will talk about today! The solution will have two Flow's that could be triggered by a button. The values will be added to an excel file that is…

Automated copy task from one Plan in MS Planner, to another.

Intro Getting into planner for managing the work of your teams, but you are lost in the total overview! Centralize the planning of your teams by creating them in an automated way toward a plan that will contain all teams. Need more information about Microsoft Planner: LINK Take the chaos out of teamwork and get…

From Forms to Power BI and the glue is Power Automate.

Intro In the coming days I have a meeting with technical people about PowerShell and would like to start with a survey to get an idea of the knowledge about PowerShell of the people in the room. Putting hands in the air is old school ... No? “Work Less, Do More” How-To? Creating a Microsoft…

Data Operations – Compose: Format Date and Time

Intro What is the definition of Compose action with Microsoft Flow? Use the Data Operations - Compose action to save yourself from entering identical data multiple times when you’re designing a flow. What does this mean in practice? You can shape the data that has been generated by an above action, by using an expression…

Flagging email creates TO-DO item

I would like to share this Microsoft Flow template with you all. I was used of creating manually to-do items (from an email out of MS Outlook) in a list on the Microsoft To-Do application. But this was really monkey work (Copy/Paste monkey work). “Work Less, Do More” So, I have created my own Microsoft…