cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
MShelnutt
Helper IV
Helper IV

SharePoint ID column

Hi,

 

I need to put a Filter or Search box in my PowerApp so the user can filter the Gallery by the ID column in my connected SharePoint list.

I found this formula on another post, but am not clear on what the "a" and "b" are:

 

Search(
       AddColumns(my_SP_List,"id2",Text(ID)), 
       TextSearchBox1.Text,
       "a", "b", "id2")

 

Any ideas?

Because I have 3 Search boxes:  By Customer Name or RMA#, by CC# {The ID column of SharePoint}, and by Status- so I need to have a Search function in my Gallery Items setting to allow for all three:

 

MShelnutt_1-1616500176335.png

 

 

39 REPLIES 39
RandyHayes
Super User III
Super User III

@MShelnutt 

Click on the Customer Name

RandyHayes_0-1616526273426.png

And tell me what the Real name of the column is.

 

Yes, if you received that message about the column, then you are not using the real name.

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

@RandyHayes 

It shows the same thing-

MShelnutt_0-1616526435655.png

 

@RandyHayes 

When I add the space in the Items property of the gallery, it throws the red squiggle and this error message-

 

MShelnutt_0-1616526937665.png

 

RandyHayes
Super User III
Super User III

@MShelnutt 

I need to know the real name of the column to be certain.

 

As I mentioned to you...

Go into the settings of the list and then to the settings of that column.  Once you are in that definition, look at the end of the URL, it will show field=<something> 
What is that something?

 

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

@RandyHayes 

MShelnutt_0-1616527226210.png

 

wow, it does not have a space!

 

RandyHayes
Super User III
Super User III

@MShelnutt 

Okay good...then that is the real name.  Always need to be sure before going down a rabbit hole.

 

So, let's go back to the formula again and see what is the issue.

Change the formula to the following:

Search( 
    Search(
        'Customer Complaints 21',
        NameBox.Text, "CustomerName"
    ),
    RMABox.Text, "RMA_x0020_Number" 
)

This excludes the inner part of the Search 1 (which we have now verified returns information properly).

 

In this test we are only concerned over the text you enter into NameBox in regard to searching CustomerName

 

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

@RandyHayes 

No data after paren, and no results on App Play.

RandyHayes
Super User III
Super User III

@MShelnutt 

So then there is something that is mismatched.  NameBox is the name of your Filter By Customer Name control on your screen.  If so, then whatever is typed there should show results based on searching the CustomerName column in your list.  The search function is very forgiving and will find anything in that customername column that matches.  So, if it is finding nothing, then either what you're entering in is not in the list or there is something wrong with the data in the list.  

 

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

@RandyHayes 

I'm not sure why, but when I came in this morning, and of course my Power App asked if I wanted to Resume the Session, and I clicked yes- it reloaded and it was working.  I put the correct Items Search formula back in, and everything is functioning correctly now.  Typical Microsoft behavior I guess- like having to restart your computer when bugs start occurring.  Thank you Randy.

RandyHayes
Super User III
Super User III

@MShelnutt 
Actually, when you start to modify the signature of a record in your app design, the designer "locks on" to that column change and retains it.

The designer has to infer the schemas for records base on what you have in your formulas.  Very common to have this happen as you are designing and perhaps changing schemas in many places.

 

So, the only way to "clear" it is to save, exit and then come back in.

 

Sounds like you are golden now though!! 

 

 

 

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

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

secondImage

Demo Extravaganza is Back!

We are excited to announce that Demo Extravaganza for 2021 has started!

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

Power Apps June 2021

June Power Apps Community Call

Don't miss the call this month on June 16th - 8a PDT

Top Solution Authors
Top Kudoed Authors
Users online (94,801)