O365 activity for downloading Sharepoint List attachments

Feedback Activities
, , ,
1

Hi UiPath team,

Its been a while since Sharepoint activities packages has stopped working, hence the switch to Microsoft office 365 package has become a need of the hour. And it is not just for our organization, there are numerous requests coming in on forum from people across different organizations who are facing this below issue.

Issue with Sharepoint Activities package - “The sign-in name or password does not match one in the Microsoft account system”

Hence, more and more people switching their processes to Office365 package, however, direct alternative/replacement activity is not available in Office 365 package primarily for Downloading attachments from Sharepoint Lists.

Though there are few workarounds that are being suggested in the forum to deal with this, but I am not quite sure if anyone has been able to successfully do it.

It would be really helpful to have an activity for “Downloading List Attachments” in Office365 package as well.

Regards
Sonali

3

We have also raised a support ticket for same.

Regards
Sonali

4

Hi,

Sharing what we researched around this error:

This error occurs because legacy authentication has been blocked in many organizations.
This can be verified by checking with your org admin.

To get around this error, users need to be excluded from legacy authentication blocking.

Refer below post on how:

However, we couldn’t get the user excluded in our org for allowing usage of legacy authentication due to security concerns but it really is the root cause of this error.

Furthermore, we tried to switch to modern auth using O365 api but it has a limitation - it can’t fetch attachment URLs from sharepoint list items, so we ended up trying below solutions:

  1. Fetch attachments details from sharepoint list via http request. This step should work but didn’t work in our case due to access issues, seems like app id and secret had some restrictions which we have not been able to resolve yet.
  2. So, we created a power automate flow to fetch attachment details. Call that PA flow using http request from UiPath and collect the response. This worked like a charm!

Also, linking below posts on discussions/suggestions around same.

Hope this helps someone struggling with this issue.

Regards
Sonali

5

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.