Ms Flow giving an error while filtering rows using list rows action for lookup column

(0) Share

Report

Posted on by rahul78610

I was creating a scheduled flow in which I was using microsoft dataverse connectors and the action was to "list rows" and when I tried to filter rows using one of the column name Due date of table EmployeeTaskEntries, which is a lookup from another table DueDateMaster , i was not able to complete the flow , since the value it contains is a reference to the DueDateMaster so what should be the exact column name should I put to make it call the DueDateMaster's DueDate column instead of the current table DueDate.
3515.error.png

I have the same question (0)

All responses (13)

Answers (1)

Suggested answer

Abdul Wahab 12,119 Moderator on at

Like (0)

Report

Hi rahul78610,

Use the Fetch XML Query property of List rows. Make that query using advanced find and paste it here. Below are the steps:

Was this reply helpful? Yes No
rahul78610 35 on at

Like (0)

Report

Hi Abdul Wahab , how are you getting to that advanced find screen , is there a URL or some other way ? I am trying this Microsoft Dataverse on teams app only so is there any other way you are trying on some other platform or app?

Was this reply helpful? Yes No
Suggested answer

Abdul Wahab 12,119 Moderator on at

Like (0)

Report
Hi rahul78610,

Here you are:

example: https://org3382972c.crm4.dynamics.com/main.aspx?pagetype=advancedfind&appid=#516183534

Manipulate it for you: organizationURL/main.aspx?pagetype=advancedfind&appid=#516183534

Go to the Advanced settings from make.powerapps.com

and then Advanced find

Was this reply helpful? Yes No
Suggested answer

Leah Ju Microsoft Employee on at

Like (0)

Report

Hi rahul78610,

If ‘ Due date’ is lookup column, you need check the following two points:

(1) The format should be _cr9c8_DueDate_value

The best way I found how to make the Filters work on Dynamics is to:

First run the Flow with List Dynamics action without the filter.

Second check the results of the Flow run, and look for the value you wish to be filtering on.

Third copy the field name without quotes and use that as the filter.

2.The value of the lookup column should Guid, but you are using date value.

So ‘ Due date’ is Lookup column?

Was this reply helpful? Yes No
Suggested answer

Leah Ju Microsoft Employee on at

Like (0)

Report

Hi rahul78610,

You can use FetchXML Builder(a powerful tool that generates FetchXML without the user having to actually know any FetchXML.) for XrmToolBox

https://fetchxmlbuilder.com/

https://carldesouza.com/10-features-in-fetchxml-builder-you-need-to-be-using/

Was this reply helpful? Yes No
rahul78610 35 on at

Like (0)

Report

Hi Abdul Wahab , I tried that way but I cannot see my table in this list .

Was this reply helpful? Yes No
rahul78610 35 on at

Like (0)

Report

Hi Leah , I tried downloading it but it is giving a warning and I am not using my personal laptop so it might be a risk to install it on my work laptop

Was this reply helpful? Yes No
Suggested answer

Mohamed GRAIB 2,504 Moderator on at

Like (0)

Report

Hi Rahul,

Please try to add this two '' in your formula like this

'formatDateTime'

Was this reply helpful? Yes No
rahul78610 35 on at

Like (0)

Report

Hi Mohamed GRAIB , I have used the above expression only in my filter column which you have mentioned.

Was this reply helpful? Yes No
Suggested answer

Mohamed GRAIB 2,504 Moderator on at

Like (0)

Report

Hi Rahul,

In this case, try add another action to List rows of the table which exist your lookuo field.

Then you add your filter and add the two ''

Was this reply helpful? Yes No