Lookud Dropdown With Default Selected Items

(0) Share

Report

Posted on by maheralkhalil

Hello everyone

I have two list in SP

Table1 Lookup from Table2 (Single line Text field)

I try in PowerApps to make DefaultSelectedItems For Edit Form Dropdown for Table1 based Gallery used Table2

example

for dropdown OrderCode table1 Lookup table2 OrderCode Column I use DefaultSelectedItems is Gallery1.Selected.OrderCode

that on I used with dataverse tables but not working with SP List

is there deferent Formula I have to use

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (1)

SpongYe 5,715 Super User 2025 Season 2 on at

Like (0)

Report
Copy link

Link copied!
Hi @maheralkhalil

Try this:
LookUp( Table2, OrderCode=Gallery1.Selected.OrderCode )
If you have any questions or feedback, please let me know. Have a great day! 😊

-----------------------
PowerYsa Power Platform Enthusiast [LinkedIn] | [Youtube]

I love to share my knowledge and learn from others. If you find my posts helpful, please give them a thumbs up 👍 or mark them as a solution ✔️. You can also check out my [@PowerYSA] for some cool solutions and insights. Feel free to connect with me on any of the platforms above. Cheers! 🍻

Was this reply helpful? Yes No
maheralkhalil 92 on at

Like (0)

Report
Copy link

Link copied!

Thanx for your Replay
I have this With Error

Was this reply helpful? Yes No
SpongYe 5,715 Super User 2025 Season 2 on at

Like (0)

Report
Copy link

Link copied!

Could you also share the error message? The red line?

Was this reply helpful? Yes No
maheralkhalil 92 on at

Like (0)

Report
Copy link

Link copied!

No there no error massage
but data not showing in the DropDown and when submit it data not patch to the table

Was this reply helpful? Yes No
Verified answer

maheralkhalil 92 on at

Like (1)

Report
Copy link

Link copied!

Hello
I try with this:
{'@odata.type':"#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference",
Id: Gallery1_2.Selected.ID,
Value: Gallery1_2.Selected.OrderCode}
It worked perfectly well

Was this reply helpful? Yes No