Answered

Cannot set default lookup value on a CDS field

(1) Share

Report

Posted on by testasdfasfsafa

309

I have a CDS data source (dynamics 365) powering an Edit form. The edit form is set to "new" form so a user can fill-in the form. I have some lookup fields and that needs to be set to a default value. Normally, I simply type the value text like "UPS" or "FEDEX" and it works fine. But using CDS as the source, PowerApps keeps return error. I search everywhere, but can only find sharepoint example with ODATA.

I tried to type the actually GUID "1f865925-843c-e911-a971-000d3a34a14b" of lookup time and even type the text value "UPS" , no luck 😞

I'd appreciate if anyone could share how they were able to setup default values coming from CDS. Thanks.,

Default Text based value.png

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (7)

Answers (1)

CU22081450-0 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hi @testasdfasfsafa ,

This property needs to insert the Record value. We can use this sample below:

Default --> First(Filter(YourCARRIEREntity, "new_name" = "UFS"))

---
If you like this reply, please give kudos. And if this solves your problem, please accept this reply as the solution.
Thanks!
Renato Romão
https://www.linkedin.com/in/renatoromao/

Was this reply helpful? Yes No
testasdfasfsafa 309 on at

Like (1)

Report
Copy link

Link copied!

Thank you so much for the expert advice!! Your suggestion seems to make perfect sense. There is no error anymore :), but the default value doesn't show up when I run the app... Any thoughts?

Was this reply helpful? Yes No
CU22081450-0 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!

Are there any options when you open the Carrier dropdown?
If yes, can you check if it has the "UPS" value?
If yes, can you check if it shows the "new_name" column?
If yes, try to change the code to First(Choices(@[...].new_Carrier)) instead of First(Filter(...))

---
If you like this reply, please give kudos. And if this solves your problem, please accept this reply as the solution.
Thanks!
Renato Romão
https://www.linkedin.com/in/renatoromao/

Was this reply helpful? Yes No
testasdfasfsafa 309 on at

Like (0)

Report
Copy link

Link copied!

First of all, let me express my gratitude for your guidance with this challenging topic...

You said..
Are there any options when you open the Carrier dropdown? YES
If yes, can you check if it has the "UPS" value? YES
If yes, can you check if it shows the "new_name" column? (not sure where to look for that question)
If yes, try to change the code to First(Choices(@[...].new_Carrier)) instead of First(Filter(...)) I tried, but I'm afraid I have a syntax issue.

I'm sorry, I'm not a true developer but a poweruser... Here's what I have now... I feel it's like 99% there...

Was this reply helpful? Yes No
Verified answer

CU22081450-0 Most Valuable Professional on at

Like (2)

Report
Copy link

Link copied!

@testasdfasfsafa ,

No worries! 🙂
I checked here, and you can use:
DefaultSelectedItems --> First(Filter(Carrier, new_name = "UPS"))

2 changes:
- Default to DefaultSelectedItems
- "new_name" to new_name

---
If you like this reply, please give kudos. And if this solves your problem, please accept this reply as the solution.
Thanks!
Renato Romão
https://www.linkedin.com/in/renatoromao/

Was this reply helpful? Yes No
testasdfasfsafa 309 on at

Like (1)

Report
Copy link

Link copied!

Wow, that was it!! It works just fine now 🙂

I wish I can send more then Kudos!! (and wish Microsoft would spend more time documenting their tools).

BTW, does the filter approach would also work for choice columns (instead of lookups)?

Was this reply helpful? Yes No
CU22081450-0 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hi @testasdfasfsafa ,

Nice! 😄

No, we just use "UPS" if it is a choice column.

Was this reply helpful? Yes No