“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…

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…