Unanswered

Copy part of a file name to another column

(0) Share

Report

Posted on by Edward_Hyde

Hi,

I'm completely new to Power Automate. I've managed to build a small flow, which sends out an e-mail if a specific column is changed and I see the vast possibilities PA offers.

Now I need to copy part of a name of a file to another column, when a file is uploaded. As "easy" as the first task was, this is way too complicated for me, and I have no idea how to achieve this. The name is separated by underscores, which makes it pretty easy to work with and I need the part of the name, which is between the 1st and 2nd underscore.
To complicate masters: the environment I'm working in seems to be very sluggish, as PA often doesn't find the libraries of a given SP and same goes for other functions.
That aside, where can I find how to build this flow or flows in general. I love to learn 🙂

Best,
Edward

Categories:

Building flows

I have the same question (0)

All responses (5)

Answers (1)

Verified answer

abouchaalaBAIT 932 Moderator on at

Like (1)

Report

Hello @Edward_Hyde

You can split the name and get the second part using this expression :

split(<ReplaceYourNameHere>,'-')[1]

Exemple of the final results :

Once you store the value in a Compose action or a variable, you can update the sharepoint item with the new retrieved value

Hope this helps

----------------------------------------------------------
If I have answered your question, please mark your post as Solved. 🆗✔️
If you like my response, please give it a Thumbs Up. 👍
You can accept more than one post as a solution.

Was this reply helpful? Yes No
Edward_Hyde 34 on at

Like (0)

Report

@abouchaalaBAIT So, I'm not sure, why automate adds the "for each" part to some of the functions.
But this seems to cause an error, which I have no idea how to handle.

INC Flow.png

Was this reply helpful? Yes No
abouchaalaBAIT 932 Moderator on at

Like (1)

Report

@Edward_Hyde can you screenshot all the workflow from the beginning please ?

try to delete recently added action, save and open with classical designer, add them again and test.

----------------------------------------------------------
If I have answered your question, please mark your post as Solved. 🆗✔️
If you like my response, please give it a Thumbs Up. 👍
You can accept more than one post as a solution.

Was this reply helpful? Yes No
Edward_Hyde 34 on at

Like (1)

Report

@abouchaalaBAIT I just started from the beginning. Worked like a charm. Thank you very much. Just to satisfy my curiosity: is this a known bug within the new composer/designer?

Was this reply helpful? Yes No
abouchaalaBAIT 932 Moderator on at

Like (1)

Report

it's not a bug but you have to make sure to activate the split On inside the trigger settings, now you know 🙂

Was this reply helpful? Yes No