Modern control drop down is finicky

(1) Share

Report

Posted on by CedarTree72

153

Hi. I'm successfully added a modern control drop-down that correctly grabs the "options" I want to choose from. But the default value it shows in a table of rows is not the actual underlying value in SQL server, but blank. I've tried setting DefaultSelectedItems = ThisItem.TheFieldInQuestion or {Value:ThisItem.TheFieldInQuestion}. Still nothing. Except for one random time, that did seem to work??? Please help!? Thanks!

I have the same question (0)

All responses (5)

Answers (0)

v-qiaqi@microsoft.com on at

Like (0)

Report

Re: Modern control drop down is finicky

HI @CedarTree72,

What is the column type of this TheFieldInQuestion in your SQL table?

You need to access to the column value within the table data of TheFieldInQuestion column.

Was this reply helpful? Yes No
CedarTree72 153 on at

Like (0)

Report

Re: Modern control drop down is finicky

It 's a text field in both the dropdown options table in SQL server (listTable) and the underlying table that stores the data in SQL server (tblTable), i.e., nvarchar(100). @v-qiaqi-msft

Edit: And I sometimes see "INJECTO" in the dropdown field???

Was this reply helpful? Yes No
v-qiaqi@microsoft.com on at

Like (0)

Report
Re: Modern control drop down is finicky

Hi @CedarTree72,

Try

{TheFieldInQuestion:ThisItem.TheFieldInQuestion}

Was this reply helpful? Yes No
PA_Forum_User 68 on at

Like (0)

Report

Modern control drop down is finicky

Hello @CedarTree72

Did you find out any solution for your problem?

Hello @v-qiaqi@microsoft.com

Your soludion does not work, unfortunatley, but thanks for trying.

Was this reply helpful? Yes No
Suggested answer

CodeAvenue 103 on at

Like (0)

Report

Modern control drop down is finicky

This error gave me a run for my money but I finally nailed it based on answer from @v-qiaqi@microsoft.com

And now it makes a lot of sense when you think about it. By the way, the solution below for Dataverse table.
For SharePoint List the DefaultSelectedItems = ThisItem.Status

1. So you first set the items property to the Choice field.

Items =
Choices([@ISSDE_Taskss].cr23f_status)

2. Then go to the Display of the Property and add the "Value" field.

3.Finally, in the DefaultSelectedItems, set it to this.

DefaultSelectedItems=
{Value:ThisItem.'Status (cr23f_status)'}

Was this reply helpful? Yes No