cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Frequent Visitor

How to set 2 Search field in Powerapps

I am developing PowerApps and Getting error while setting 2 search field.

1st Search by ID( ID is autogenerated 1,2,3...) Error: expecting field Text. Invalid Type

2nd Search by Created BY (It's default one, lets say I create report so by default my name will be at on created by) Error: While putting the condition I didn't get the Created BY field on dropdown list to select. like say Search(ObservationReport, TextBoxSearch1, "ID", "CreatedBy") <- here Its showing error. Can i select Datacardvalue of Created By?

 

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Super User
Super User

Re: How to set 2 Search field in Powerapps

My bad, try this: 

 

Search(AddColumns(ENTITY, "ID_Text", Text(ID), "CreatedBy_Text", 'Created By'.'Full Name'), TextSearchBox2.Text,"ID_Text","CreatedBy_Text")

 

Changed the highlighted part. 

 

---
If you like this reply, please give kudos. And if this solves your problem, please accept this reply as the solution. Thanks!

Hardit(Haman)

View solution in original post

7 REPLIES 7
Highlighted
Super User
Super User

Re: How to set 2 Search field in Powerapps

@jaypatel 

Can you please show a screenshot of each error highlighted in the formula bar?  Even better if the complete error message is showing.

Highlighted
Super User
Super User

Re: How to set 2 Search field in Powerapps

Hi, 

 

Try this: 

 

Search(AddColumns(ENTITY, "ID_Text", ID, "CreatedBy_Text", 'Created By'.'Full Name'), TextSearchBox2.Text,"ID_Text","CreatedBy_Text")

 

Let me know if this doesn't work. 

 

---
If you like this reply, please give kudos. And if this solves your problem, please accept this reply as the solution. Thanks!

Hardit(Haman)

Highlighted
Frequent Visitor

Re: How to set 2 Search field in Powerapps

Getting Error! Kindly see Attached picture

Highlighted
Frequent Visitor

Re: How to set 2 Search field in Powerapps

Kindly see Attached Pic.

Highlighted
Super User
Super User

Re: How to set 2 Search field in Powerapps

My bad, try this: 

 

Search(AddColumns(ENTITY, "ID_Text", Text(ID), "CreatedBy_Text", 'Created By'.'Full Name'), TextSearchBox2.Text,"ID_Text","CreatedBy_Text")

 

Changed the highlighted part. 

 

---
If you like this reply, please give kudos. And if this solves your problem, please accept this reply as the solution. Thanks!

Hardit(Haman)

View solution in original post

Frequent Visitor

Re: How to set 2 Search field in Powerapps

Thank You Very much!! 

Highlighted
Super User
Super User

Re: How to set 2 Search field in Powerapps

Glad I could help!

Helpful resources

Announcements
August 2020 Community Challenge: Can You Solve These?

August 2020 Community Challenge: Can You Solve These?

We're excited to announce our first cross-community 'Can You Solve These?' challenge!

secondImage

Return to Workplace

Reopen responsibly, monitor intelligently, and protect continuously with solutions for a safer work environment.

secondImage

Super Users Coming in August

We are excited for the next Super User season.

secondImage

Community User Group Member Badges

FIll out a quick form to claim your community user group member badge today!

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors
Users online (8,340)