Retreiving semicolon separated value from single line of text in combobox

(0) Share

Report

Posted on by Poweruser32490

I am trying to retrieve semicolon separated multiselect lookup value from single line of text in EditForm combobox default selected items, but the values are not retrieved properly.

May i know what is the issue here?

Single Line of Text column value

fXXXXaa-XXX-f011-XXXX-XXXXX;f7XXX5aa-0d73-XXXX-XXXX

Combobox Default Selected Items

ForAll(
    Split(
        ThisItem.'Account (Text)',
        ";"
    ),
    LookUp(
        'Account',
        Account = ThisItem.'Account'.Account
    ).'Account Name'
)

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (1)

Answers (0)

Suggested answer

venturemavenwill 1,189 Super User 2025 Season 2 on at

Like (0)

Report
Retreiving semicolon separated value from single line of text in combobox

Try to save the result of the split in a variable first and loop through that like this:

With( {_selectedAccountNamesCollection: Split(ThisItem.'Account (Text)', ";")}, ForAll( _selectedAccountNamesCollection, LookUp('Account', Account = ThisRecord.Value).'Account Name' ) )

Let me know if this works.

Was this reply helpful? Yes No