cancel
Showing results for 
Search instead for 
Did you mean: 

Join the discussion

Most Recent
rampprakash
Super User
Super User

In this blog we will see how to filter Gallery with Blank Values Without Delegation Warning

Read more...

JR-BejeweledOne
Super User
Super User

Do you want to sort your gallery so all items where a column is blank are either all at the top or all at the bottom? Here is how you can do that.

Read more...

rampprakash
Super User
Super User

In this Blog we will see how to get count of SubGrid Record in Microsoft Dynamics CRM using Web Resource

Read more...

suparna-banerje
Frequent Visitor

This article will show the detail step-by-step process for setting up Power Platform Application Lifecycle Management with Azure DevOps. It will cover the steps to pre-configure Environment variables and connection references as a part of the deployment pipelines and also the pointer to the process of running the pipelines using Managed Identity.

Read more...

suparna-banerje
Frequent Visitor

This article will show the step by step process to implement Application Lifecycle Management for Power Platform using GitHub actions.

Read more...

rampprakash
Super User
Super User

In this Blog, we will see how to create Model Driven Apps with Security Role Permission

Read more...

DeviKrishna
Super User
Super User

In this blog we will see how to set table ownership in Powerapps,

Read more...

AhmedSalih
Super User
Super User

USE CASE
We have a Dataverse and Model-Driven App that is Managing Cub-Cake Orders. This MDA manages new orders and customer information. There is a third-party system that is handling the shipping process and updates the shipping information into a SharePoint list. We need the customer service department to be able to check the orders' shipping status and confirm shipment once complete.

 

Watch the Tutorial Part 1

Watch the Tutorial Part 2

Read more...

JR-BejeweledOne
Super User
Super User

Would you like your labels and dropdowns to have the same rounded corners that text input controls do?  Here is a handy way to make that happen.

Read more...

DeviKrishna
Super User
Super User

It is now possible to use Azure AD security group to map your business unit for streamlining your user administration and role assignment.

 

Read more...

cchannon
Super User
Super User

Recently, I started a journey with the PowerFX language as a Pro-Coder. The objective: to enable low-coders to author Plugin executions in PowerFX instead of with C#, finally opening up the power of event-driven logic to the broader Power Platform community.

 

This is Part 2 of a series of blog posts I am writing about that Journey - and it is pretty much the beating heart of the solution: A Plugin Package that includes the latest prerelease PowerFX Interpreter code so that at runtime we can grab PowerFX authored for the event, evaluate it, and commit changes to the record mid-transaction.

Read more...

WarrenBelz
Super User
Super User

There is a generally simple method of detecting a mobile device where Location.Altitude > 0 || Acceleration.X > 0 being true will detect a mobile device (as opposed to a PC), but we now have "cross-over" devices with these sensors being used as office PCs - so how do we detect them? 

Read more...

cchannon
Super User
Super User

Power fx.pngAfter learning about some of the latest advances in PowerFX from the great @MikeStall at the Power Platform conference this past September, I decided to author my own PowerFX implementation use case, and set about pondering what that should be... I eventually settled on the idea of Plugin execution context, mostly because the only PFX evaluator Open Sourced so far is the C# one, and @filcole had already beaten me to the punch with his amazing Custom API implementation!

 

This is the first of a series of blog posts I'll put up here on the community detailing that journey, as I have built--and continue to build--that concept and put it up on GitHub for the community to take and expand upon.

 

In this post (part 1) I will walk through what was the simplest part of the journey: writing a simple PCF Monaco Code Editor for PowerFX. This editor falls far short of the samples already on GitHub from the PowerFX team, but it is very Dataverse-friendly and that's why I felt this alternative needed to be authored.

Read more...

AhmedSalih
Super User
Super User

DATAVERSE FORMULA COLUMNS

Formula columns are columns that display a calculated value in a Microsoft Dataverse table. Formulas use Power Fx, a powerful but human-friendly programming language. Build a formula in a Dataverse formula column the same way you would build a formula in Microsoft Excel. As you type, Intellisense suggests functions and syntax and even helps you fix errors.

CLICK HERE TO WATCH THE TUTORAIL VIEW

Read more...

AhmedSalih
Super User
Super User

