Forum Discussion
Split column based on multiple delimiters
Mellissa Perez Run Power automate flow on item creation and/or item update (as per your requirements).
Then perform trim operations as mentioned above in power automate flow using flows expressions (similar functions like substring, indexOf are available).
Save back the trimmed result to SharePoint list using update item action. You can add trigger condition to avoid infinite flow running loop - condition based on whether > is found in the column value.
You can also try calculated column approach to create a new column based on the existing column ( having values with > ). But, you might not be able to use the calculated columns in the SharePoint lookups.
Please click Mark as Best Response & Like if my post helped you to solve your issue. This will help others to find the correct solution easily. It also closes the item. If the post was useful in other ways, please consider giving it Like.
Mellissa Perez If you need trimmed data for later use as mentioned in above post, you will have to trim the data at source before adding to SharePoint list. How you are adding date to SharePoint list, manually/programmatically/excel import/using Power apps?
Or if you have already added data to SharePoint list, you can try running Power automate flow, do trimming operations in flow using expressions and save the trimmed results back to SharePoint list using update item action with SharePoint connector in power automate flow.
Please click Mark as Best Response & Like if my post helped you to solve your issue. This will help others to find the correct solution easily. It also closes the item. If the post was useful in other ways, please consider giving it Like.
Hi and thank you. Unfortunately the data cannot be trimmed before adding to the sharepoint list. The idea is that 1. that datafield could be used to look up another value on a separate sharpeoint list and 2. both values would be added to a microsoft work template. This template will be converted to a pdf.
Mellissa Perez Run Power automate flow on item creation and/or item update (as per your requirements).
Then perform trim operations as mentioned above in power automate flow using flows expressions (similar functions like substring, indexOf are available).
Save back the trimmed result to SharePoint list using update item action. You can add trigger condition to avoid infinite flow running loop - condition based on whether > is found in the column value.
You can also try calculated column approach to create a new column based on the existing column ( having values with > ). But, you might not be able to use the calculated columns in the SharePoint lookups.
Please click Mark as Best Response & Like if my post helped you to solve your issue. This will help others to find the correct solution easily. It also closes the item. If the post was useful in other ways, please consider giving it Like.