How to Join Two Dataverse tables to send emails that need fields from both tables

(0) Share

Report

Posted on by boom_powerapps

101

I am in need of joining two Dataverse tables that both have an unique identifier called Request ID.

One table has a filter that returns 5 tables based on renewalreminder field = TODAY.

Field names:

Contract Name
Vendor
Contract End Date
Contract Type
Cost Center
Request ID

I didnt put a filter on this table; Everytime I added Request ID from SVM Requests = Request ID from Contracts List, an Apply to each was added and I wasnt sure if that is what I needed.

Field Names:

Relationship Manager

Business Owner

SVM Lead

Request ID

Any idea on how to join them together?

There's apply to each on the email that goes out. That part works. Its currently emailing 5 different people since there are 5 rows in the contracts list table with an renewalreminder of today. But if I add a field from SVM requests, the apply to each generates.

Categories:

General topics

I have the same question (0)

All responses (2)

Answers (0)

SudeepGhatakNZ 14,394 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

If I understand you correctly, you want to email a list of SVM Requests for a given Request Id to all the contacts that are associated with that Request Id. Correct?

I have demonstrated using the Contacts and the Sdk Message Requests Tables

Was this reply helpful? Yes No
boom_powerapps 101 on at

Like (0)

Report
Copy link

Link copied!

@SudeepGhatakNZ The data from both tables needs to be merged so that I can send the contents of each row item to the same email address.

I need to combine both tables to make a row like this:
RequestID | Contract Name| Vendor | Contract End Date |Contract Type| Cost Center| Relationship Manager | Business Owner | SVM Lead

Each row represents an email that will be sent to a distro email address.

Was this reply helpful? Yes No