INTRODUCTION
This tutorial is to show how we can work with Dataverse Lookups and Choices columns within Power Automate. Many use cases require updating or creating new Lookup or Choices values when creating or updating Dataverse data records. First, we should know that the Lookup columns hold the related records' GUID values and the Choice columns hold the integer values of the Choices lists. So, when trying to update or create values in those tables, we have to keep in mind that we are working with the GUIDs and Integer values and not the actual display label or text values that appear on those columns if we are accessing the data from the editor in the Dataverse. CLICK HERE TO WATCH THE TUTORIAL

Read more...

DeviKrishna
Super User
Super User

In this Blog we will see how to enable Address finder search in Canvas PowerApps.

Read more...

maqsoftware
Regular Visitor

This guide covers the 11 best practices you need to optimize your canvas apps.

  1. Enable Loading Spinner for galleries
    Loading Spinners indicate to users that content is still being loaded, reducing confusion or likelihood of leaving the page.
    In the Gallery panel, under the Advanced tab, change LoadingSpinner.None to LoadingSpinner.Controls or LoadingSpinner.Data based on your needs.

    maqsoftware_2-1669616392118.png

  2. If using more than 20 images, insert them as HTML text
    Images uploaded through the Media panel increase the app’s load time. If using more than 20 images, insert them as HTML text to minimize load. For example: Uploading 25 images through the Media panel results in a 3-second load time, whereas uploading 25 images using a tag result in a 1-second load time.
    Go to Insert > Text > HTML text and enter “< img src='INSERT HYPERLINK'>” in the formula bar.

    maqsoftware_4-1669617664591.png

  3. Create components for common elements
    To save time and unify design across screens or apps, create components for frequently used elements like headers and footers. This enables you to easily reuse elements so you don’t need to recreate them.
    In the Tree view pane, go to Components > +New component and build your component.

    maqsoftware_6-1669617766527.png

  4.  Use Concurrent function if formula execution is nonsequential
    If you have more than one formula in no particular sequence, evaluate the formulas using the Concurrent function. The Concurrent function evaluates multiple formulas simultaneously, enabling your app to load data faster.

    maqsoftware_7-1669617882350.png

  5. Use delegable calls over non-delegable calls

    When calling data sources, some functions are delegable while others are not. Delegable functions are evaluated on the server with higher performance. Non-delegable functions require the data be downloaded to the client and evaluated locally. This process is slower and more data-intensive than a delegable call.

    maqsoftware_0-1669618777220.png


  6. Use IfError for exception handling
    The IfError function tests values for errors. If the function finds an error, it replaces the error with a valid value so downstream calculations can continue without delay.
    IfError is a Power Apps experimental feature and is turned off by default. To enable it, go to Settings > Upcoming features > Experimental and turn on “Formula-level error management”. Once it’s enabled, enter IfError(1/0, Notify(“Error has occurred”, Error), Notify(“Success”, Success)) in the formula bar.

    maqsoftware_8-1669618006828.png

  7. Store data in a collection
    To avoid repeated calls to the data source (which takes more time), store data in a collection or use the Set function to cache data from the lookup tables locally and then use it everywhere inside the app.

    maqsoftware_9-1669618065904.png
  8. Use a global variable or collection to share information between screens
    To avoid control dependencies, use a global variable or collection to share information between screens.
    Example: Do not use ‘Gallery.selected.columnName’ in screens other than where this gallery exists. Instead store this value in a global variable i.e., Set(galData, Gallery.selected.columnName) and then use this variable.

    maqsoftware_10-1669618117691.png

  9. Use combo boxes instead of drop downs
    Combo boxes are a combination of a search bar and a drop down. They enable users to search for items or view items by category, instead of having to scroll through long traditional drop down lists.
    To add a combo box, go to Insert > Input > Combo Box

    maqsoftware_11-1669618172140.png

  10.  Use themes
    A theme defines the design properties for controls and components such as colors, fonts, and borders.
    Using themes enables you to maintain design consistency across your app.
    Under the Home tab, use the Theme drop down to choose a theme.

    maqsoftware_13-1669618255616.png

  11. Limit code inside the OnStart property
    Limit the code within the OnStart property to improve the debug process and use StartScreen property to prevent complex, long-running formulas in App. OnStart can significantly slow the startup time of an app.

     

    maqsoftware_1-1669618891415.png

     

    References

