cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
New Member

Filtering the Gallery over field updated by Office365Users()

Dear All,

I have a CDS Entity with two columns: EmployeeEmail and Comment. 

My Gallery displays information on each employee using Office365Users() functions. One of the information field includes Out-Of-Office message using:

 

Office365.GetMailTips(EmployeeEmail).AutomaticReplies.Message

 

I want to filter and show only the records that show Automatic Reply. I used a control checkbox that has value=true if above message is not blank and wanted to filter the records over the value of the checkbox. However Filter function informs me that it does not work while recurring to the record item.

 

What is the way to do that?

 

Thanks and regards

Peter 

1 REPLY 1
Highlighted
Resolver III
Resolver III

I just made a quick test which showed only those with automatic reply message not blank

 

Filter(
Table(
Office365.GetMailTips("email1"),
Office365.GetMailTips("email2"),
Office365.GetMailTips("email3")),
!IsBlank(AutomaticReplies.Message))

 

Maybe that will help

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

News & Announcements

Community Blog

Stay up tp date on the latest blogs and activities in the community News & Announcements.

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Community Highlights

Community Highlights

Check out the Power Platform Community Highlights

Top Solution Authors
Top Kudoed Authors
Users online (9,031)