Answered

File name contains string and Save from Sharepoint to OneDrive

(0) Share

Report

Posted on by NewGuy86

Im very green to PA and having zero luck finding posts or youtube videos that can spoon feed the solution. I built a flow that works but need an enhancement.

What works is "get file content" from SharePoint and "creating file" to my OneDrive. But since the file gets updated and the file name changes, like from "02.22.2024 Vendor List" to "02.28.2024 Vendor List" I want it to look for a file name that contains "Vendor" and save it to OneDrive.

Additionally, the file I want to choose that contains "Vendor" resides in a folder that has other files I don't want to copy.

I appreciate your time reading my problem!

Categories:

General topics

I have the same question (0)

All responses (3)

Answers (1)

SudeepGhatakNZ 14,394 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

@NewGuy86

Upon reviewing your flow logic, it appears that you are essentially transferring a file from SharePoint to OneDrive.

Could you provide a detailed explanation of the use case, perhaps broken down into steps? This will help in understanding the purpose and workflow more thoroughly.

Was this reply helpful? Yes No
NewGuy86 11 on at

Like (0)

Report
Copy link

Link copied!

On a weekly basis a file is uploaded into a SharePoint folder. The name of file changes but always includes "Vendor". There are other files in the folder but I want to copy the file that contains "Vendor" in the file name to my OneDrive each week.

Was this reply helpful? Yes No
Verified answer

NewGuy86 11 on at

Like (0)

Report
Copy link

Link copied!

Solved my problem. Here is the flow and necessary entries for each.
Get Files (Properties only)
Filter Query: substring('name',FileLeafRef) Replace name with word or phrase that file name contains.
Library name is the folder the file exists.

For Each: is SharePoint Body/Value
Get File content using path
File Path: SharePoint Full Path

Create File: File Content = SharePoint File Content

Was this reply helpful? Yes No