Canvas Apps – Tips & Tricks part 2

You Can Extract JSON Data Without Power Automate

  • Power Apps natively supports JSON parsing without needing Power Automate!
  • Example: If you have a JSON string like:
     
    {"name": "John", "age": 30}

    You can extract data using:

    JSONData.name
  • This is great for working with API responses without extra calls.

You Can Open External Apps Like WhatsApp, SMS, and Email

  • Power Apps lets you open mobile apps directly with Launch().
  • Examples:
    • WhatsApp:
      Launch("https://wa.me/1234567890")
    • SMS:
      Launch("sms:1234567890")
    • Email:
      Launch("mailto:someone@example.com")
  • Great for integrating communication features without extra connectors!

Use the “With” Function for Cleaner, Faster Code

  • Instead of writing long nested formulas, use With().
  • Example: Instead of:
     
    Label1.Text = LookUp(Orders, ID = SelectedID).Customer.Name
  • Use:
     
    With(LookUp(Orders, ID = SelectedID), Name)
  • This improves readability and makes debugging easier!

You Can Use Power Automate to Generate PDFs (Without Premium Connectors!)

  • Most devs think you need Power Automate’s premium “OneDrive Create PDF” action, but there’s a free hack!
  • Use Word Templates in Dataverse to generate a document, then export it as a PDF—all using the standard Dataverse connector.
  • Steps:
    1. Create a Word template with placeholders.
    2. Populate it with Power Automate.
    3. Convert it to PDF using the free Word Online connector!

You Can Create a Search Box That Filters ANY Gallery (Without Delegation Issues!)

  • Instead of using Filter() (which has delegation limits), use StartsWith() for text search—it’s fully delegable in SharePoint, Dataverse, and SQL.
  • Example:
     
    Filter(MyGallery, StartsWith(Title, txtSearch.Text))
  • This ensures your search works on large datasets without hitting delegation limits!

Related posts

Power Platform Pricing Made Simple (2025 Update)

Quickly Remove Solution Layers Without Checking Every Single Component

Mastering Union, Except, and Intersect in Power Automate: A Simple Guide