Skip to main content

Notifications

Finance | Project Operations, Human Resources, ...
Unanswered

Uploading and processing files from the Azure Blob

(0) ShareShare
ReportReport
Posted on by 20

Folks,

I'm attempting to upload and process bank reconciliation files that are uploaded to the D365 tenant's Azure blob storage, but it seems like D365 is not able to process files that were not uploaded through D365.

I was inspired to take this approach after investigating how D365 sends manually uploaded files to its tenant Azure blob.

I'm able to do the upload part fine, via a Power Automate flow, Create block blob action

pastedimage1677599015873v1.png

NOTE, I've removed the Storage account name from the screenshot:

pastedimage1677599041145v2.png

The file is uploaded to the blob:

pastedimage1677599066035v3.png

However, when I call the BankStatementImportBatch class and pass in the identifier, in the above example, XFxmY2..., D365 is not able to find the file, the call on line 118 in the below screen capture fails:

pastedimage1677599420282v4.png

When debugging, the exception looks like the following, note, the screen capture has a different id than the one above.

pastedimage1677600146072v10.png

This same logic works fine with files that are manually uploaded 

pastedimage1677599794595v6.png

pastedimage1677599790754v5.png

Both manually uploaded and Power Automate uploaded files are in the same temporary-file container on the tenant Azure blob.

I thought that the id might have a length restriction, but varying the lengths does not matter.

pastedimage1677599901613v7.png

pastedimage1677599911717v8.png

pastedimage1677599919597v9.png

Any ideas why Power Automate uploaded files are not visible to D365?

Thanks!

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Vahid Ghafarpour – Community Spotlight

We are excited to recognize Vahid Ghafarpour as our February 2025 Community…

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,971 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 230,846 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans