Answered

List rows, Filter Rows fails with NULL value

Like (0) Share

Report

Posted on 10 Oct 2022 08:38:37 by PietPoelsma

In a Cloud Flow I make use of the Dataverse Action: List rows . I want to select the GUID of a reference/parent table from a child table using the foreign key value in the child table.

When this foreign key value is filled there is no issue, however the relationship between the parent & child table is optional and I get a run time error when this field is not filled.

How can I solve this issue?

Kind regards,

Piet

Categories:

Microsoft Dataverse

I have the same question (0)

Summarized by AI

All responses (6)

Answers (1)

Verified answer

João Santos 323 on 10 Oct 2022 at 08:51:12

Like (0)

Report

Re: List rows, Filter Rows fails with NULL value

Hi,
I would say you might just need to put this action within a condition. If KPI_TAG_MERK is not null then do your list rows action, otherwise terminate flow
That will avoid any errors

Was this reply helpful? Yes No
PietPoelsma 67 on 10 Oct 2022 at 09:43:32

Like (0)

Report

Re: List rows, Filter Rows fails with NULL value

Thanks @joaodsantos ,

I guess that would work and thought of that myself. I was kind of hoping to apply some kind of OData command to avoid 'clicking' a lot of power automate actions. It's approximately 20 columns in several scenario

Regards
Piet

Was this reply helpful? Yes No
Gowri Halan 262 on 10 Oct 2022 at 15:19:10

Like (0)

Report

Re: List rows, Filter Rows fails with NULL value

@PietPoelsma You might try one more option. Add a variable step in flow keep some default value in it (say 0 or 0000-0000 (empty guid)) and set child record id to it. and use variable in your condition. So you may not end up in error instead Dataverse will try to find record with 0 and might return nothing.

I havent tried this approach. But give it a try

Was this reply helpful? Yes No
João Santos 323 on 10 Oct 2022 at 15:51:12

Like (0)

Report
Re: List rows, Filter Rows fails with NULL value

Yup, was going to suggest something similar to what @gowrihalan04 posted, but directly on the List Rows action.
Set the filter rows to an expression that checks if there's a value on the lookup, if there is use it otherwise use a all zeros guid, something like this:
if(equals(empty(triggerOutputs()?['body/_parentcustomerid_value']),null),'00000000-0000-0000-0000-000000000000',triggerOutputs()?['body/_parentcustomerid_value'])
Haven't tried it either but some version of this should work I think. Just replace the triggerOutputs()?['body/_parentcustomerid_value'] on the formula which I used as an example for you own field.
Hope this helps

Was this reply helpful? Yes No
PietPoelsma 67 on 12 Oct 2022 at 05:45:26

Like (0)

Report

Re: List rows, Filter Rows fails with NULL value

Thx @gowrihalan04 for your suggestion. In the mean time I implemented the solution as suggested by @joaodsantos . It's a bit more work, but very readable which is a good thing as well.

Regards,
Piet

Was this reply helpful? Yes No
PietPoelsma 67 on 12 Oct 2022 at 05:46:07

Like (0)

Report

Re: List rows, Filter Rows fails with NULL value

Thx @joaodsantos as stated above I went for your first suggestion.

Regards,
Piet

Was this reply helpful? Yes No

Join the conversation

Community site session details

List rows, Filter Rows fails with NULL value

Helpful resources

News and Announcements

Quick Links

Responsible AI policies

Chiara Carbone – Community Spotlight

Congratulations to the October Top 10 Community Leaders!

Leaderboard > Power Apps

Featured topics

Product updates

Community site session details

List rows, Filter Rows fails with NULL value

Helpful resources

News and Announcements

Quick Links

Responsible AI policies

Chiara Carbone – Community Spotlight

Congratulations to the October Top 10 Community Leaders!

Subscribe to this forum!

Select categories

Leaderboard > Power Apps

Featured topics

Product updates