Workflow Only adding only one attachment from Dataverse Into SharePoint document library

[boom_powerapps]

I created a form in PowerApps connected to a dataverse table. When users use the attachment feature and attach multiple files, my workflow will only add the first file from the dataverse into my SharePoint document library.

If you look under the Apply to Each, you will see Show 1 of 1 when it should be 1 of 4 or 1 of 5.

[FLMike]

Hi,

Can you please show your trigger and the output of the trigger so we can see if the row states 4 attachments etc.

Cheers
If you like my answer, please Mark it as Resolved, and give it a thumbs up, so it can help others
Thank You
Michael Gernaey MCT | MCSE | MCP | Self-Contractor| Ex-Microsoft
https://gernaeysoftware.com
LinkedIn: https://www.linkedin.com/in/michaelgernaey

[boom_powerapps]

@FLMike here is the output:

{
"_owningbusinessunit_value": "ee0a9aec-b63d-e911-a81c-000d3a11eefe",
"_owningbusinessunit_value@Microsoft.Dynamics.CRM.lookuplogicalname": "businessunit",
"_owningbusinessunit_type": "businessunits",
"ph567_svmrequestsid": "bbc30f18-1860-ee11-be6e-000d3a548afc",
"statecode": 0,
"_statecode_label": "Active",
"ph567_requestid": "SVM00162",
"ph567_costcenter": "Account Management",
"_ph567_vendor_value": "8489ef78-533c-ee11-bdf4-000d3a548afc",
"_ph567_vendor_value@Microsoft.Dynamics.CRM.lookuplogicalname": "ph567_vendor",
"_ph567_vendor_type": "ph567_vendors",
"_createdby_value": "b0f2c762-bb4c-ee11-be6f-000d3a548afc",
"_createdby_value@Microsoft.Dynamics.CRM.lookuplogicalname": "systemuser",
"_createdby_type": "systemusers",
"createdon": "2023-10-01T05:05:13Z",
"ph567_description": "36522",
"modifiedon": "2023-10-01T05:05:13Z",
"_modifiedby_value": "b0f2c762-bb4c-ee11-be6f-000d3a548afc",
"_modifiedby_value@Microsoft.Dynamics.CRM.lookuplogicalname": "systemuser",
"_modifiedby_type": "systemusers",
"ph567_name": "Test the attachment 15236",
"_ph567_relationshipmanager_value": "004186f8-f666-46e6-ab9a-1c1480de41f8",
"_ph567_relationshipmanager_value@Microsoft.Dynamics.CRM.lookuplogicalname": "aaduser",
"_ph567_relationshipmanager_type": "aadusers",
"ph567_attachments": "bdc30f18-1860-ee11-be6e-000d3a548afc",
"_ownerid_value": "b0f2c762-bb4c-ee11-be6f-000d3a548afc",
"_ownerid_value@Microsoft.Dynamics.CRM.lookuplogicalname": "systemuser",
"_ownerid_type": "systemusers",
"statuscode": 1,
"_statuscode_label": "Active",
"ItemInternalId": "bbc30f18-1860-ee11-be6e-000d3a548afc",
"SdkMessage": "Create",
"RunAsSystemUserId": "b0f2c762-bb4c-ee11-be6f-000d3a548afc",
"RowVersion": "25151429"
}

Trigger:

[boom_powerapps]

@FLMike Output from Create File:

