Power Platform Community Forum Thread Details

Dear all,

In the new Copilot Studio, I can’t select only the value when creating a new workflow with the Select function, even in Text mode.
For example, I read a list of attendees from a meeting and want only their upn (email), but the Select function always requires a Key-Value Pair.

In the old version, it was possible to get the value only. How can I achieve that in the new version?

Thank you

Regards

Categories:

General topics

Hi,

In the new designer, the Select action expects a JSON object (key-value pair) rather than a single value. That's why entering only:
@{item()?['upn']}
results in the Invalid JSON error.

A common workaround is to use Select to create an object first, for example:
{
"upn": "@{item()?['upn']}"
}

This will return an array of objects like:
[
{ "upn": "user1@company.com" },
{ "upn": "user2@company.com" }
]

If you need a simple array of email addresses rather than objects, you can apply an additional transformation afterward (for example, using a variable, Join, or another expression depending on your scenario).

Unfortunately, the ability to return only a raw value directly from Select (as was possible in some older experiences) is not currently available in the new designer.

Thanks,

Manoj Annavajjala