Unanswered

Filter out MS Teams Shift Request Reason from Array

(0) Share

Report

Posted on by 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.

Categories:

Building flows

I have the same question (0)

All responses (12)

Answers (1)

fchopo 8,003 Moderator on at

Like (0)

Report

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

Was this reply helpful? Yes No
AcroPhat_Tech 10 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
fchopo 8,003 Moderator on at

Like (0)

Report
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

Was this reply helpful? Yes No
AcroPhat_Tech 10 on at

Like (0)

Report

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

Was this reply helpful? Yes No
fchopo 8,003 Moderator on at

Like (0)

Report

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

Was this reply helpful? Yes No
AcroPhat_Tech 10 on at

Like (0)

Report

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?

Was this reply helpful? Yes No
Verified answer

fchopo 8,003 Moderator on at

Like (0)

Report
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

Was this reply helpful? Yes No
AcroPhat_Tech 10 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

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

Was this reply helpful? Yes No
fchopo 8,003 Moderator on at

Like (0)

Report

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

Was this reply helpful? Yes No