203
Hi trying to create a Flow where I need to Get a Row, but NOT by ID. I don't have the ID. I'm trying to query the entity for 1 record by the Account Name. How can I do this? There use to be a Get Row that would return 1 row if I recall correctly.
If there is no more Get Row, how can I create a List Rows and then just query for 1 record and get the results? Looking to get an account ID where account.name = 'Test Company' and have that saved into a variable.
Hi @saturation ,
You can use the "List rows" Dataverse step and then use an OData filter in the 'Filter rows' section (advanced options) to filter for where account name = 'Test Company'. Note you will have to use the "Name" of the column as opposed to the "Display Name" in this filter query. The "Name" will be the column name with a few characters and an underscore before the field name.
For example, it might be crdh9_accountname instead of 'Account Name'. So the filter query will look something like [ crdh9_accountname eq 'Test Company' ].
This step will produce a filtered table, but if the Account Name field is unique for all records, then it will only have one row in the returned table. You can then use the 'first' function (https://docs.microsoft.com/en-us/azure/logic-apps/workflow-definition-language-functions-reference#first) to retrieve the first record and save the appropriate field to your variable.
I hope this helps.
If this solved your problem, please Accept this post as the solution.
Share
Report
All responses (
Answers (
