68|POWERAUTOMATE – Auto Authorizing

BYU Student Author: @Christian
Reviewers: @TylerBooth, @Parker_Sherwood
Estimated Time to Solve: 20 Minutes

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:

  1. The initial costs were no more than $1,000 and
  2. 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!

Data Files

Suggestions and Hints

Possible actions to include:

  • Launch Excel
  • For Each Loop
  • If statement
  • Write to Excel
  • Add to datetime


These are the approval dates I got!

1 Like

Here are my answers

Here are my results!

Here are my results!