Answered

Search for a file in specific folder on Ondedrive with dynamic parameter and attach it to email

(0) Share

Report

Posted on by JB2511

Hello

I try to write an automated flow in which it should search in a given path on onedrive the specific weeknumber

Files are word files and syntax of the name contains YEAR and Weeknumber eg. 202251

For the given weeknumber based on the day of the flow it should go and look for the given file (note there is only one file in the folder which will be named xxxxxx202251.docx

Then this file should consequently be attached to the email

Can someone help me pls ?

Categories:

General topics

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

v-chengfen-msft on at

Like (0)

Report

Hi @JB2511 ，
Here is a test for you reference：
Flow will execute every day, find the file in the folder according to the year and number of the week, and send the file as an attachment

Best Regards
Cheng Feng

Was this reply helpful? Yes No
JB2511 2 on at

Like (0)

Report

Hello thanks for the solution all be it that year function is not returning the correct value but solved it this way :

int(formatDateTime(utcNow(),'yyyy'))

Kind regards

Was this reply helpful? Yes No