You’re offline. This is a read only version of the page.
Hello,
I just do not get any further. My sharepoint list consists of text ( Titel, Adresse...) and number (Nummer) columns.
My BrowseGallery1 query is ok, if I just search for the name from the Title column.(Textsearchbox1)
SortByColumns(Filter([@'Schlüsselraum.iqy-80eafb9d-cf8e-4864-898a-d3b702839f91'];
StartsWith(Title; TextSearchBox1.Text)); "Title"; If(SortDescending1; Descending; Ascending))
To search by number I use the sharepoint list, via the filter function.
That must also work in the Power App, right?
So I want to search for name, address and number in Textsearchbox1.
Is that possible???
In the edit screen is a query like
DataSourceInfo([@'Schlüsselraum.iqy-80eafb9d-cf8e-4864-898a-d3b702839f91'];DataSourceInfo.DisplayName;"field_6")
field_6 denotes a column number or field number. Where are these Datafields displayed like this?
What is field_5? Where can i find it?
Best regards
Hello,
at first... sorry for my bad english. I try it.
My query for keys works with following:
SortByColumns(Filter([@'Schlüsselraum.iqy-80eafb9d-cf8e-4864-898a-d3b702839f91']; Nummer= Value(TextSearchBox1.Text) || StartsWith(Title; TextSearchBox1.Text)); "Title"; If(SortDescending1; SortOrder.Ascending))
but not for Names (Title) anymore.
With
SortByColumns(Filter([@'Schlüsselraum.iqy-80eafb9d-cf8e-4864-898a-d3b702839f91']; StartsWith(Title; TextSearchBox1.Text)); "Title"; If(SortDescending1; SortOrder.Ascending)) works the Search for names
How can i combine both queries???
Thanks Rallf
With({_items: If(IsNumeric(TextSearchBox1.Text);
Filter([@'Schlüsselraum.iqy-80eafb9d-cf8e-4864-898a-d3b702839f91']; Nummer= Value(TextSearchBox1.Text);
Search([@'Schlüsselraum.iqy-80eafb9d-cf8e-4864-898a-d3b702839f91']; TextSearchBox1.Text;
"Adresse" ; "Title")
)}; SortByColumns(_items;"Title"; If(SortDescending1; Descending; Ascending)
)
)
Hello
SortByColumns(Filter([@'Schlüsselraum.iqy-80eafb9d-cf8e-4864-898a-d3b702839f91']; Nummer=Value(TextSearchBox1.Text)... thats ok. Ich can type a number in the TextSearchBox1 field and the result is fine. The Rest
|| StartsWith(Adresse; TextSearchBox1.Text) ||
StartsWith(Title; TextSearchBox1.Text)
); "Title"; If(SortDescending1; Descending; Ascending)) is without a result and without any errors.
SortByColumns(Filter([@'Schlüsselraum.iqy-80eafb9d-cf8e-4864-898a-d3b702839f91']; Nummer=Value(TextSearchBox1.Text) || StartsWith(Adresse; TextSearchBox1.Text) ||
StartsWith(Title; TextSearchBox1.Text)
); "Title"; If(SortDescending1; Descending; Ascending))
Share
Report
47
All responses (
Answers (
