cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
PowerAutomate3
Helper I
Helper I

Combining csv/text and removing rows/lines containing a string

Hello!

 

Is it possible to:

 

1) combine csv/text files by appending them?

2) remove rows/lines in csv/text that contain a specific string?

 

Thanks!

1 ACCEPTED SOLUTION

Accepted Solutions

Hi @PowerAutomate3 :

I've made a test for your reference:

vbofengmsft_0-1634522670704.png

vbofengmsft_1-1634522732798.png

vbofengmsft_2-1634522750987.png

BTW,If there a a lot of files in your folder,you'd better set the “list files in folder”action otherwise it will lose data.

vbofengmsft_3-1634522818219.png

vbofengmsft_4-1634522895392.png

Best Regards,

Bof

 

 

View solution in original post

4 REPLIES 4
v-bofeng-msft
Community Support
Community Support

Hi @PowerAutomate3 :

I'v made a test for your reference:

1\I assume there are two files

vbofengmsft_5-1634192496593.png

 

vbofengmsft_1-1634192310898.png

2\My flow

vbofengmsft_4-1634192429764.png

 

The Result:

vbofengmsft_3-1634192417515.png

Best Regards,

Bof

 

PowerAutomate3
Helper I
Helper I

@v-bofeng-msft thanks that's great!

 

But how can I parse the files found by a Get File (Properties Only) and concatenate all of them?

 

Thanks!

Hi @PowerAutomate3 :

I've made a test for your reference:

vbofengmsft_0-1634522670704.png

vbofengmsft_1-1634522732798.png

vbofengmsft_2-1634522750987.png

BTW,If there a a lot of files in your folder,you'd better set the “list files in folder”action otherwise it will lose data.

vbofengmsft_3-1634522818219.png

vbofengmsft_4-1634522895392.png

Best Regards,

Bof

 

 

View solution in original post

@v-bofeng-msft  thanks but I am having trouble to do that for Sharepoint. What is the sequence of steps? 

 

I have a Sharepoint folder with thousands of files and I want to get only the ones created today which are also thousands and combine them.

 

Can you outline please the steps and if there is any special setting/code? I suppose I will be able to figure out how to build them.

 

Thanks!

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Users online (3,044)