Posts

Power Apps Portal: How to Display Tooltips on a Form

Image
In this article, I will explain how to display tooltips in a Power Apps Portal (Power Pages) form . Tooltips are a simple yet powerful way to improve user experience in Power Apps Portal (Power Pages) . In this post, I’ll explain how to display tooltips on portal forms using Dataverse field descriptions . 🧩 What is a Tooltip? A tooltip is shown when a user hovers over a field label. In Power Pages, this tooltip comes directly from the Description property of a Dataverse column. Step 1: Add Descriptions to Dataverse Columns. I used an existing Dataverse table named Order and added descriptions to the required columns.  These descriptions will be used as tooltip text in the portal. Step 2: Update the Main Form Open the Order Main Form Add the required fields Save and publish the form Step 3: Configure Basic Form and Web Page Create or update a Basic Form that uses the Order Main Form Attach the Basic Form to a Web Page in the portal Step 4: Enable Tooltips on the Basic ...

How to Create API with Header and line data & Auto-Posting APIs in Business Central

Image
 1 . Creating a Custom API Page Define PageType = API Required API properties ( APIPublisher , APIGroup , APIVersion , EntityName , etc.) Create Purchase Order header API Add subpage for lines API:  https://api.businesscentral.dynamics.com/v2.0/<EnvironmentName>/api/<APIPublisher>/<APIgroup>/v2.0/companies(<CompanyId>)/purchaseorderapis?$filter=no eq 'PR-ORD-0017869'&$expand=purchaseorderlineapis Method: GET Response: Get header and line response. 3. Creating an API to Post Purchase Orders Business scenario: Convert PO → Posted Purchase Invoice Create global function with [serviceEnabled]. API: https://api.businesscentral.dynamics.com/v2.0/<EnvironmentName>/api/<APIPublisher>/<APIgroup>/v2.0/companies(<CompanyId>)/purchaseorderapis(<systemidfrompurchaseheader>)/Microsoft.NAV.Createpurchaseinvoice Method: post     [ ServiceEnabled ]     [ Scope ( 'Cloud' ) ]     procedu...

Send Word Layouts for Email Body

Automatically Email Sales Invoices with Word Layout Email Body and PDF Attachment in Microsoft Dynamics 365 Business Central. Automatically emailing invoices with a nicely formatted email body and a PDF attachment is one of the most common Business Central automation needs. With a simple AL customization, you can make your system send branded invoice emails automatically — saving time, improving customer experience, and ensuring professional communication every time. What the automation does When this automation runs, it performs these key steps: Checks the invoice – ensures the invoice is completed or fully paid before sending. Finds the right email addresses – uses the customer’s “Sell-to Email” , and if available, also includes an Approver’s email . Uses a Word layout as the email body – gives your email a polished, branded appearance using your existing Word report layout. Creates a PDF of the invoice – automatically generates and attaches the PDF invoice to the...

Power Pages — Create Custom Button to Update Data via Web AP

Power Pages Tutorial — Create a Custom Button to Update Data via Web API In this tutorial, you’ll learn how to create a custom button in Microsoft Power Pages (formerly Power Apps Portals) that updates data in Microsoft Dataverse using the Web API . This step-by-step guide will help you securely perform server-side updates (PATCH calls) from your portal form with proper token-based authentication. We’ll take the Sales Order form as an example and build a “Submit to BC” button that changes the order’s status when clicked. Objective After completing this tutorial, you’ll be able to: Add custom action buttons to Power Pages. Safely call Dataverse Web API using JavaScript. Use the PortalWebapiJS Web Template to manage authentication. Configure and enable entity-level Web API permissions. Test the complete integration end-to-end. Step 1: Create a Custom Button in the Power Pages Form Open your desired form (e.g., “Edit Sales Order”). Click + Add → HTML text in...

Document Attachment with Item Journal Table in Business Central

Image
Business Central already provides the Document Attachment framework, but sometimes you need to extend it to work with additional tables. In this blog, I’ll show you how I extended the Document Attachment functionality to support the Item Journal Line table. By the end, you’ll be able to attach documents (like invoices, PDFs, or scanned files) directly to item journal lines and view them from the journal page. Step 1: Extend the Document Type First, extend the Document Type in the Document Attachment table to include a new option for Item Journal . This makes it possible to tag an attachment specifically for an item journal line. enumextension 50500 "Attachment Dc" extends "Attachment Document Type" {     value ( 50500 ; "Item Journal" )     {         Caption = 'Item Journal' ;     } } Step 2: Add Template Name and Batch Name Fields The standard Document Attachment table doesn’t store the  Template Name  and ...