web

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

News and Announcements icon

Power Platform CommunityForums Power Apps Gallery sort by status...

Power Apps

Unanswered

Gallery sort by status then other

(0) Share

Report

Report

Posted on by NielsNachtegaal

115

Hi,

Am wondering if this could be done.

I can show a gallery with a onedrive excel table. Checking for the 'status' first, then 'project' and then the 'location'.

Excel onedrive:

SortByColumns(Search([@Table1]; TextSearchBox1.Text; "TotaalGereed";"Project";"Locatie"); "TotaalGereed"; If(SortDescending1; Descending; Ascending))

Works pretty well, but using something like this with a sharepoint table it seems not working at all.

Is there a workarrond for this?

the only thing that works for me right now is.

sharepoint:

SortByColumns(Filter([@FMTproj_DB]; StartsWith(Title; TextSearchBox1.Text)); "Title"; If(SortDescending1; Descending; Ascending))

but that will only show the order by location.

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (0)

Sort by

v-bofeng-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @NielsNachtegaal ,

Do you want to filter the SharePoint list by 'status'/'project'/'location'? If so, could you please show me these columns' name and datatype?

I assume status is choice column and do not allow multiple selections , you could try this formula to filter the data.

Filter([@FMTproj_DB]; StartsWith(Status.Value; TextSearchBox1.Text))

Best Regards,

Bof

Was this reply helpful? Yes No
NielsNachtegaal 115 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi Bof,
Thanks for the reply/sugestion, as it seemed to have some result, altough I Get a handover error, but the 'TotaalGereed' (Title) being 'true' now show on top of the gallery.
What I wanted to achieve, is to have all projects being done sorted top or bottom, and able to search for the location/project. so I can see projects being finnished or not. Sadly with onedrive this works quite well.
Also I posted the table. 'TotaalGereed'(Title) is a bool/chooice and 'Project' is a single line of text)

Was this reply helpful? Yes No

Join the conversation