We provide the solution to this challenge using:
- Power Automate
Need a program? Click here.
Keeping people from throwing a tantrum when they leave can be a very difficult thing. It’s too bad that when one of the assistant secretaries was fired, they threw a fit and ended up deleting key information about documented trips! The finance department needs that information to make sure that the employees are authorized to be reimbursed for the trip! Your task, should you choose to accept it as the lead financial consultant, is to restore the information that has been deleted at any cost!
The department head in charge of authorization told you that he would only authorize trips that met 2 criteria:
- The initial costs were no more than $1,000 and
- The length of the trip was no more than 1 day.
If the trip meets the criteria, create your solution to automatically write in ‘Yes,’ while if it doesn’t meet one of the criteria, to write ‘No’. The department head told you that any approved trip was approved 2 days after the request date, so add an additional step for this to be filled in. Since the man requesting the file hates empty cells, he has asked that if the trip is not approved, enter a ‘-‘ for the approved date.
Good luck, lead consultant!
Suggestions and Hints
Possible actions to include:
- Launch Excel
- For Each Loop
- If statement
- Write to Excel
- Add to datetime