cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
sachinsoni441
Helper II
Helper II

Want to get single column from collection.

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.

1 ACCEPTED SOLUTION

Accepted Solutions
mdevaney
Super User
Super User

@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."

View solution in original post

4 REPLIES 4
mdevaney
Super User
Super User

@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."

View solution in original post

Pstork1
Dual Super User III
Dual Super User III

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


-------------------------------------------------------------------------
If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.
RTB_10
Helper I
Helper I

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

Pstork1
Dual Super User III
Dual Super User III

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")


-------------------------------------------------------------------------
If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Helpful resources

Announcements
User Group Leader Meeting January 768x460.png

Calling all User Group Leaders!

Don't miss the User Group Leader meetings on January, 24th & 25th, 2022.

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Top Solution Authors
Top Kudoed Authors
Users online (1,335)