Unanswered

How to check for emtpy collection or for existence of data row in Common Data Model database

(0) Share

Report

Posted on by SentiNode

Hi,

I need to verify if a row with certain ID exists in the table, if yes - run one command chain, if no - insert the new value and run another command chain.

I do the Get entity data with a filter, but then if I try to add a condition, it automatically changes to "apply to each", and tries to iterate over "values", comparing the value to null does not work (it is always not null), trying to compare some column within the row to be returned does not work - both yes/no options are skipped.

Any ideas?

Categories:

Using connectors

All responses (17)

Answers (0)

Sort by

RajRa Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!

Hi SentiNode,

You have to use the advanced mode in the condition expression and use the @empty Logic app expression https://aka.ms/logicexpressions

Here's a flow that demonstrate it - be sure to click on the advanced mode in the filter array to enter this value
SentiNode 18 on at

Like
a
(0)

Report
Copy link

Link copied!

Actually I would like to do :
Get Entity Data (with a correct filter) ------> Condition [Yes block | No block].

How should I properly use @empty to verify if Get Entity Data returns an empty collection or an actual object?

The Filter Array -> Apply to each, wouldnt be the best solution here:

1) I will get either a single result (the object exists in a table) or no results (the object does not exist in a table)

2) I it does not exist - I want to create it, if it does exist however - I want to update it and increase update counter in the object.
RajRa Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

You should be also able to use the empty expression in a condition card (without the filter array) and detect if the object exists or not - Go into the advanced mode.

Let us know if this adresses it.
SentiNode 18 on at

Like
a
(0)

Report
Copy link

Link copied!

I did, but it goes one way always (empty) regardless of the actual array
RajRa Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi SentiNode,

To be clear, your flow should look like so, fill in the Yes/No paths to do what you want. This does not work?
SentiNode 18 on at

Like
a
(0)

Report
Copy link

Link copied!

Id do not have "apply to each" box, can I check directly the results of Get Entity Data if there were some results??
RajRa Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Unfortunately, GetEntity data does not support a filter today.

Can you clarify what you mean by "do not have "apply to each" box?
SentiNode 18 on at

Like
a
(0)

Report
Copy link

Link copied!

Hmm, why can I set a filter in GetEntity then?

Directly after get entity I have the condition, not using "apply to each" to encircle it.
RajRa Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Can you replace GetEntity by GetList of Entities, post that you should be able to apply the foreach like how I listed.
SentiNode 18 on at

Like
a
(0)

Report
Copy link

Link copied!

Get entity data returns the list on the matching entities... is there any debug to see the data structures that are actually passed? Maybe it returns an array of array objects?