How to set 2 Search field in Powerapps

[jaypatel]

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?

[mdevaney]

@jaypatel 

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

[PowerAddict]

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)

[jaypatel]

Getting Error! Kindly see Attached picture

[jaypatel]

Kindly see Attached Pic.

[PowerAddict · Accepted solution]

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)

[jaypatel]

Thank You Very much!! 

[PowerAddict]

Glad I could help!