Hello Power Platform community,
I'm seeking help with migrating a SharePoint list attachment column to a Power Pages table. Here are the steps I've taken so far:
-
Created a SharePoint list with columns: Category, Attachments, Base64 File (multiline text), File Type, etc.
-
Moved the SharePoint list to Power Pages tables as a Virtual table, but the Attachment column didn't migrate.
-
To resolve this, I converted the Attachment column to Base64 using Power Automate flow (see image below) and output the result to the Base64 File (multiline text) column.
However, I'm struggling to retrieve the Virtual table field into my Power Pages site using Fetch XML and JavaScript, specifically for PDF attachments. Neither approach works.
Step 1
Step 2
Step 3 when the flow to convert SharePoint Attachment to Base64 and place the output in the Base65 File Column, to confirm the process was completed send me an email with PDF attachment
In Visual Studio code I added MIME data types and Javascript to convert base64 content to Binary
When I open the link in power pages site
when I download the PDF and open got this error
any help would be much appreciated, thanks :)