Power Platform Community Forum Thread Details

Hi,

I want to send an email as shown below withing PowerApps. I however need help with some filtering.

On click of a button, I get the list of all email addresses in my “To:” field which is due to the collection.

I however want to use filter based on a choice column which would be fixed. In this case, I want it to just be “4Ws and HM” and not all the other choices.

In other words, when outlook is launched, I want only the emails with the Project_Category 4Ws and HM to populate in the To: Field

ClearCollect(mailfield,ShowColumns(NotifyApproveGO_ApproversList, "Email_Address"));
Launch("mailto:"&Concat(mailfield,Email_Address&";")&"?subject=Full Project Review - WYNTK and DO!&body=Dear PM, %0D%0A
%0D%0A
You have an approval document waiting for your review. 
%0D%0A 
%0D%0A
Kindly click on the link below to access your documents.
%0D%0A 
%0D%0A

https://apps.powerapps.com/play/e/47136398-fdbc-e395-9695-8120440850f6/a/934c0185-5f6b-4551-a508-28457210038f?tenantId=191b00ea-edcc-406c-8456-dc29abc0f10f&source=portal

%0D%0A 

Thank you, 
%0D%0A 
PMO Team")

Thank you very much

Dami

Categories:

Building Power Apps

Hi @damiosiks ,

You just need to filter it - also this will save a Collection "hanging around"

With(
 {
 wMailTo:
 ShowColumns(
 Filter(
 NotifyApproveGO_ApproversList,
 Project_Category.Value = "4Ws and HM"
 ),
 "Email_Address"
 )
 },
 Launch(
 "mailto:" & 
 Concat(
 wMailTo,
 Email_Address,
 ";"
 ) & 
 "?subject=Full Project Review - WYNTK and DO! body=Dear PM, %0D%0A
 %0D%0A
 You have an approval document waiting for your review. 
 %0D%0A 
 %0D%0A
 Kindly click on the link below to access your documents.
 %0D%0A 
 %0D%0A
 https://apps.powerapps.com/play/e/47136398-fdbc-e395-9695-8120440850f6/a/934c0185-5f6b-4551-a508-28457210038f?tenantId=191b00ea-edcc-406c-8456-dc29abc0f10f&source=portal
 %0D%0A 

 Thank you, 
 %0D%0A 
 PMO Team"
 )
)

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Visit my blog Practical Power Apps