Hashing a SHA1 checksum of SP Online DocLib file

[Anonymous]

I'm working on a flow from a SharePoint Document Library which requires me to send a chosen file along with a SHA-1 checksum of said file. My question is simply: what is the best way of hashing the file to retreive the checksum? 

I don't really have the option of waiting for an update to Flows and would like to know if it were perhaps possible to utilize Azure Functions to this end?

Thanks for reading, any and all input greatly appreciated! 🙂

Probably related: MD5 Hashing

[Leo09]

Pretty sure that this cannot be done in flow, but with azure, maybe this is not the right place to ask.

[Anonymous]

Yeah, that's what I thought 😕 perhaps the best option would be to create an Azure function, they can be called from flows and return values right?

[v-monli-msft · Accepted solution]

Hi @Anonymous,

Please refer to below blog about how you can extend PowerApps to call an Azure Function:

https://powerapps.microsoft.com/en-us/blog/using-azure-functions-in-powerapps/

Regards,

Mona

[Anonymous]

I know this is an old question but I needed to do this as well and there is now a better solution available.

In my case I had a binary object (email attachment) and I needed to compare it with another binary object (file in sharepoint) to see if they were identical or not.  Comparing these in an if condition does not work - it will always return false even if the content is identical (this has had me stumped for days).

Ultimately I had the idea of calculating a hash from both binary objects and comparing the hash rather than comparing the content. Thankfully there is now an option to do this in the form of the Chainpoint connector (which I presume was not available back in 2017 at the time of this original post) - if you pass the string (in my case objects) to Chainpoint it will calculate a SHA1 checksum for you.  Easy and free!

[Clmfy]

If you get the file ,can direct use online checksum tools https://md5-checksum.com  in your Edge browser, support md5, sha256, sha1 🙂