Answered

Selection range of numbers from dropdown

(0) Share

Report

Posted on by Kldmurshed

Hi All,

How to achieve the following scenario. I couldn't select the range of serials from the SQL table based on the user selection.

I have 2 dropdowns of serial numbers. The user has to select the first and last serials available.

I need to print all the selected range of serials in the textbox and the total selected.

Data is from SQL table "SerialsNumbers"

Please see the figure below.

Your help is appreciated.

Thanks

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Sort by

Vijay Tailor 2,961 on at

Like (0)

Report
Copy link

Link copied!
Hi @Kldmurshed ,

Please find the below solution for your requirement.

Please below code in Button OnSelect Property.
Note:- change your DropDown Name.

Clear(RangeGereateColl1); UpdateContext({StartValue:Value(Dropdown5.Selected.Value)}); UpdateContext({EndValue:Value(Dropdown5_1.Selected.Value)}); UpdateContext({RangeValue:EndValue-StartValue}); ClearCollect(SeqColl,Sequence(RangeValue)); ForAll(SeqColl, Collect(RangeGereateColl1,{RangeValueColumn:StartValue+ThisRecord.Value}); );

Code for TextInput Default -
Concat(RangeGereateColl1,Text(RangeValueColumn),",")
See the below-attached Demo for reference -

Thanks,
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."-Vijay

Was this reply helpful? Yes No
Kldmurshed 32 on at

Like (0)

Report
Copy link

Link copied!

Thank you @VijayTailor

Your code is almost perfect. But the first serial which is selected doesn't show in the result.
Could you please fix it so that I can accept the solution?

Thanks

Was this reply helpful? Yes No
Verified answer

Vijay Tailor 2,961 on at

Like (0)

Report
Copy link

Link copied!
Hi @Kldmurshed ,

See the Modified code below - for Button
Clear(RangeGereateColl1); Collect(RangeGereateColl1,{RangeValueColumn:Value(Dropdown5.Selected.Value)}); //New Added UpdateContext({StartValue:Value(Dropdown5.Selected.Value)}); UpdateContext({EndValue:Value(Dropdown5_1.Selected.Value)}); UpdateContext({RangeValue:EndValue-StartValue}); ClearCollect(SeqColl,Sequence(RangeValue)); ForAll(SeqColl, Collect(RangeGereateColl1,{RangeValueColumn:StartValue+ThisRecord.Value}); );
Thanks,
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."-Vijay

Was this reply helpful? Yes No