Answered

Approval Workflow for Time Off Calendar

(0) Share

Report

Posted on by defiant79

Hello,

Working on a flow for our department. I have a form setup for users to fill out a time off request, and the flow takes those answers and sends an approval email to department managers for approval. Once approved entries get placed into the teams various calendars.

I want to take the approval email one step further. Initially I setup a few steps to pull a list of calendar event for the same date range of the time frame entered on the form and create a table. Idea being that the managers could approve/reject directly from the email without having to verify there are no current time off entries on the calendar already. The approval email doesn't format HTML/Tables so it inserts a jumble of table code. I am using a simple setup in the calendar subject lines only:

FirstName LastName - Shift - Team - Hours taken

So I'd like to just pull the subject line and insert each subject line for each time off request currently on the calendar. So basically the approval email would have this at the bottom:

List of current approved time off requests during these days:

FirstName LastName - Shift - Team - Hours taken

If there are no entries then, there would be nothing there. For the current HTML table I'm using an array variable, not sure if there is a better option to pull the subject lines only for each entry?

Thanks!

Categories:

Process mining

I have the same question (0)

All responses (5)

Answers (1)

Sort by

DamoBird365 8,942 Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @defiant79

If you have an array of this data, you might want to explore create an html table action.

It can create a table based on all fields from your array source, but equally you can define your own columns. This can then be inserted dynamically into your send email action.

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Cheers,
Damien

Was this reply helpful? Yes No
defiant79 10 on at

Like (0)

Report
Copy link

Link copied!

Thats the path I went down first. Issue is then I'm wanting to insert this in the approval workflow. That email doesn't format HTML and ends up sending something like this out in the approval email:

List of current approved time off requests during these days:
<table><thead><tr><th>Name:</th></tr></thead><tbody></tbody></table>

So I'm thinking of just scrapping that whole section, if there is a way to simply pull the subject line of the calendar entry (store it in something) and then insert said subject line for each event found in the date range of this request.

Was this reply helpful? Yes No
Verified answer

DamoBird365 8,942 Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @defiant79

Approvals use markdown, so presumably don't support html - i've not checked.

If you want to create a formatted list of items, you can initialize a string variable and then in the apply to each on the array, append string to variable action on the fields you require with a return line. The output from that will be the 1 or many lines of the requests off.

Hope that makes sense and let me know how you get on.

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Cheers,
Damien

Was this reply helpful? Yes No
defiant79 10 on at

Like (0)

Report
Copy link

Link copied!

Ok, so that is closer than I have been. For my test of have 2 entries on the calendar already. It is taking each one and appending to the end of the next one in a run on sentence. Can I use a line break some place to place each entry on a new line?

Current flow:

I inserted this on the approval email details:

Then this is a screen snip of what was in the approval email:

Was this reply helpful? Yes No
defiant79 10 on at

Like (1)

Report
Copy link

Link copied!

Nevermind, a simple carriage return in the append to string is all I needed.

Thank You!

Was this reply helpful? Yes No