Want to get single column from collection.

[sachinsoni441]

Hello experts,

I have one single row collection which has 3 columns.

Example

1. ID

2. Name

3. Status

How can i get Status column value, because i want to show this status in label.

Note :Collection always having single row only.

Please help.

[mdevaney · Accepted solution]

@sachinsoni441 

The Collection must be converted to a record to get the Status.  Put this code in the Text property of a label.

First(your_collection_name).Status

Or you can use this code if Status was coming from a Choices column in SharePoint initially.

First(your_collection_name).Status.Value

---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."

[Pstork1]

If the column is always guaranteed to have a single row you could use the following to get the value of the status column

First(collection).Status

[RTB_10]

Does anyone have any possible solutions for when the column is not going have a single row?

[Pstork1]

If you surround the First() with a coalesce you should be able to substitute a placeholder value when the array returned is null.

Coalesce(First(collection).Status,"No Status")