This is the only version of the email I have created at this point. I was thinking it might be easiest to create 4 different email branches based on the results of that flow step. Can you confirm I guessed right?Īs previously mentioned, after the Get item step I need some kind of test to see if the Shipping Method value starts with UPS, FedEx, Courier or Other so I can send the emails appropriately. I wasn't completely sure whether to use Get item or Get items. As previously mentioned, I'm not sure how to modify the trigger based on "Shipped" status. I can try Googling it over the weekend, but if you have any advice I would appreciate it. I have quite a few columns in my SharePoint list so I would like to only bring back the ones I need for the flow. Is that the correct one to use? I don't want the flow to run every time, only when the Status is equal to Shipped so how do I need to modify the trigger to ensure that happens? The first time the notification is sent it should be done only OnSuccess of the Power Apps form so I am currently using the "When an item is created or modified trigger". The staff member scans the shipping label barcodes, confirms the Shipping Method requested by the user hasn't changed, changes the Status to Shipped and finally clicks the blue button to send the email confirmation to the user. Here is what my Logistics Team Member Screen within the Shipping app looks like. Our employees haven't had tracking info sent to them to date much less the generic tracking site link so I think they will view this as a vast improvement. ![]() Since there are sometimes going to be multiple tracking numbers for a given request I'd rather avoid an overly complex situation and just provide a link to the generic tracking site. I can customize the messages for each scenario. I would like to add a check for the Shipping Method to send out 1 of 4 emails based on whether whether the Shipping Method starts with UPS, FedEx, Courier or Other. I really appreciate Super Users like yourself helping the Community Members overcome final phase hurdles.Īfter working on the flow a bit more I decided to simplify my original request. Since I'm a beginner I was wondering if you could take a look at the screenshots and text I have below and give me the advice I need to complete the flow. I hope this solution helps someone Prasad, STEP 6: I was able to use "is equal to" for Courier and Other. I crafted an email for the Yes and left the No blank. I then entered UPS and FedEx in each of the respective condition steps. ![]() 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. STEP 5: Add however many parallel conditions you need (I had 4). Enter dynamic content of ID and TriggerWindowStartToken. STEP 4: Insert a new step "Get changes for an item or a file (properties only). 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 3: Click the ellipsis dots in the upper right-hand corner (see screenshot above) and click on Settings to access this pane. ![]() STEP 2: Select the trigger "When an item or a file is modified" and map your site address and list. STEP 1: Turn on versioning settings in your Sharepoint list. These steps assume a basic knowledge of Power Automate. I am posting the steps here for anyone else who might benefit. When I click on the url it dynamically takes me to the specific detail screen. The email has the text "The tracking number is: 123XYZ456LMO." The tracking number is made up, but you get the idea. 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. If(StartsWith(, "UPS "), "CLICK HERE to track your UPS shipment(s).", StartsWith(, "FedEx "), "CLICK HERE to track your FedEx shipment(s)") ![]() I have a status pop-up screen on the home page. In the Power App I leverage the StartsWith function. I'm a rank beginner in Power Apps so I would appreciate your advice. As you know, there are many different shipping options for each carrier so I'm wondering how best to handle that in Power Automate. 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. I am working on a Shipping Request Power App.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |