Split string

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hello all,

I want to extract just the name of the csv file without the extension in flow.

e.g. name.csv > name

Can someone guide on how I can achieve this using split function?

Thank you in advance!

Categories:

Building flows

I have the same question (0)

All responses (7)

Answers (1)

abm abm 32,985 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hi,

first(split('Test.csv','.'))

Thanks

Was this reply helpful? Yes No
abm abm 32,985 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hi @Anonymous

Here it is

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @abm

Thank you for your response.

I'm basically grabbing the file name from the trigger 'when file is created' and passing the name as a table name in list all rows action.

Is this even an option?

Was this reply helpful? Yes No
abm abm 32,985 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hi @Anonymous

What error you are getting? Also make sure the expression split is added under the Expression tab. I can see it is under the Dynamic Content.

Thanks

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

When I enter the FileName this is what the expression turns into.

first(split(variables('triggerOutputs()['headers']['x-ms-file-name-encoded']'),'.'))

The error is that the expression is invalid.

Best,
Annie Jamshed

Was this reply helpful? Yes No
Verified answer

abm abm 32,985 Most Valuable Professional on at

Like (2)

Report
Copy link

Link copied!

Hi @Anonymous

Please check my earlier post. Here I declared a variable called Filename then value as Test.csv. Then I used the split().

In your case you have

first(split(variables('triggerOutputs()['headers']['x-ms-file-name-encoded']'),'.'))

Not sure this is correct.

You can move the triggerOutputs()['headers']['x-ms-file-name-encoded'] under the initialise value part.

Then map the variable under the expression.

Thanks

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!

Hi @abm

It worked!

I was able to parse the name correctly but for some reason my flow is failing saying no table name was found even though the table exists with that name! 😞

I'll take that up on another thread though. Thanks for your help!!

Best,
Annie

Best,
Annie Jamshed

Was this reply helpful? Yes No