Answered

Show values from SharePoint List Length Min, Length Max in Gallery?

(0) Share

Report

Posted on by Digitalartnet

Hello together

Question how do I get from 3 labels (length, width, height) the e.g. ( =< length_min 390 =>length_max 420) value searched in the SharePoint list? And displayed in the Gallery.

About filter search?

Or by global variables?

In VBA it would be no ding but Powerapps in quite new to me....

Can someone of you experts help me?

Thanks

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (2)

Sort by

Gerard Simpson 2,987 Moderator on at

Like (1)

Report
Copy link

Link copied!

Hi @Digitalartnet

Add this filter expression to the 'Items' property of your Gallery:

Filter(
YourListName,
LengthFieldName >= 390 && LengthFieldName <= 420
)

Then add labels to your gallery to surface whatever fields from your filtered dataset (in each label text property eg 'ThisItem.LengthFieldName' / 'ThisItem.WidthFieldName'/ 'ThisItem.HeightFieldName'

Note the filter statement above is obviously hardcoded as 390 to 420, but you could have two text input controls above your gallery (say Textinput1 and TextInput2 for lower and upper length bounds) - then feed those figures dynamically into your filter statement like as follows:

Filter(
YourListName,
LengthFieldName >= Value(TextInput1.Text) && LengthFieldName <= Value(TextInput2.Text)
)

(Note your TextInputs#.Texts are wrapped in Values above to ensure data types match, but in most cases Power Apps is clever enough to recognise the number in the text inputs and the Value(..) aspect is not required.

Hope this helps

Was this reply helpful? Yes No
Digitalartnet 24 on at

Like (1)

Report
Copy link

Link copied!

Thanks first of all for your time!
I'll try it with your code. I hope it will work?
Thanks
PS: I'll get back to you if it doesn't work, but then with the textboxes code...

Was this reply helpful? Yes No
Digitalartnet 24 on at

Like (0)

Report
Copy link

Link copied!

Yes Nice Thx 🙂

My Code Names

Filter(
[@Tbl_Datenbank];
Länge >= Value(Lbl_Länge_min.Text) && Länge <= Value(Lbl_Länge_max.Text)
)
Would I put an (And) in between if I had this searched on 6 text boxes?
e.g.
Length_Min Length_Max And Width_min Width_max And Height_min Height_max

Was this reply helpful? Yes No
Verified answer

Gerard Simpson 2,987 Moderator on at

Like (1)

Report
Copy link

Link copied!

@Digitalartnet

Yeah, you can just add further logical tests by separating them with a comma ',' (same as And/&& 🙂 )

Filter(
[@Tbl_Datenbank];
Länge >= Value(Lbl_Länge_min.Text) && Länge <= Value(Lbl_Länge_max.Text),
Width logical test,
Height logical test
)

If you found this helpful, please mark as a solution and drop a 👍

All the best!

Was this reply helpful? Yes No
Verified answer

Digitalartnet 24 on at

Like (0)

Report
Copy link

Link copied!

Filter(
[@Tbl_Datenbank];
Länge >= Value(Lbl_Länge_min.Text) && Länge <= Value(Lbl_Länge_max.Text)
And

Breite >= Value(Lbl_Breite_min.Text) && Breite <= Value(Lbl_Breite_max.Text)
And

Höhe >= Value(Lbl_Höhe_Min_1.Text) && Höhe <= Value(Lbl_Höhe_max_1.Text)
)

Thx @AmDev

Was this reply helpful? Yes No