Currently I have 2 lists with a column called "Tracking#" on both lists and the idea is that I want to take for example "123344455" and extract the last 4 digits (in this case 4455) and use a create and update to dump the value into another column called "Tracking Last 4). Can anyone assist in how I would be able to achieve this?
Any further help is always appreciated.
Thanks,
y2kardell
@jinivthakkar @VJR thanks for the suggestion, but maybe I need to clarify exactly what is needed. The user fills out the shipping form columns in SharePoint with their name address, phone number....etc. In the mean time there are other columns called ' Tracking #' and 'Tracking (Last 4)'.
WhatI I am trying to accomplish is....when the approver goes back on to edit the initial request from the shipper to fill in the ' Tracking #' column with the FedEx tracking number - I need to somehow take that value whatever it may be and truncate it somehow to show the last 4 in the Tracking (Last 4) column in SharePoint.....so that when I choose Create/Update item action in Power Automate it will populate the Tracking # (Last 4) column in the SharePoint list. Hopefully this better clarifies things.
Hi @y2kardell
Multiple ways to do this.
Below is using in-built substring action.
Expression used:
sub(length(triggerBody()['text']),4)
The blue portion is the input from where your string is coming.
After running the process:
@y2kardell try this
--------------------------------------------------------------------------------
If this post helps answer your question, please click on “Accept as Solution” to help other members find it more quickly. If you thought this post was helpful, please give it a Thumbs Up.
Tomac
986
Moderator
stampcoin
699
Super User 2025 Season 2
Riyaz_riz11
577
Super User 2025 Season 2