cchannon
Super User
Super User

The OOB SharePoint document integration experience in model driven apps is great, but it doesn't really leave much room for customization and it leaves you out in the cold when it comes to more sophisticated SharePoint document management tasks, like checkouts, publishing, and more. Luckily, a tiny, quiet change that came out from the SharePoint team this year has opened up the possibility of a richer experience than ever before. This post will show you how, including all the code and even a read-to-install solution zip!

Read more...

ArchitectMadhan
Super User
Super User

If you want to reduce the learning time for users to use your Canvas App, then try to implement the Contextual FAQs to show the users what they can do from the current screen.

Read more...

maqsoftware
Regular Visitor

Date Range app, built on Microsoft Power Platform, enables you to select start and end date from same. You can easily integrate this in any Power App and start playing with date ranges.

Additional Details:

  • Date Range Calendar component will output Start Date and End Date as variables
  • The output can be integrated seamlessly with other components

Also, it is available in AppSource: https://appsource.microsoft.com/en-us/product/dynamics-365/maqsoftware1587623472284.powerappscalenda...

Read more...

maqsoftware
Regular Visitor

A word cloud is a visual representation of text data. Word clouds are generally used to know the general perception of audience through textual feedback. If a certain word is repeated more in the textual feedback, it appears bigger in the diagram


Additional Details

  • Properties of word cloud can be controlled using the editable configs in Power Apps
  • Word cloud can be connected to any available sources in the Power Apps

For any feature requests or questions about this component, please post in the below forum:

https://maqsoftware.zendesk.com/hc/en-us/community/posts/4406164215316-Word-Cloud-for-Power-Apps-by-...

Also, it is available in AppSource: https://appsource.microsoft.com/en-us/product/dynamics-365/maqsoftware1587623472284.wordcloud_bymaqs...

Read more...

vijaybn
Administrator
Administrator

UPDATE: We are excited to announce that the new Power Apps Ideas site is live! Starting today, November 29th, please submit your product ideas via the new site aka.ms/PA_Comm_Ideas!

Read more...

rampprakash
Super User
Super User

In this Blog we will see how to Generate Word Document Template using Power Automate with SharePoint as Back End.

 

Covered:

 

1. Repeating Table

2. Single Line of Text

Read more...

AhmedSalih
Super User
Super User

PowerApps Canvas Studio has moved the previous preview feature, " Enable modern command" to GA, and you can no longer disable it. But there is a new Preview feature to enable the legacy ribbon, which will get you the old command bar. 

8BD95305-A4C0-4866-B569-89F61A38A785.gif

Read more...

rampprakash
Super User
Super User

In this Blog, we will see how to get Quarter from Date from Canvas PowerApps

Read more...

rampprakash
Super User
Super User

In this Blog we will see how to Send email with Line Break from SharePoint List Using Power Automate from Multi-Line Text

Read more...

rampprakash
Super User
Super User

In this Blog, we will see how to filter To/Cc/Bcc Column in Email Table

Read more...

rampprakash
Super User
Super User

In this Blog we will see how fix INVOKER CONNECTION OVERRIDE Failed error from Microsoft flow - Request to Azure Resource Manager failed with error: '{"error":{"code":"InvokerConnectionOverrideFailed","message":"Could not find any valid connection for connection reference name 'shared_excelonlinebusiness' in APIM tokens header."}}'.

Read more...

rampprakash
Super User
Super User

In this Blog we will see how to Increase File Column Size in Dataverse/ Model Driven App Environment

Read more...

AhmedSalih
Super User
Super User

mppcs3.png

 

Co-authoring problems in Power Apps Canvas Once the application is opened for editing, it is blocked for the current user, other people who have editing privileges cannot edit the application until it is saved, and the editor is closed.
There are therefore two ways to solve the problem:
1. Work on different applications and do the "merge" at the end (impractical)
2. Use GIT Version Control to enable more than one person to edit a canvas app at the same time

 

By: Fabio Franzini @1st Microsoft Power Platform Conference, September 2022

§ Founder & CEO Apvee Solutions
§ Microsoft MVP in Business Applications & M365 Development Categories
§ PnP Team Member
§ Mail: fabio@apvee.com
§ Twitter: @franzinifabio

Read more...