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?
Solved! Go to 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)
Can you please show a screenshot of each error highlighted in the formula bar? Even better if the complete error message is showing.
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)
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)
Thank You Very much!!
Glad I could help!
Stay up tp date on the latest blogs and activities in the community News & Announcements.
Dive into the Power Platform stack with hands-on sessions and labs, virtually delivered to you by experts and community leaders.
User | Count |
---|---|
213 | |
198 | |
83 | |
59 | |
38 |