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)

Verified answer

rahul78610 35 on at

Like (2)

Report

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

Hi everyone , thank you all for all the responses , I have found a way to use lookup field in the filter column ,Suppose I have a table A which has a column of type lookup 'lookupA' which is getting the value from the table B column name 'columnB' so this will be the syntax in the filter query of list rows action of microsoft Dataverse:

lookupA_schema_name/columnB_logical_name eq 'your expression to compare'

Was this reply helpful? Yes No
Suggested answer

Mohamed GRAIB 2,504 Moderator on at

Like (0)

Report

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

Hi Rahul,

The action List rows that you will add is from the table of your Lookup Field.

For example if your Field Due date is in the table A, you will create these actions :

1. Initialize a variable named Due Date.

2. List rows of your Table A

Apply for each

3. Define your variable Due Date = due date field

Try this solution, it resolves my problems.

Was this reply helpful? Yes No
rahul78610 35 on at

Like (0)

Report

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

Hi Mohamed GRAIB , I am not able to get what you are saying , can you plz elaborate on which step I need to do first and which step i need to do second, like for the first list rows action which table should be selected and if there is any filter required or not and then for second list rows action in the same way so that would be really helpful..

Was this reply helpful? Yes No
Suggested answer

Mohamed GRAIB 2,504 Moderator on at

Like (0)

Report

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

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
rahul78610 35 on at

Like (0)

Report

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

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

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

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

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

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
rahul78610 35 on at

Like (0)

Report

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

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

Was this reply helpful? Yes No
Suggested answer

Leah Ju Microsoft Employee on at

Like (0)

Report

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

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
Suggested answer

Leah Ju Microsoft Employee on at

Like (0)

Report

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

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