web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Automate
Unanswered

Travel Order Number

(1) ShareShare
ReportReport
Posted on by 2

I'm trying to create a Microsoft form that employees can fill in to request for travel order number in the company. I want to automate the process so that every time an employee fills in the form the travel order number will be generated and will be e-mailed to their respective email. Actually I'm trying to figure out how to set the travel order number generated to have this format: 2024-I02-xxx (for example: 2024-I02-001, 2024-I02-002, 2024-I02-003, 2024-I02-004 and so on. Also, want that all generated travel order numbers will be automatically recorded and saved in an online excel file together with the input data of the employee in the Microsoft forms for monitoring. The information to be filled up by employees in the form are the following: travel start date, travel end date, destination, and purpose of travel however the manager wants these details to appear in the excel monitoring file: EE ID, Name of Employee, Travel Start Date, Travel End Date, Destination, and Purpose of Travel.

I'm currently seeking chat gpts help but it keeps on repeating its suggested correction which doesn't work. Now i dont know what to do.

Categories:
I have the same question (0)
  • abm abm Profile Picture
    32,865 Most Valuable Professional on at
    Hi
     
    See below
     
     
     
    Above use the Response Id from the trigger step. This will give you a unique number each time.
     
     
    Thanks

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 503 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 321 Moderator

#3
abm abm Profile Picture

abm abm 237 Most Valuable Professional

Last 30 days Overall leaderboard