Dropdown value set automatically

(0) Share

Report

Posted on by Unbihexium

180

Hello all,

requesting help for the following;
In Powerapps I have a dropdown which comes from a SharePoint list,
this column in the SharePoint list get its information from another SharePoint list (lookup).

in Powerapps
I want to set the dropdown value according to an other field automatically.
see screenshot (I want the same value as the datacardvalue have)
the value is available in the dropdown but I dont know how to set this correctly.

I have tried several things with the "DefaultSelectedItems" property but nothing works.
for example I've tried {Value: DataCardValue54.Text}
but this only adds a text value in the dropdown and after submitting the form the column is empty.
also setting a variable for the DataCardValue54 but doesnt work.

I also tried with lookup
LookUp('Interne Bestellungen - Bestellpositionen'; 'Bestell ID_Match'.Value = DataCardValue54.Text)

LookUp('Interne Bestellungen - Bestellpositionen'; 'Bestell ID_Match'.Value = ThisItem.Bestell-ID) etc...
but this doesn't work either

can someone help me achieve this?

Thanks in advance
regards

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (0)

VeGETzX 367 on at

Like (1)

Report
Copy link

Link copied!

Try put this code into Update property of your Bestell ID_Match_DataCard5

{
Id: LookUp('Interne Bestellungen - Bestellpositionen'; 'Bestell ID_Match'.Value = DataCardValue54.Text).ID,
Value: DataCardValue54.Text
}

Patching lookup column is a bit tricky because you will strictly need to provide a record that have ID and Value as it input.

Was this reply helpful? Yes No
Unbihexium 180 on at

Like (0)

Report
Copy link

Link copied!

Hi VeGETzX
Thank you very much for your reply.

I've tried as you recommanded, I've put the code in the "Update" property of the DataCard "Bestell ID_Match_DataCard5"
unfortunately no dropdown choice was made and also after submitting the column was empty.

I've also delete the Data Card and added new in case I've messed up the card before, but still get no auto choice in that dropdown.

Thanks again!
best regards

Was this reply helpful? Yes No