Copying one Column Meta data to other column in same SharePoint library

[Raj3438]

Hello, I need help building Power to automate WF.

Copy of one Column Metadata to another column in the same SharePoint library. attached is an image for the column.

_PID metadata I need in the PID column. 

 

[#2]

When a new item is created? or something that's gonna loop through each time?

[#3]

@NicolasKheirallah I need only one time, I want to manually run workflow.

[#4]

Hi @Raj3438 , Based on your description, you can use the Manual trigger, then the action to get all list items without PID. For each item, you can use the split function to split the text in the _PID column by a dot.

https://learn.microsoft.com/en-us/power-platform/power-fx/reference/function-split

At the end, save the new value in the list item.