cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
ramanan89
Helper III
Helper III

Retrieve Values from Collection

Hi,

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

Screenshot 2020-07-14 at 10.19.17 PM.png

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,

1 ACCEPTED SOLUTION

Accepted Solutions
eka24
Super User
Super User

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.

 

 

View solution in original post

3 REPLIES 3
KrishnaV
Super User
Super User

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.

 

 


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,
KrishnaV
Business Applications MVP, Microsoft Certified Trainer
Twitter | Linkedin | YouTube | GitHub
If this post helps you give a and if it solved your issue consider Accept it as the solution to help the other members / new members of the community.
eka24
Super User
Super User

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.

 

 

Thank you... This worked 🙂

Helpful resources

Announcements
PA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

This training provides practical hands-on experience in creating Power Apps solutions in a full-day of instructor-led App creation workshop.

PWREduCon768x460.png

Join us at PWR EduCon - A Power Platform Conference

Learn from the top Power BI, Power Apps, Power Automate & Power Virtual Agents experts!

Top Solution Authors
Top Kudoed Authors
Users online (3,153)