{
"statusCode": 200,
"headers": {
"Cache-Control": "max-age=0, private",
"Transfer-Encoding": "chunked",
"Vary": "Origin,Accept-Encoding",
"X-NetworkStatistics": "0,525568,0,0,35677,0,31697",
"X-SharePointHealthScore": "2",
"X-MS-SPConnector": "1",
"Range": "bytes=0-17101",
"X-SP-SERVERSTATE": "ReadOnly=0",
"DATASERVICEVERSION": "3.0",
"SPClientServiceRequestDuration": "456",
"SPRequestDuration": "456",
"X-DataBoundary": "NONE",
"X-1DSCollectorUrl": "https://mobile.events.data.microsoft.com/OneCollector/1.0/",
"X-AriaCollectorURL": "https://browser.pipe.aria.microsoft.com/Collector/3.0/",
"SPRequestGuid": "10673456-2c1d-48ce-8f45-aa4f69024087",
"request-id": "10673456-2c1d-48ce-8f45-aa4f69024087",
"MS-CV": "VjRnEB0szkiPRapPaQJAhw.0",
"Strict-Transport-Security": "max-age=31536000",
"X-Frame-Options": "SAMEORIGIN",
"Content-Security-Policy": "frame-ancestors 'self' teams.microsoft.com *.teams.microsoft.com *.skype.com *.teams.microsoft.us local.teams.office.com teams.microsoftonline.cn *.powerapps.com *.yammer.com *.officeapps.live.com *.office.com *.stream.azure-test.net *.microsoftstream.com *.dynamics.com *.microsoft.com onedrive.live.com *.onedrive.live.com securebroker.sharepointonline.com;",
"MicrosoftSharePointTeamServices": "16.0.0.24106",
"X-Content-Type-Options": "nosniff",
"X-MS-InvokeApp": "1; RequireReadOnly",
"P3P": "CP=\"ALL IND DSP COR ADM CONo CUR CUSo IVAo IVDo PSA PSD TAI TELo OUR SAMo CNT COM INT NAV ONL PHY PRE PUR UNI\"",
"X-AspNet-Version": "4.0.30319",
"X-Powered-By": "ASP.NET",
"Timing-Allow-Origin": "*",
"x-ms-apihub-cached-response": "true",
"x-ms-apihub-obo": "false",
"Date": "Sun, 01 Oct 2023 05:06:26 GMT",
"Content-Type": "application/json; charset=utf-8",
"Expires": "Sat, 16 Sep 2023 05:06:26 GMT",
"Last-Modified": "Sun, 01 Oct 2023 05:06:26 GMT"
},
"body": {
"ItemId": 685,
"Id": "%252fSVM%2bPortal%2bTeam%2bFolders%252fSVM00162%252fRequest_Attachments%252f_Financial_Logo.png",
"Name": "Financial_Logo.png",
"DisplayName": "Financial_Logo.png",
"Path": "/SVM Portal Team Folders/SVM00162/Request_Attachments/BHG_Financial_Logo.png",
"LastModified": "2023-10-01T05:06:27Z",
"Size": 17102,
"MediaType": "image/png",
"IsFolder": false,
"ETag": "\"{8B60159B-720D-48D9-9FCD-4C58D134B974},2\"",
"FileLocator": "dataset=aHR0cHM6Ly9iYW5rZXJzaGVhbHRoY2FyZS5zaGFyZXBvaW50LmNvbS9zaXRlcy9EZXZlbG9wbWVudENvbnRyYWN0TWFuYWdlbWVudFBvcnRhbA==,id=JTI1MmZTVk0lMmJQb3J0YWwlMmJUZWFtJTJiRm9sZGVycyUyNTJmU1ZNMDAxNjIlMjUyZlJlcXVlc3RfQXR0YWNobWVudHMlMjUyZkJIR19GaW5hbmNpYWxfTG9nby5wbmc="
}
}

[FLMike]

Thank you for that @boom_powerapps 

Looking at it, it only shows it has 1 attachment. I cannot say why it says that, not exactly but the way it should work is each update would trigger and technically I would suspect 4 triggers.

That or either

a) they all fire in a way so it looks like its only 1 attachment each time since they are simultaneously fired.

or

b) you have gremlins.

or

c) I would try setting your trigger, under Settings to have Concurrency On and = 1. Now I dont want you to have this forever, I just want to see if it ever triggers multiple times (in a row serially or not)

Cheers
If you like my answer, please Mark it as Resolved, and give it a thumbs up, so it can help others
Thank You
Michael Gernaey MCT | MCSE | MCP | Self-Contractor| Ex-Microsoft
https://gernaeysoftware.com
LinkedIn: https://www.linkedin.com/in/michaelgernaey

[boom_powerapps]

@FLMike Same result - still only displaying one file.

[FLMike]

Okies,

Its 2am for me so I am out, but I will try to repro this tomorrow for you. Is there anything special you can think of about your tables / columns I just want to make sure I repro it as accurately as possible.

[FLMike]

Also, and truly im tired so I could be remembering wrong right this second, but we only allowed 1 attachment per row, unless you added special activities so you could add more.

Can you do me a favor and paste the Dataverse side, where you can see the 4 documents? Its possible that you already are using SharePoint integration or several other ways to get around this. I just want to make sure.

And last question. When it triggered. Did it provide you the name of the document it just attached (in the single attachment) or an already existing attachment?

[boom_powerapps]

@FLMike I've JUST enabled SharePoint Integration for the DV table and the SP site where the attachments should go. Not sure what to do from here. I can add

Yes, in the create file output, you can see the filename:

"Name": "Financial_Logo.png",
"DisplayName": "Financial_Logo.png",

When I attach items below, I can then see them in my new library, how can I get the attachment field in my powerapps form to write to here so I can then copy it to its final destination?

[FLMike]

Hi @boom_powerapps 

Lets sort of reset then because you didn't mention that you already had SharePoint integration on so.

My question was related too, if you attach a file, it should already be going to SharePoint if you are using SharePoint integration. There should be no reason to create a flow to put it in SharePoint.

So then let's not worry about DT and it triggering and you only seeing 1 file in the Attachments. The question is, when you attach, do you see the files end up in the SharePoint document library, that you are using for the SharePoint integration, with Dataverse?

Cheers
If you like my answer, please Mark it as Resolved, and give it a thumbs up, so it can help others
Thank You
Michael Gernaey MCT | MCSE | MCP | Self-Contractor| Ex-Microsoft
https://gernaeysoftware.com
LinkedIn: https://www.linkedin.com/in/michaelgernaey

[boom_powerapps]

My apologies @FLMike ! I just added the SP Integration a few hours ago.

Here is my Form in PowerApps with 3 attachments:

When I view the record in Dataverse, I can only see one attachment.

And the SharePoint Integration Library I built doesn't have any of the attachments.

But, if I add attachments here, they show up in my SPI Library.

Hope this helps!!!