Power Platform Community Forum Thread Details

Struggling solving this and I have a suspicion I may need to create a flow for this.

I have two lists.

Contact Details: Contains PackageType(Choice), CompanyName(Text) and EmailAddress(Text)

Email Template: Is a email template I use to send emails to contacts. This contains PackageType (Choice Field) and PackageContact(???) along with other stuff that isn't relevant to this.

I am trying to get the PackageContact field to populate depending on the selection from PackageType.

For Example,

In Contact Details List:

PackageType = Landscaping

CompanyName = Green Landscapers

Email = Green@Landscaping.com

Then when sending an email to one or multiple people from the contact list I am able to go to the Email Template:

Select Landscaping from the Package Type, then open up another choice box with only the Landscaping Contacts in the ContactDetails list and select one or multiple contacts to send an email to. In this case I will see Green Landscapers and any others that have Landscaping selected as the Package Type.

I have attempted using calculated and lookup columns to solve this but, with no success.

Any help is appreciated!

Thankyou

Categories:

General topics