Answered

Get file content response is binary still there is error in sharepoint activity of Power automate desktop

(2) Share

Report

Posted on by sdeokule

Hello Team

I am working with SharePoint activities to download the files from SharePoint but while using the activity Get file content the out is binary still while converting to text it is showing error as follows.Please let me know solution for it

Thanks

Sunil

Categories:

Power Automate Desktop

I have the same question (0)

All responses (10)

Answers (1)

Gidi 601 on at

Like (1)

Report

Hi, this is a known bug in the latest version (2.29). Sharepoint actions are still in preview and this can happen. You only can fix it by rollback the update and install the previous version of PAD (ask Microsoft Support).

Was this reply helpful? Yes No
Verified answer

MokiGK 13 on at

Like (0)

Report

I have a dirty workaround.
I put in the Convert to binary data action (from File actions), using something invalid, so it fails updating the same variable used with the sharepoint action.

However this works, so the flow will actually run, I set the input to the "Convert to binary data" action (from File actions) to the same sharepoint file, and set the "on error" to just continue (it will not be able to convert this file).
This fools the sharepoint version of convert to file without errors.

Was this reply helpful? Yes No
sdeokule 31 on at

Like (0)

Report

Hello

Can you please share some screenshots to check the workaround?

Was this reply helpful? Yes No
MokiGK 13 on at

Like (1)

Report

So it looks like this in my PAD, it's inside a loop:
The "error handling"

Was this reply helpful? Yes No
YuHash 106 on at

Like (0)

Report

@MokiGK
Wow, you are genius! Thanks for the workaround.

Was this reply helpful? Yes No
sdeokule 31 on at

Like (0)

Report

Hey Team,

The compile time error is handled but run time its there.

This workaround is not working for me

thanks
Sunil

Was this reply helpful? Yes No
YuHash 106 on at

Like (0)

Report

@sdeokule
Hi, it perfectly worked for my case, and I don't really understand what you mean...
Screenshots would help...

Was this reply helpful? Yes No
sdeokule 31 on at

Like (0)

Report

Hello@YuHash
Plz find the screeenshots

Was this reply helpful? Yes No
YuHash 106 on at

Like (2)

Report

@sdeokule
Ah, you should replace binary data to the variable derived from the first SharePoint action.
See MogiGK's screenshot again. Let me know the outcome. Thanks!

Was this reply helpful? Yes No
sdeokule 31 on at

Like (1)

Report

Hello Team,

The issue is resolved.
Thank you so much for your support

Sunil

Was this reply helpful? Yes No