• Data

    Excel Data – Paste and Patch

    Have you ever want to grab a block of Excel data, paste it and display in Power Apps, then patch it to your data source as new records? The process involves a bit of user discipline grabbing the correct columns, but it works. The first bit requires two controls – a Text Input set to multi-line and expanded appropriately and a HTML Text box for displaying the result in a structured manner. Below is an Excel sheet that has simply has the content copied and then pasted into the Text Input The top section is the Text Input and  the bottom a HTML Text box with the HtmlText of This displays the data in a structured column manner…