Hello Community,
I have an automated flow that triggers when an item is added to the dataverse which copies all the details and duplicates all the info into a sharepoint list item.
All is working well but the problem is the file is corrupted and cannot be opened in the attachments of the SP list item.
I will share all the necessary steps that I've used to get the attachment from the dataverse row to the sharepoint list item below:
1) I used a
List Rows action of the Notes table then filtered it using the id of the trigger.
2) I created a loop with the body/value of the list rows action
3) in the add attachment action, I pointed it to the sharepoint list, the ID in this action is from a previous action that duplicated the dataverse details to the sharepoint list item. Which is 100% working
the file name expression: items('For_each_-_row_attachments')?['filename']
the file content expression: items('For_each_-_row_attachments')?['documentbody']
it is being attached to the sharepoint list item with the correct file name but you cannot open it
sometimes it says but its a jpg file which should be able to be opened. So I figured it might have something to do with the file content being damaged or corrupted.
