Multiselect People Type Column - Default selected Items of Combo box

(0) Share

Report

Posted on by Danny_Dicaprio

Hi Everyone,

I have created a user table (system table) in Dataverse that stores user details.

I have a Combo Box in my PowerApps where the items property is set to "Users" (inside a Custom DataCard).

Items: Users
Default Selected Items: [ThisItem.'Step 1_ID Stage _Additional Edit Access']

On selecting the button, I am patching the details from the Combo Box into the Dataverse table, and the details are getting stored perfectly.

"Step 1_ID Stage _Additional Edit Access" is a single line of text Email column in my Dataverse table.

However, when the form opens in edit mode, the selected items in the Combo Box are not showing up and appear blank.

Could anyone please help me to fix the Default Selected Items property of the Combo Box to retrieve the details from the

Dataverse table correctly?

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (8)

Answers (1)

Ami K 15,674 Super User 2024 Season 1 on at

Like (0)

Report
@Danny_Dicaprio - on the DefaultSelectedItems property, try:

LookUp( Users, 'Primary Email' = Parent.Default )

Was this reply helpful? Yes No
Danny_Dicaprio on at

Like (0)

Report
Hi @Amik

Thanks for the response

it is showing some error as Default isn't "recognized "

I tried adding following formula, but that also not working

If(

!IsBlank(ThisItem.'Step 1_ID Stage _Additional Edit Access'),

[LookUp(Users, 'Primary Email' = Trim(ThisItem.'Step 1_ID Stage _Additional Edit Access'))],

[]

)

Was this reply helpful? Yes No
Ami K 15,674 Super User 2024 Season 1 on at

Like (0)

Report
@Danny_Dicaprio -

1. Is there a reason you're using a Custom DataCard as opposed to the DataCard for the "Step 1_ID Stage _Additional Edit Access" field?

2. What is the reason for using Patch rather than the SubmitForm function?

I would have expected the following set up:

1. Add the "Step 1_ID Stage _Additional Edit Access" (Single Line Text) field into your EditForm as a DataCard

2. Unlock the DataCard

3. Insert a ComboBox control into that DataCard

4. Set the Items property of the CombBox control to:

Users

5. Delete the Text Input control inside the DataCard

6. Address the Y error by instead referencing the ComboBox control instead

7. Set the Update property of the DataCard to:

'Your ComboBox Name'.Selected.'Primary Email'

8. Set the DefaultSelectedItems property of the ComboBox control to:

LookUp( Users, 'Primary Email' = Parent.Default )

Was this reply helpful? Yes No
Danny_Dicaprio on at

Like (0)

Report

HI @Amik

Sorry for the duplicate post, I didn't know we can raise a separate issue for Dataverse

I tried the above approach, but the combo box selected item was showing "System"

But we have the email Id's in the column for that record

Was this reply helpful? Yes No
Danny_Dicaprio on at

Like (0)

Report

Hi @Amik

Sorry for the delayed response

The value is showing up right now, but the emails are not getting stored Multiple

only the last selected email is showing up in the Combo box

My column is a single line of text _ Email Column_in Dataverse

Through patching I was able to patch multiple emails into that column

Is there is any work around for this

Was this reply helpful? Yes No
Verified answer

Ami K 15,674 Super User 2024 Season 1 on at

Like (0)

Report
@Danny_Dicaprio - apologies I need to do a better job at reading the question.

For a Multi-Choice ComboBox, you will need a Multi-Line Text data type to accommodate the length of characters:

1. In the Items property, use:

Users

2. On the DefaultSelectedItems property,

ForAll( Split( ThisItem.'Your Multi Line Text Column', ";" ), LookUp( Users, 'Primary Email' = Value ) )

3. On the Update property of the DataCard:

Concat( 'Your ComboBox'.SelectedItems, 'Primary Email', ";" )

Was this reply helpful? Yes No
Danny_Dicaprio on at

Like (0)

Report

HI @Amik

Sorry for this amateur question, Iam new to Dataverse ,

Is there is any way from this we can change the column type to multiline text ?

Was this reply helpful? Yes No
Ami K 15,674 Super User 2024 Season 1 on at

Like (0)

Report

@Danny_Dicaprio - not possible out-of-the-box. You will need to use an external API like XRMToolBox to change field data types.

Further reading: https://www.xrmtoolbox.com/plugins/DataverseFormatChanger/

Was this reply helpful? Yes No