Filter out MS Teams Shift Request Reason from Array

[AcroPhat_Tech]

Hello all,

I am attempting to filter out the list of Time Off Reasons for MS Shifts Time Off Requests and only include, in an email, the reason string of the Reason selected in the Time Off request.

Connectors and Definitions page: https://docs.microsoft.com/en-us/connectors/shifts/#definitions

Currently the flow is setup to send an email which is triggered with any request that is created, updated, or deleted. I am in need of finding a way to filter out the reason display text based on the reason ID from the Reasons Array. Thank you 🙂

Screenshots or source code can be provided. 

[fchopo]

Hello @AcroPhat_Tech 

Have a look at this post I wrote some time ago: Re: Time off Time off reason id to the reason Labe... - Power Platform Community (microsoft.com)

Hope it helps!

Ferran

[AcroPhat_Tech]

Hello @fchopo ,

Can you provide clarification to this step please? I'm having trouble understanding what to place into the filer array fields. I'm unable to find the 'sharedTimeOff" dynamic expression.

EDIT****** I got the array filtering setup now! Now I'm having trouble with placing just the display name from the filter array body and placing it into another variable. 

[fchopo]

Hello @AcroPhat_Tech 

After the filter array, you could select the first element, and the choose the correct field. Maybe you could execute your flow and have a look at the output of the filter array to look up for the value you want. In any case, you could use "set variable" or "compose" action and enter a similar expression:

first(body('filter_array'))['shareTimeOff']?['timeOffReasonId']

Hope it helps!

Ferran

[AcroPhat_Tech]

Thank you for the response @fchopo  Should it really be looping through 100? We have less than 15 reasons for time off.

[fchopo]

Hello @AcroPhat_Tech 

You could store the 15 reasons in an array variable at the beginning of the flow, and in each "apply to each" request item you should only do a search within this 15 elements.

Hope it helps!

Ferran

[AcroPhat_Tech]

Hello @fchopo ,

I was able to filter out the reason using a filter array & select function. I put the 'Reason' displayName into a select table and placed the output of the select into a variable which displays in my email. However, it shows the following. Do you know how I could remove the fluff and just have it show up as Reason: PTO?

[fchopo · Accepted solution]

Hello @AcroPhat_Tech 

You could add a Parse JSON action:

Generating the schema from the sample you shared and using the expression:

first(body('parse_json'))?['reason']

Hope it helps!

Ferran

[AcroPhat_Tech]

Thank you @fchopo for your assistance on my inquiry! I truly appreciate it!

[Anonymous]

Hey @fchopo ,

I've been trying to use your post to solve a similar issue. I am having the same problem where I cannot find "sharedtimeoff" When trying to filter. Any assistance would be greatly appreciated!

-Alex

[fchopo]

Hi @Anonymous 

Could start a new thread in the forum with your question, as this one is marked as "solved"? Moreover, that will help other users as well.

Regards,

Ferran

[nwilliamson00]

within the Json code you posted, what was the rest of the schema code please

[Automata-BBAU]

Can you explain it a bit further? I don't get where that Reason:PTO is coming from and getting any data.

Will I be able to get the exact type of Reason with this, like "Sick day", "Unpaid", "Maternity leave" and so on?