Get GUID from expand query

[dennisb88]

Hi all,

I've a flow where I list some rows from dataverse and I add a column to the Expand Query setting:

This "Wam_Hoofdproject" is a lookup column to another dataverse table.

Now I want to select in my next step the GUID of this record.

How can we achieve this?

I try this expression, but that's give some errors by saving:

items(outputs('List_rows')?['body/value'])?['wam_Project']?['_wam_hoofdproject_value']

This is a part of my list row action raw data:

_wam_hoofdproject_value@Microsoft.Dynamics.CRM.associatednavigationproperty":"wam_Hoofdproject","_wam_hoofdproject_value@Microsoft.Dynamics.CRM.lookuplogicalname":"wam_hoofdproject","_wam_hoofdproject_value@odata.type":"#Guid","_wam_hoofdproject_value":"453dca45-748e-ec11-b400-0022488280d2","_ownerid_value@OData.Community.Display.V1.FormattedValue":"#, 

So I need the GUID of the "hoofdproject". I need this to use it in a Filter array.

Hopefully someone know how I can achieve this.

Thanks in advance.

[Expiscornovus]

Hi @dennisb88,

In the filter array you should be able to refer to the column via the item function. That would be item()['ColumnName'].

Below is an example.

[dennisb88]

Hi @Expiscornovus ,

Thank you for your reply.

I try the option you suggest but it's not working. I get a message that the property does not excist:

The execution of template action 'Filter_array' failed: The evaluation of 'query' action 'where' expression '@equals(item()['_wam_hoofdproject_value'], 'e42d5743-748e-ec11-b400-002248828451')' failed: 'The template language expression 'equals(item()['_wam_hoofdproject_value'], 'e42d5743-748e-ec11-b400-002248828451')' cannot be evaluated because property '_wam_hoofdproject_value' doesn't exist, available properties are

I cannot find this property from my expand Query.

My filter array:

Any idea on what I can do/try?

[Expiscornovus]

Hi @dennisb88,

Sorry I forgot to ask. Does every project have a hoofdproject related to it?

Otherwise you could try it with the question mark character:

item()?['_wam_hoofdproject_value']

[dennisb88]

Hi @Expiscornovus ,

Thank you. That will not give me any error again. So that part is working for now.

But where I'm expecting that the filter array should be give some results it doesn't show anything.

Filter array is set as:

The result of input vs output is not what I expect because there should be a match:

Any Idea why there is no output?

Thanks in advance.

[Expiscornovus]

Hi @dennisb88,

That looks odd. Can you use the peek code option in the settings to check the from and where values in the code view?

I am expecting something like below.

{
    "inputs": {
        "from": "@outputs('List_rows')?['body/value']",
        "where": "@equals(item()?['_wam_hoofdproject_value'], '453dca45-748e-ec11-b400-0022488280d2')"
    },
    "description": "",
    "metadata": {
        "operationMetadataId": "59985499-51e2-44f6-858d-453b4fd086da"
    }
}

[dennisb88]

Hi @Expiscornovus ,

Thank you for your reply.

The Peek code look like similar:

{
    "inputs": {
        "from": "@outputs('List_rows')?['body/value']",
        "where": "@equals(item()?['_wam_hoofdproject_value'], '453dca45-748e-ec11-b400-0022488280d2')"
    },
    "metadata": {
        "operationMetadataId": "c204d444-9815-4a72-8934-3de44a3a4d57"
    }
}

[Expiscornovus · Accepted solution]

Hi @dennisb88,

I think I spotted the mistake in my own setup. That _wam_hoofdproject_value is probably nested under wam_Project in the list rows action raw data, correct?

Can you try this instead:

item()?['wam_Project/_wam_hoofdproject_value']

[dennisb88]

Hi @Expiscornovus ,

Yes it is! I Try this and it solved the issue.

Thanks again for your help!

[Expiscornovus]

Hi @dennisb88,

Geen probleem. Happy to help out 🙂