Answered

Default in dropdown from variable

(1) Share

Report

Posted on by Phil2222

Hi,

I have a variable (varSite) that stores a site name based on a selected item from a Modern Table. I am then trying to set the default value of a form control based on the variable, but for some reason it does not display even though the variable contains the correct information. The Site Name dropdown does show all the site names from a Sharepoint Lookup, which works as it should. Can somebody please point me in the right direction to what I am doing wrong, I include screenshot below.

Many Thanks

Phil

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (1)

WarrenBelz 153,117 Most Valuable Professional on at

Like (1)

Report
Hi @Phil2222,

What is missing here is the Items of that Combo Box and the resulting output/DisplayFields. It is not .Value, using the actual field name displayed the DefaultSelectedItems should be
{FieldName: varSite.Value}

If it is .Value, your issue is that varSite contains other fields, so you need to be specific
{Value: varSite.Value}

Please click Does this answer your question if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it a Like.
Visit my blog Practical Power Apps LinkedIn

Was this reply helpful? Yes No
WarrenBelz 153,117 Most Valuable Professional on at

Like (0)

Report

Hi @Phil2222,

A quick follow-up to see if you received the answer you were looking for or if you need further assistance.

Please ✅Does this answer your question if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it a Like.
Visit my blog Practical Power Apps LinkedIn

Was this reply helpful? Yes No
Phil2222 35 on at

Like (0)

Report

Thanks @WarrenBelz

I did manage to get this to work as per the below images. However, when I submit the form this column sometimes remains blank in my SharePoint list, although all other columns in the form save ok, this one, sometimes it does and sometimes it doesn't and I can't figure out why. It is meant to save back to a SharePoint Lookup column, is this the possible the problem.

Thanks in advance

Phil

Was this reply helpful? Yes No
Verified answer

WarrenBelz 153,117 Most Valuable Professional on at

Like (0)

Report
Hi @Phil2222,

A lookup column - that makes it even more complicated. These will generally cause you nothng more than unwanted and unnecessary complication- I never use them. The issue is that they are a complex field type and need to contain the ID of the record in the other list being looked up. Assuming for the moment that .Value is the output of the control, the DefaultSelectedItems should be
{ Value: varSite.Value, Id: LookUp( YourLookedUpListName, YourLookedUpFieldName = varSite.Value ).ID }

Note the difference case of Id in the field and ID in the other list.

Please ✅ Does this answer your question if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it a Like♥.
Visit my blog Practical Power Apps LinkedIn

Was this reply helpful? Yes No
Phil2222 35 on at

Like (0)

Report

@WarrenBelz Thank you for your help, this is working as expected now.

Just out of interest, how would you recommend dealing with the SharePoint Lookup field in future, or maybe I will even try it in this scenario.

Thanks again

Phil

Was this reply helpful? Yes No
WarrenBelz 153,117 Most Valuable Professional on at

Like (0)

Report

Hi @Phil2222,

A SharePoint Lookup column has very limited effective usage with Power Apps as SharePoint is not a Relational database and almost all "relationships" can be managed by Power Apps directly as it has access to all data sources involved. If you are only using it to access the "looked-up" field, use a Single Line of Text field in the "primary" List and get the options from the "looked-up" list in your drop-down directly from the second list.

You will enhance Delegation management (you cannot delegably Sort by or use StartsWith on a Lookup column and they are much more complex to read from/write to).

Was this reply helpful? Yes No