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!
User | Count |
---|---|
198 | |
124 | |
88 | |
48 | |
40 |
User | Count |
---|---|
277 | |
166 | |
138 | |
82 | |
76 |