Unanswered

Copy first 4 characaters of SharePoint list column to another column

(0) Share

Report

Posted on by loukr55

Hi There,

Hopefully someone can help. I have found many examples online of flows being able to copy data from one column to another using Power Automate, however my requirement is slightly different. I only need to copy the first 4 characters. With our current list we use a calculated column with the formula "=LEFT(Title,4)". Can this be integrated with Power Automate? We need to avoid using a calculated column as it is causes issues elsewhere.

I need to create a flow that will copy column 1 into 2 as below:

column 1	column 2
abc123	abc1
acb432	acb4

Is there any way to do this? Any help is appreciated.

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (0)

SantoshSarnobat 30 on at

Like (0)

Report

yes, you can use slice function
slice("abc123", 0,4)
result = abc1

Was this reply helpful? Yes No
MarkoKrstanovic 97 on at

Like (0)

Report

Hi,
Sure you can!
You can do that by using expression substring.
Here is an example:
In this case: I am using substring when new item is created in list substring will take column Title and return only first 4 chars.
substring(triggerOutputs()?['body/Title'],0,4)

BR Marko

Was this reply helpful? Yes No
loukr55 2 on at

Like (0)

Report

This works well for new items created in the list - is there anyway to get the flow to update all the existing entries in the list?

Was this reply helpful? Yes No