cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
jaxapmi
Helper I
Helper I

BrowseGallery sortbycolumns thisItem.columnname.displayname - Asset Tracker List

I have created a PowerApp from the Microsoft Asset Tracker Sharepoint list.

I have column called Current owner that is pulls the user name from Exchange.

 

In my Browse Gallery, I want users to be able to search by the Current owner (in Title1).

(Ideally, I'd also like for users to also search by Asset type (in Subtitle1).]

 

Below are screenshots of my Title1-Subtitle1-Body1 fields/settings and the current formula that only allows to sort by Title (renamed to Asset Tag in my Sharepoint list).

 

jaxapmi_0-1614884882650.png

 

jaxapmi_1-1614884897564.png

 

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
RandyHayes
Super User III
Super User III

@jaxapmi 

There was a typo in the formula...Please scrub through the formulas I provide as I type them by hand without the aid of a design editor.

The corrected (hopefully) formula is this:

SortByColumns(
    DropColumns(
        Filter(
            AddColumns(
                'Asset manager - POC1',
                "_asset", 'Asset type'.Value,
                "_owner", 'Current owner'.DisplayName
            ),
            StartsWith(Title, TextSearchBox1.Text) ||
            StartsWith(_asset, TextSearchBox1.Text) ||
            StartsWith(_owner, TextSearchBox1.Text)
        ),
        "_asset", "_owner"
    ),
    "Title"
)
_____________________________________________________________________________________
Digging it? - Click on the Thumbs Up. Solved your problem? - Click on Accept as Solution. Others seeking the same answers will be happy you did.
Check out my PowerApps Videos too!

View solution in original post

7 REPLIES 7
VijayTailor
Resident Rockstar
Resident Rockstar

Hi @jaxapmi ,

Please see the solution for your Issue.

Filter(TestCollNew,StartsWith(TextInput4.Text,Text(equipmentID)) || StartsWith(TextInput4.Text,Text(xvalue))|| StartsWith(TextInput4.Text,Text(yvalue)))

For Reference - 
VijayTailor_0-1614887072006.png

VijayTailor_1-1614887116341.png

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



How is this a solution to my issue? Your example is not a PowerApp BrowseGallery example.

 

 

VijayTailor
Resident Rockstar
Resident Rockstar

Hi @jaxapmi ,

you can Use Same Code for Gallary also ,

See the reference - 

VijayTailor_0-1614887615540.png

Hope that makes you understand.

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

RandyHayes
Super User III
Super User III

@jaxapmi 

To try and put it in context of the original formula and not from another post....

 

Your Formula should be:

SortByColumns(
    DropColumns(
        Filter(
            AddColunmns(
                'Asset manager - POC1',
                "_asset", 'Asset type'.Value,
                "_owner", 'Current owner'.DisplayName
            ),
            StartsWith(Title, TextSearchBox1.Text) ||
            StartsWith(_asset, TextSearchBox1.Text) ||
            StartsWith(_owner, TextSearchBox1.Text)
        ),
        "_asset", "_owner"
    ),
    "Title"
)

 

I hope this is helpful for you.

_____________________________________________________________________________________
Digging it? - Click on the Thumbs Up. Solved your problem? - Click on Accept as Solution. Others seeking the same answers will be happy you did.
Check out my PowerApps Videos too!

Randy - Thank you for connecting to the context of my original question. Sadly, the formula didn't work. Below is a screen shot of what errors I received.

 

jaxapmi_0-1614891004470.png

 

RandyHayes
Super User III
Super User III

@jaxapmi 

There was a typo in the formula...Please scrub through the formulas I provide as I type them by hand without the aid of a design editor.

The corrected (hopefully) formula is this:

SortByColumns(
    DropColumns(
        Filter(
            AddColumns(
                'Asset manager - POC1',
                "_asset", 'Asset type'.Value,
                "_owner", 'Current owner'.DisplayName
            ),
            StartsWith(Title, TextSearchBox1.Text) ||
            StartsWith(_asset, TextSearchBox1.Text) ||
            StartsWith(_owner, TextSearchBox1.Text)
        ),
        "_asset", "_owner"
    ),
    "Title"
)
_____________________________________________________________________________________
Digging it? - Click on the Thumbs Up. Solved your problem? - Click on Accept as Solution. Others seeking the same answers will be happy you did.
Check out my PowerApps Videos too!

View solution in original post

Randy - It worked!!!!! Thank you so, so so very much!!!!

Helpful resources

Announcements
PA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

Power Apps Community Call

Monthly Power Apps Community Call

Did you miss the call?? Check out the Power Apps Community Call here!

secondImage

Experience what’s next for Power Apps

See the latest Power Apps innovations, updates, and demos from the Microsoft Business Applications Launch Event.

Power Platform ISV STudio

Power Platform ISV Studio

ISV Studio is the go-to Power Platform destination for ISV’s to monitor & manage applications post-AppSource publish.

Top Solution Authors
Top Kudoed Authors
Users online (52,604)