
Hi everyone,
I am working with a Dataverse table Process schedules, which does NOT have an attachment field.
In my Canvas App, I added a custom attachment control inside a custom data card (not part of the Dataverse form fields).
I want to save these uploaded attachments when clicking the Save button.
However, when I tryPatch(
'Process schedules',
LookUp('Process schedules', 'PS ID' = varRecordEdit),
{ Attachments: DataCardValue49.Attachments }
);
…I get red line errors because:
The table has no attachment column
My attachment control exists only inside the form, not in the Dataverse table
I learned that these attachments must be stored in Dataverse Notes (Annotations) instead.
But I am confused about:
How to correctly Patch attachment files to the Notes table
How to link each attachment to the correct Process schedules record
How to show the saved attachments in a gallery
How to build Download and Delete buttons
Here are screenshots of my form and error messages:
📎 Attachment:
📎 Attachment:
📎 Attachment:
📎 Attachment:
👉 I need help with the exact Patch() formula to save attachments into Notes, and also the gallery formula.
Any guidance would be greatly appreciated!