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.
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
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.
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.
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.
It does return an array of objects (collection). Configure it and run, if you click on the i link on your flow list, you should see all the parameters being passed in for a flow run
When I click on the link (arrow) nbothing happens...
How do I check if the collection returned by "Get entity data" is empty or not? should I reference item()? or something else ? I really can't see what is passed between the nodes so it is pretty hard to create conditions in advanced mode...
Still no info on that?
Any way to check what variables are passed between the nodes? Any debug? When I click on the link between nodes I get no information about the variables passed.
To be clear, did you go to this page by clicking on the i as shown in this picture and eventually you should be able to see each individual run - Is this not working for you?
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.
Learn to digitize and optimize business processes and connect all your applications to share data in real time.
Are you new to designing flows? What is your biggest struggle with Power Automate Designer? Help us make it more user friendly!