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.
Solved! Go to Solution.
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."
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."
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
Does anyone have any possible solutions for when the column is not going have a single row?
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")
This training provides practical hands-on experience in creating Power Apps solutions in a full-day of instructor-led App creation workshop.
Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.
User | Count |
---|---|
243 | |
122 | |
83 | |
83 | |
67 |