web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps Collect values from a ...

Power Apps

Answered

Collect values from a table up to a certain value

(0) Share

Report

Report

Posted on by Nick106

4

Hi all.

I have an excel sheet as data source, with a table (named Table1) that shows 1 column called “x1”.

I would like to collect the content of the column x1 up to a certain value chosen by the user using an input box.

for your better understanding, hereunder an example

-Column x1 shows numbers from 0.1 to 100 (with step size of 0.1)

-the user write 50 in the inputbox

- all the values up to a number <=50 are collected

Hope I was clear.

thanks a lot in advance

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (1)

Sort by

Verified answer

WarrenBelz 155,315 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
Hi @Nick106 ,

It should be something like this

ClearCollect( YourCollection, Filter( Table1, x1 <= Value(YourTextInput.Text) ) )

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

MVP (Business Applications) Visit my blog Practical Power Apps

Was this reply helpful? Yes No
Nick106 4 on at

Like (0)

Report
Copy link

Link copied!

It works!
Thanks a lot

Was this reply helpful? Yes No

Join the conversation