Answered

Need help to create flow in moving data from sharepoint to azure blob using powerautomate.

(1) Share

Report

Posted on by ankit25269697

Hi Folks,

I need help in creating a flow to move data from sharepoint folder to Azure blob container. but sharepoint folder contains Excel file which has spaces in the file name e.g Sample (1).xlsx I want the file name in the Azure Blob should not contain spaces e.g Sample(1).xlsx. at last, after successfully moving data, the file should be deleted from sharepoint folder.

Regards,

Ankit

Categories:

Building flows

I have the same question (0)

All responses (15)

Answers (1)

abm abm 32,865 Most Valuable Professional on at

Like (0)

Report

Hi @ankit25269697

Not sure what trigger you are using for your requirement. Here I have used a manual trigger.

My file is SharePoint document library:

Here above compose action step I used the below expression to remove unwanted spaces

replace(trim(outputs('Get_file_metadata_using_path')?['body/DisplayName']),' ','')

Here is my blob container after running the flow.

Thanks

Was this reply helpful? Yes No
ankit25269697 40 on at

Like (0)

Report

Hi @abm,

Thank you for the solution, can you please tell me, Instead of single file what need to be done if we have a folder from where we are moving the file from share point to azure blob. also need automatic trigger to trigger flow whenever file is uploaded into the sharepoint folder.

Was this reply helpful? Yes No
ankit25269697 40 on at

Like (1)

Report

currently using get file metadata action we can only use single file my scenario is we have folder in which we have multiple files. please provide the soln for this it'll be a gr8 help.

Was this reply helpful? Yes No
abm abm 32,865 Most Valuable Professional on at

Like (0)

Report

Hi @ankit25269697

Are you looking for when a new file is created in a folder or from a folder read all the files and move to Azure? What's your trigger?

Was this reply helpful? Yes No
ankit25269697 40 on at

Like (0)

Report

Hi @abm,

Scenario - Tt is a shared folder so anyone can upload the file into that sharept. folder and whenever someone uploaded a file then it should trigger the flow automatically.

Was this reply helpful? Yes No
ankit25269697 40 on at

Like (0)

Report

Hi @abm ,

I think trigger for this case will be "when file is created or modified in a folder". not sure though.

Was this reply helpful? Yes No
abm abm 32,865 Most Valuable Professional on at

Like (1)

Report

Hi @ankit25269697

Try the below and let me know.

Exrpression I used above is

replace(trim(triggerOutputs()?['body/{Name}']?['body/DisplayName']),' ','')

Thanks

Was this reply helpful? Yes No
ankit25269697 40 on at

Like (1)

Report

Hi @abm ,

showing this error.

Was this reply helpful? Yes No
ankit25269697 40 on at

Like (0)

Report

Hi @abm ,

it is showing the above error for the "get file content" action.

Was this reply helpful? Yes No
Verified answer

abm abm 32,865 Most Valuable Professional on at

Like (1)

Report

Hi @ankit25269697

I messed up the id's there. Here it is. It should work.

Above compose expression is as follows:

replace(trim(triggerOutputs()?['body/{FilenameWithExtension}']),' ','')

Let me know how you get on.

Thanks

Was this reply helpful? Yes No