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

copy filenames from sharepoint to Excel list

Hello,

 

I want to add a rows in an Excel list, when a file is created in sharepoint.

The problem is, that the folder names get copied as well.

The files are in many subfolders, but only files needs to be added to the Excel list. 

Screenshot Flow.jpg

 

Do you have any ideas to fix this?

Thank you in advance.

 

Enrico

11 REPLIES 11
DamoBird365
Super User
Super User

Hi @Enrico1109 

 

You can use lastindexof() on / to detect the last occurence of / and then use substring() to define the starting point of the substring from the path you have.

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Cheers,
Damien


P.S. take a look at my new blog here and like & subscribe to my YouTube Channel thanks 😉

Gericom
Resolver II
Resolver II

Hi Enrico

 

Can you upload a output  and the English name of the actions because i only get the file name with the same actions as you 

 

with kind regards

--------------------------------------------------------------------------

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up

Hi @DamoBird365,

I have absolutly no idea what you mean :D.

Can you give me a Screenshot how it needs to look like?

Thank you

I cannot change the name in Englisch but I can translate it.

 

Trigger: When a file is created (only properties)

Action: Add a row to a table


Do you need the Output from the Trigger or the Action Input?

Thank you

Gericom
Resolver II
Resolver II

from the action please 

Gericom
Resolver II
Resolver II

and @DamoBird365  means something like this 

Gericom_0-1622122146026.png

 

with kind regards

--------------------------------------------------------------------------

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up

 

Enrico1109
Helper I
Helper I

@Gericomsorry for the late reply. I´m pretty busy atm

 

This one ist the Action Input:

Enrico1109_0-1622544706696.png

And this one the Action Output:

Enrico1109_1-1622544783583.png

Thank you

Gericom
Resolver II
Resolver II

Hi @Enrico1109 

 

Can you please give me a example what the input is and what you expect 

because if you use the function you get your result or not ?

 

with kind regards

--------------------------------------------------------------------------

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up

@Gericom 

 

If I add an file in a folder it needs to be added in a Excel table.

Lets say I have a mainfolder. In this folder every new created file needs to be added in an excel table.

If I create another folder in the main folder with more files in it, then only the files (. docx .xls) needs to be added in the table.

Right now all the files and folders in the main folders get added in the excel table.

 

Thank you for your time and help.

Gericom
Resolver II
Resolver II

Hi @Enrico1109 

this is a example af what you want to do 

Gericom_0-1622556744236.png

with kind regards

--------------------------------------------------------------------------

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up

 

@Gericom 

It says the following invalid template:

 

Enrico1109_0-1622798646205.png

 

in English:

Template language expressions in the entries of the action "row_to_add_table" in row "1" and column "30875" cannot be processed: The template language function "lastIndexOf" expects a parameter of the type "string" as the second parameter. The specified value is of the type "integer". Details on the syntax can be found at https://aka.ms/logicexpressions#lastindexof..

 

Hope you can help me :).

Thank you

 

Kind regard
Enrico

 

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!

Welcome Super Users.jpg

Super User Season 2

Congratulations, the new Super User Season 2 for 2021 has started!

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Top Solution Authors
Users online (2,600)