Unanswered

Shifts - Send an Email - display date and start and end times

(0) Share

Report

Posted on by Gerard2

Hi all, Just wondering what a SHIFTS build would look like - I want to send an email with a roster of whose working on what days and at what times. E.g. Mon, Tues, Wed, Thurs, Fri John Citizen - 9-5. 9-5. 9-5 Starting again from scratch Thanks

Categories:

Building flows

I have the same question (0)

All responses (13)

Answers (0)

Expiscornovus 33,181 Most Valuable Professional on at

Like (0)

Report
Re: Shifts - Send an Email - display date and start and end times

Hi @Gerard2,

You could use a list all shifts action and extract the data from that action. This action also supports a start and end date filter. So, you could filter it from Monday 09 till Friday 5.

Below is an example of that approach.

With this example it runs every week on Monday morning. This way you can use the utcNow function in the filter with the following expression for the end time of Friday 5 PM:

addDays(utcNow('yyyy-MM-ddT17:00:ssZ'), 5)

Was this reply helpful? Yes No
Gerard2 77 on at

Like (0)

Report

Re: Shifts - Send an Email - display date and start and end times

Are you able to write out there expression for utcNow? I also can’t see the dynamic content ‘Value’ when trying to add to the Select operation. Thanks for your help, G

Was this reply helpful? Yes No
Expiscornovus 33,181 Most Valuable Professional on at

Like (0)

Report
Re: Shifts - Send an Email - display date and start and end times

Hi @Gerard2

The expression for the From Start Time field is:

utcNow('yyyy-MM-ddT09:00:ssZ')

In the Select in the From I used:

body('List_all_Shifts')['value']

In the key value mappings I used.

item()?['id'] item()?['userId'] item()?['sharedShift']?['startDateTime'] item()?['sharedShift']?['endDateTime'] item()?['sharedShift']?['displayName'] item()?['schedulingGroupId']

Was this reply helpful? Yes No
Gerard2 77 on at

Like (0)

Report
Re: Shifts - Send an Email - display date and start and end times

So I don’t seem to be getting dynamic content for Shifts that’s called value - wouldn’t that be based on the ‘List all shifts’ trigger?

Was this reply helpful? Yes No
Expiscornovus 33,181 Most Valuable Professional on at

Like (1)

Report

Re: Shifts - Send an Email - display date and start and end times

Hi @Gerard2,

What I shared in my last reply are all expressions which you should be able to copy paste into the tab next to the Dynamic content tab, the Expression tab.

It should not really matter that the field is not showing up in the Dynamic content list.

Was this reply helpful? Yes No
Gerard2 77 on at

Like (0)

Report

Re: Shifts - Send an Email - display date and start and end times

Awesome - I’ll give the at a go - thanks so much

Was this reply helpful? Yes No
Gerard2 77 on at

Like (0)

Report

Re: Shifts - Send an Email - display date and start and end times

Hi, Thank you for your help so far - I’ve added all the formulas you recommended however when the fLow is triggered - there is not output of shifts even though I updated unit, It seems like Lifts all shifts is not generating any days - the only output I see is []

Was this reply helpful? Yes No
Expiscornovus 33,181 Most Valuable Professional on at

Like (0)

Report

Re: Shifts - Send an Email - display date and start and end times

Hi @Gerard2,

With what data were you testing? Can you by any chance share a screenshot of the shifts you were expecting in the list all shifts action? (obfuscate/blur names where needed, obviously).

Just to double check, I assume you did share the shifts with the team?

Was this reply helpful? Yes No
Gerard2 77 on at

Like (0)

Report

Re: Shifts - Send an Email - display date and start and end times

I just had myself added to the group - I was just trying to add a few shifts and then trigger the flow so I could see the output but got what was in photos above - thanks for the help so far

Was this reply helpful? Yes No
Gerard2 77 on at

Like (0)

Report

Re: Shifts - Send an Email - display date and start and end times

Hi Expiscornovus,

Just wondering if you’re able to assist on this one - I’m not getting any output.

Thanks.

Was this reply helpful? Yes No