Search function on a CDS research field

(0) Share

Report

Posted on by Kesh

230

Hi, I have an issue with the search() function.

I want to use the search function based of the culumn of a CDS entity.

For example I want to have all the users ("User" entity) witch are based in a specific country using a (custom) field named "Based_on_Country" witch is related to the country "entity"

So I made this function:

Search(User;"England";'Based_on_Country'.Name)

There is an error telling me that search() function is waiting for a text value.

In CDS the culumn Name of the Country entity is a text. I tried to use the text() function with Text(Based_on_Country'.Name) but I have another error on the text() function.

I don't know what to do...

Can someone help me ?

Kind regards

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Sort by

Verified answer

PowerAddict 7,316 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Can you try something like?

Search(AddColumns(Users, "CountryName", Based_on_Country.Name), "England", "CountryName")

or

Search(AddColumns(Users, "CountryName", Text(Based_on_Country.Name)), "England", "CountryName")

Let me know if either one works.

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

Hardit Bhatia
https://www.thepoweraddict.com

Was this reply helpful? Yes No
Kesh 230 on at

Like
a
(0)

Report
Copy link

Link copied!

Thank you it works perfectly without the text() function.
Kind regards

Was this reply helpful? Yes No
PowerAddict 7,316 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Glad I could help! Good luck with the rest of the app! Feel free to reach out in case of any questions!

Thanks,
Hardit Bhatia
https://thepoweraddict.com

Was this reply helpful? Yes No