Select a dynamic content from 2 different dataverse tables in power bi desktop

[Anonymous]

Dear all

i have built a power bi report showing all external sharings made with power apps with 2 Dataverse tables from the COE STarter kit : Audit Logs + Admin_app

Now I would like to build an automated flow which sends an email each time a new external sharing is done.

to do this i am following this video https://www.youtube.com/watch?v=QZdkyw2kGvw

Tor the last step of the flow, i would like to add the possibility to send an email to me when an external sharing is do.

how can i do if i want to retrieve the dynamic content from the other dataverse table (admin_app)? I miss the app name... i would like to add this dynamic value in my email body...

(i have managed to add the values from these 2 tables in my report but how can i select this in my workflow?)

thank you!!!

[Anonymous · Accepted solution]

Hi @Anonymous ，

Please try to follow the steps below：

1. Trigger: Set up your Power Automate flow with a trigger that checks for new external sharing events. This could be a scheduled trigger that checks the Audit Logs table at regular intervals, or a trigger based on a condition that detects new entries.

2. Get Data from Dataverse: - Use the "List rows" action in Power Automate for the Dataverse connector to query the Audit Logs table for new sharing events. - Add a second "List rows" action to retrieve the corresponding app details from the Admin_app table. You might need to use a common key or field to join data from both tables, such as an app ID.

3. Formulate the Email Content: - In the "Send an email" action, use the dynamic content selector to include values from both the Audit Logs and Admin_app tables in the email body. You can insert dynamic fields by clicking on "Add dynamic content" and selecting the fields from the tables that you want to include in your email.

4. Condition: If needed, add a condition to check if the retrieved sharing event is indeed an external sharing event before sending the email.

5. Send Email: Configure the "Send an email" action with your email address and the dynamic content you've retrieved and formatted.

Here is an example flow structure:

- Trigger: When a new external sharing is detected

- Action: List rows from Audit Logs (filter to the latest or a specific condition)

- Action: List rows from Admin_app (use a key to get the related app details)

- Condition: Check if it's an external sharing event

- If yes: - Action: Send an email (use dynamic content from both tables in the email body)

- If no: - Action: Do nothing or log the event

Since you have successfully added values from both tables in your Power BI report, you should have a common key or identifier that links records between the two tables. Use this key in your Power Automate flow to retrieve the corresponding data.

Best Regards,

Neeko Tang

If this post  helps, then please consider Accept it as the solution  to help the other members find it more quickly. 

[Anonymous · Accepted solution]

hi Thank you for your quick answer, your answer helped me a lot... and it worked now.

[Anonymous · Accepted solution]

Hi @Anonymous ，

Please try to follow the steps below：

1. Trigger: Set up your Power Automate flow with a trigger that checks for new external sharing events. This could be a scheduled trigger that checks the Audit Logs table at regular intervals, or a trigger based on a condition that detects new entries.

2. Get Data from Dataverse: - Use the "List rows" action in Power Automate for the Dataverse connector to query the Audit Logs table for new sharing events. - Add a second "List rows" action to retrieve the corresponding app details from the Admin_app table. You might need to use a common key or field to join data from both tables, such as an app ID.

3. Formulate the Email Content: - In the "Send an email" action, use the dynamic content selector to include values from both the Audit Logs and Admin_app tables in the email body. You can insert dynamic fields by clicking on "Add dynamic content" and selecting the fields from the tables that you want to include in your email.

4. Condition: If needed, add a condition to check if the retrieved sharing event is indeed an external sharing event before sending the email.

5. Send Email: Configure the "Send an email" action with your email address and the dynamic content you've retrieved and formatted.

Here is an example flow structure:

- Trigger: When a new external sharing is detected

- Action: List rows from Audit Logs (filter to the latest or a specific condition)

- Action: List rows from Admin_app (use a key to get the related app details)

- Condition: Check if it's an external sharing event

- If yes: - Action: Send an email (use dynamic content from both tables in the email body)

- If no: - Action: Do nothing or log the event

Since you have successfully added values from both tables in your Power BI report, you should have a common key or identifier that links records between the two tables. Use this key in your Power Automate flow to retrieve the corresponding data.

Best Regards,

Neeko Tang

If this post  helps, then please consider Accept it as the solution  to help the other members find it more quickly.