How to filter a dataverse table on the basis of another dataverse table with list rows action in powerapps flows?

(0) Share

Report

Posted on by rahul78610

I have a two tables in my solution , Table Employee which is like a employee master to keep the records of all employees and second table is taskTable which will be used to enter details of new task done by an employee , now I want to check this list from taskTable and want to compare the employee names with the Employee table which has all employees name in it and whoever is missing from the list of Table Employee , i want to send an email reminder to those ..
If I try to list rows first for taskTable and then list rows for Employee table it is not giving the proper output instead it is checking for each value from taskTable to every other value in Employee table and bcoz of that it is returning unexpected results ,
can anyone help please?

Categories:

Application

All responses (7)

Answers (0)

Suggested answer

rahul78610 35 on at

Like (0)

Report

RE: How to filter a dataverse table on the basis of another dataverse table with list rows action in powerapps flows?

Thank you everyone for your responses , I tried with my employeetask table first with list rows and then again took the list rows action for employee table and then compare the names with the list which i got from employeetask table and whoever was not there in task table, I just send the email and it worked.
Suggested answer

Leah Ju Microsoft Employee on at

Like (0)

Report
RE: How to filter a dataverse table on the basis of another dataverse table with list rows action in powerapps flows?

Hi rahul78610,

Based on your description, "second table is taskTable which will be used to enter details of new task done by an employee"

The employee and taskTable have 1:N relationship, there is one employee lookup column in taskTable, Right?

What you want is a list of employees who do not have any related tasks, Right?

Filter in the flow:

Next Steps:

Test Result:
Suggested answer

Bipin D365 28,962 Moderator on at

Like (0)

Report

RE: How to filter a dataverse table on the basis of another dataverse table with list rows action in powerapps flows?

Hi,

Try below filter in advanced find and download fetch XML which can be used in your power automate list rows

Please select Does not contain data in related filter.

Select Employee where I have contacts and select Task when I selected Email
Suggested answer

Mohamed GRAIB 2,498 Super User 2024 Season 2 on at

Like (0)

Report

RE: How to filter a dataverse table on the basis of another dataverse table with list rows action in powerapps flows?

Hi rahul78610

You can Utilize the List rows action, and mention this fields :

In the Select columns field, you mention the shema name of columns that you want export.

And then, you will navigate to your Dynamics 365 and navigate the advanced search

You will search all employees and in the filter you add a related table (Tasks) and Guid (Tasks table) does not contain data.

Then you will click on Download Fetch XML query

You will add this Query in your Power automate action

Hope that's helpful for you
rahul78610 35 on at

Like (0)

Report

RE: How to filter a dataverse table on the basis of another dataverse table with list rows action in powerapps flows?

Hi Mohamed GRAIB , I need the list of all employee names who have not filled any data in the other table so basically want just those rows for employees who have not filled anything in the taskTable and need to get those names from employee table
Suggested answer

Mohamed GRAIB 2,498 Super User 2024 Season 2 on at

Like (0)

Report

RE: How to filter a dataverse table on the basis of another dataverse table with list rows action in powerapps flows?

Hi Rahul,

In the action List rows of your table Task rows, rou can add a filter like this

You will List rows of Tasks where the employee field is not Nul.

Hope that's helpful for you
Suggested answer

Abdul Wahab 12,070 Moderator on at

Like (0)

Report
RE: How to filter a dataverse table on the basis of another dataverse table with list rows action in powerapps flows?

Hi rahul78610,

Use the below components in the Power Automate

Recurrence. For more details: https://learn.microsoft.com/en-us/power-automate/run-scheduled-tasks

List rows with Filter rows or Fetch XML Query. For more details: https://learn.microsoft.com/en-us/connectors/commondataserviceforapps/#list-rows

Condition. For more details: https://learn.microsoft.com/en-us/power-automate/desktop-flows/use-conditionals

Send an email (V2). For more details: https://learn.microsoft.com/en-us/connectors/office365/#send-an-email-(v2)