Hello,
I am working on a Shipping Request Power App. When the Logistics Team presses a button to send a shipping confirmation to the user, I would like the email notification to include either the UPS or FedEx tracking number link in the body of the email depending on how the item was shipped. As you know, there are many different shipping options for each carrier so I'm wondering how best to handle that in Power Automate. I'm a rank beginner in Power Apps so I would appreciate your advice.
In the Power App I leverage the StartsWith function. Does Power Automate have that function?
I have a status pop-up screen on the home page. The OnSelect property of the button is:
If(StartsWith(ddShipMethodLS.Selected.Value, "UPS "), Launch("https://www.ups.com/track?loc=en_US&requester=ST/"), StartsWith(ddShipMethodLS.Selected.Value, "FedEx "), Launch("https://www.fedex.com/en-us/tracking.html"))
The Text property of the button is:
If(StartsWith(ddShipMethodLS.Selected.Value, "UPS "), "CLICK HERE to track your UPS shipment(s).", StartsWith(ddShipMethodLS.Selected.Value, "FedEx "), "CLICK HERE to track your FedEx shipment(s)")
The icing on the cake would be to not only have it go to the generic tracking urls noted above, but actually have it "deep link" dynamically to the actual tracking profile as seen in a screenshot below of something I ordered online. The email has the text "The tracking number is: 123XYZ456LMO." The tracking number is made up, but you get the idea. When I click on the url it dynamically takes me to the specific detail screen.
Thanks in advance for your help!
Teresa
Hello Prasad,
I was able to figure out a solution. I am posting the steps here for anyone else who might benefit. These steps assume a basic knowledge of Power Automate.
STEP 1: Turn on versioning settings in your Sharepoint list.
STEP 2: Select the trigger "When an item or a file is modified" and map your site address and list.
STEP 3: Click the ellipsis dots in the upper right-hand corner (see screenshot above) and click on Settings to access this pane. Enter the expression shown in the Trigger Conditions field being careful to substitute your own column name (mine was Status) and Status Value (I have a SharePoint choice column, I chose the 'Shipped' value).
STEP 4: Insert a new step "Get changes for an item or a file (properties only). Map to your site address and list name. Enter dynamic content of ID and TriggerWindowStartToken.
STEP 5: Add however many parallel conditions you need (I had 4). For UPS and FedEx, I chose the dynamic field for the Shipping Method (a Choice column in my Sharepoint list) and chose the starts with option. I then entered UPS and FedEx in each of the respective condition steps. The UPS version is shown below. I crafted an email for the Yes and left the No blank.
STEP 6: I was able to use "is equal to" for Courier and Other.
Thank you for your help Prasad. I hope this solution helps someone else.
Teresa
Michael E. Gernaey
497
Super User 2025 Season 2
David_MA
436
Super User 2025 Season 2
Riyaz_riz11
244
Super User 2025 Season 2