Answered

Get any .csv file available in a SharePoint path.

(0) Share

Report

Posted on by DryMouse555

Hi,

I have a SharePoint location where new file will be saved everyday. The file name is different every time. I just want the Power Automate Cloud flow to get a csv file if it is available in that SharePoint location. How to do that?

Please help. Thanks

Categories:

General topics

I have the same question (0)

All responses (8)

Answers (1)

Sort by

DryMouse555 31 on at

Like
a
(0)

Report
Copy link

Link copied!

Just to be clear. The flow should go to the SharePoint folder and get any csv file that is available in that folder.

Was this reply helpful? Yes No
v-xiaochen-msft Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!

Hi @DryMouse555 ,

Please try this

substringof('.csv',FileLeafRef)

Best Regards,

Wearsky

Was this reply helpful? Yes No
DryMouse555 31 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi, After that step, I did a compose and selected "File name with Extension". I get the File name as output, how can I read the contents of this file?

Was this reply helpful? Yes No
v-xiaochen-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @DryMouse555 ,

Please try to use get file content action.

string(outputs('Get_file_content')?['body'])

Best Regards,

Wearsky

Was this reply helpful? Yes No
DryMouse555 31 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks a lot Wearsky,

So, before I was giving the file name in the get file content and reading the csv file, modifying headers and rows and generating a csv output.

Now, After I introduced for each method which has get file content and compose actions, I am not able to connect it with my old flow. Any suggestions?

Was this reply helpful? Yes No
Verified answer

v-xiaochen-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @DryMouse555 ,

I think you should put all actions (except for init variable) that process data in a loop 'For each'.

Initialize variable should before the loop and you can use 'set variable' or append to variable in the loop.

Best Regards,

Wearsky

Was this reply helpful? Yes No
DryMouse555 31 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi,
I have kept the "get file content" and "compose" in a apply to each. The output of compose is

Now, I took another compose outside of look and gave first compose as input, and I am seeing this result.

Updating Media
My concern is, why did the output changed? and I want to get the first compose output as the second one. I hope that make sense.

Thanks,

Was this reply helpful? Yes No
v-xiaochen-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @DryMouse555 ,

Have a good day.

This appears to be a new question. Please consider making a new post and describing it in detail.

Best Regards,

Wearsky

Was this reply helpful? Yes No