How to chcek collection filed value

[Vidanaw]

Hi All,

I have a collection wich load with SharePoint data source. In the collection I have a field called Status (mapped with SharePoint choose column type), now I want to check is this value is equal to "Open".

FYI- this collection have only one item at any given time.

I need something like if( Collection.Status = Open, UpdateContext({btndisplay:false}), UpdateContext({btndisplay:true}))

Thanks.

[mdevaney]

@Vidanaw
The solution is to change your collection reference into a record using the FIRST function. Fortunately this will not take much time to do.

if(First(Collection).Status = ”Open”, UpdateContext({btndisplay:false}), UpdateContext({btndisplay:true}))

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

[Pstork1 · Accepted solution]

If the collection will only ever have one record then you can check this way.

if( First(Collection).Status.Value = "Open", UpdateContext({btndisplay:false}), UpdateContext({btndisplay:true}))

Using First() will get the first record.  Then you can check the Status field of that record.  Since its a choice field you will need to use the specific name of the property of the field that holds the value Open.  This is usually Value, but can be other things.

[Vidanaw]

Thank you very much, really appreciate the assistance.

Thanks.