How to get the file from sharepoint and drop the file on sharepoint?

Help Activities
, ,
11

@PALKUMARI_PATEL

Yes you need you IT team…the can create an azure app and give credentials to you…the same process on what permissions are needed and all is there in the documentation

Other way is integration services…you can go to orchestrator and if integration services are enabled in your orchestrator then you can go to that page and select office 365 connector and it would ask you for credentials…check the same

Cheers

12

Hi @Anil_G Thanks I will ask IT to help in this but why I am getting that admin approval list ? Is it something relate to IT or who handles AZURE ? Do I need to contact Azure admin ?

13

@PALKUMARI_PATEL

You can contact your sharepoint team
If you want to use integration services

But if your organization has an azure …then you can contact your azure admin…and he would have access to create an azure app with required creds…

That can be used…for unattended bots…you need to ask them to give application role and ehat all roles under it are required is provided in the above doc…they eould need to provide client id client secret and tenant id …so that you can provide them in microsoft application scope

Hope this helps

Cheers

14

Thanks @Anil_G Can you share me a sample flow with all activities Properties that I need to use sharepoint folder’s file ? It will be very helpful If I confused at some point.

Thanks you

15

I am able to setup Azure application and Able to use via o365 app scope. Can someone help me to figure out how can I get file names within that folder in sharepoint ?

DriveItem.Name.ToString.Contains(“ABC”) ----- this is giving me true or false only. I want to use and drop files within this folder.

16

@PALKUMARI_PATEL

You can use for each file in folder

Or driveitem.Name actually gives the name

Cheers

1 Like
17

Hi @Anil_G Driveitem is just giving the names.

I tried for each file in a folder but it is just trying to find the folder sand file within that project only. How can I use path of sharepoint to get those files ?

Also How Can i move , Access , copy sharepoint files ?

Thanks

18

@PALKUMARI_PATEL

Okay now i got it…

So say you aregettingn a drive item usign find files and folder…then that drive item is to be used in all thsoe activities you mentioned ypu move…copy…download or upload activities…

Basically find files will give your the drive item which can be used further in almost all activities to access that file or folder

Hope this helps

Cheers

1 Like
19

I tried but not getting the proper logic to reach to any particular file. Can you please provide me an sample flow? It will be a great help.

Thank You

20

@PALKUMARI_PATEL

Please check

image
image442×717 21.7 KB

SampleOffice365.xaml (9.8 KB)

cheers

1 Like
21

Thanks but giving me below Error.

Find Files And Folders: Code: itemNotFound
Message: The provided path does not exist, or does not represent a site
Inner error:
AdditionalData:
date: 2023-04-27T19:35:46
request-id: fa4c6228-1c24-44fd-afb3-e56084fba458
client-request-id: fa4c6228-1c24-44fd-afb3-e56084fba458
ClientRequestId: fa4c6228-1c24-44fd-afb3-e56084fba458

22

@PALKUMARI_PATEL

Can you please show how you gave the details…

Did you replace all values properly?

Cheers

1 Like
23

Yes, I did.

image

“https://xyz.sharepoint.com/:f:/r/sites/Team_xyz/Documents/www - 000/mmm/DSS/2023/DSW Robotic Dumps/ggg/ABC 2023-02-01.xlsx”

Drive name = documents

24

@PALKUMARI_PATEL

Site url - https://xyz.sharepoint.com/sites/Team_xyz/

And for folder basically you need to give from root document you see on sharepoint top left…after docuemnts

it looks like this Documents > folderA > Folder B > Folder C

File1.xlsx

cheers

1 Like
25

Yes, those are the folders . I give folder names only. Still getting error.

26

@PALKUMARI_PATEL

Please check the slashes at the end and start

SomeFolder/Folder2/Folder3 No slashes at both ends

And also is your authentication proper?

did you try any activity successfully?

cheers

1 Like
27

Checked slashes and looks ok. I have tried for each file and folders and throught hat able to get folder names. but not sure how can i get file names.

Folder name : DriveItem.Name

28

I able to get file names . Now getting trouble to downloads specific file and apply filers , move file to sharepoint from local folder or write data into sharepoint file using Write range workbook.

Getting below Error while trying to upload files :
Upload File: Code: BadRequest
Message: /me request is only valid with delegated authentication flow.
Inner error:
AdditionalData:
date: 2023-05-02T20:21:13
request-id: feffa4ba-6ab9-4ddb-bdac-6fbfc98a67ab
client-request-id: feffa4ba-6ab9-4ddb-bdac-6fbfc98a67ab
ClientRequestId: feffa4ba-6ab9-4ddb-bdac-6fbfc98a67ab
can someone help me here ?

29

Thanks @Anil_G For helping on the issue. Working absolutely fine.

1 Like
30

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