Dataverse List Rows oData filter not working with Variable, only explicit

(0) Share

Report

Posted on by RubySmith11

Hi,

I have 2 tables; one is my Contacts table, the other is an External Data for requests.

I am trying to link the External Data to a Contact (each time a new row is added) via a flow.

Contact (Unique ID)	Email as Text (custom column)
Ruby Test	Ruby.Test@test.com
Amy Sample	Amy.Sample@test.com
Jo MadeUp	Jo.Madeup@test.com

Request ID	Requester	Contact (Lookup)
A1234	Ruby.Test@test.com
A9876	Ruby.Test@test.com
A5873	Jo.Madeup@test.com

The flow looks at the Requester (email in a string format) from the External Data and then filters the Contacts table via the oData Filter in List Rows.

Finally, I have a formula to extract the ContactID from the List Rows array that is returned and update the Contact Lookup field in my External Data.

The issue

The issue is that the filter works when I explicitly type the email address (emailastext eq 'Ruby.Test@test.com'), however when I reference the Requester dynamically, the flow runs but nothing is returned through the filter. I get an error message at the very last step when trying to update the Contact (Lookup) field because the flow is trying to update the field with an empty value

This works

This does not work

Any help greatly appreciated, thanks in advance!

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (1)

Sort by

v-chengfen-msft Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!
Hi @RubySmith11 ,
Could you please tell me:
Do you add record manually and enter [Request ID] first?
Like this:

At the time, Flow starts

Now,In [List rows]'s Value, It is null
Here is a test for your reference:
[Note]:
Manually updating records may occur. When you create a Request ID, the flow trigger is triggered, resulting in no [Requester] in the return value.
Filter rows in [List rows], please use Logical Name for the column name.

Here are table

Find logicalName this way:

Here is test:

Best Regards
Cheng Feng

Was this reply helpful? Yes No
Verified answer

v-chengfen-msft Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!
Hi @RubySmith11 ,
Could you please tell me:
Do you add record manually and enter [Request ID] first?
Like this:

At the time, Flow starts

Now,In [List rows]'s Value, It is null
Here is a test for your reference:
[Note]:
Manually updating records may occur. When you create a Request ID, the flow trigger is triggered, resulting in no [Requester] in the return value.
Filter rows in [List rows], please use Logical Name for the column name.

Here are table

Find logicalName this way:

Here is test:

Best Regards
Cheng Feng

Was this reply helpful? Yes No
RubySmith11 32 on at

Like (0)

Report
Copy link

Link copied!

Hi Chen Feng,

Thanks for your reply and assistance!

Thanks,
Ruby

Was this reply helpful? Yes No