Hi,
I have a SharePointIntegration App and I have created 2 screens each with a Form. When I have entered all the data in the 2 forms I navigate to the last page which allows me to upload an attachment like so;
I stripped out the attachment option from a Form and pasted it into a blank screen with a submit button (I believe this is the best way to get things working)
The OnSelect property of the submit button consists of the following;
------------------------------------------------------------------------------------------------------------------------------------
//Following code converts attachment to binary format so that it can be stored in SharePoint
Set(varDemoFromAttachmentControl, JSON(Image2.Image, JSONFormat.IncludeBinaryData));
Set(varBase64Only, Mid(varDemoFromAttachmentControl, Find(",", varDemoFromAttachmentControl)+1, Len(varDemoFromAttachmentControl) - Find(",", varDemoFromAttachmentControl) -1));
//following code patches to a SharePoint List
Patch(
'SharePointList 1',
{
//Lots of inputs/comboboxes etc
}
);
//Following code patches to another SP List and the ID of the item created is stored in 'MyCollection'
ClearCollect(MyCollection,Patch(
'SharePointList 2',
Defaults('SharePointList 2'),
{
//lots of inputs/comboboxes etc
}
));
//Following code calls Power Automate Flow called 'CR_Attachments' and passes the recently created List item ID, the name of the attachment uploaded, and the contents of the attachment in Binary format
CR_Attachments.Run(First(MyCollection).ID, Last(Attacher.Attachments).Name, varBase64Only);
------------------------------------------------------------------------------------------------------------------------------------
The submit action works and both SP lists are updated correctly and the 2nd SP list shows an attachment icon. The Item ID (in this example '39') is clearly getting passed to the flow and trying to add the attachment;
However, when I go into the item there is no attachment. I checked the Flow and all seems to be working;
I'm thinking it's something to do with the file content and how it is getting sent across. Any help appreciated.
Thanks
