Retrieve Values from Collection

[ramanan89]

Hi,

I am trying to retrieve values from a collection where there is only three rows always as in the screenshot below,

I am trying to show three textboxes with values (totalslides value) from each row into three different Label boxes,

Day1 = Full
Day2 = 90
Day3 = Full 

Because it shall show Full if the value is less than or equal to 0. Any suggestions on how to do it?

Regards,

[KrishnaV]

hi @ramanan89 ,

try this:

If(Value(collectionname.totalslide)<=0,"Full",collectionname.totalslide)

Set this formula on each label text property Or default property of the textInput control.

I hope this resolved your issue if you see any challenge/need further help please let me know I am always happy to do it for my community.

Regards,
Krishna
If this post helps you give a 👍 and if it solved your issue consider Accept it as the solution to help the other members find it more.

[eka24 · Accepted solution]

Try these in the textboxes:

First(Datasource).TotalSlide

Last (FirstN(Datasource,2)).TotalSlide

Last (Datasource).TotalSlide

------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

[ramanan89]

Thank you... This worked 🙂