web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps DefaultSelectedItems f...

Power Apps

Answered

DefaultSelectedItems for a DropDown with multiple values based on a string

(0) Share

Report

Report

Posted on by wit4r7

33

Hi,

I'm currently developing an SharePoint Form, with multiple lookups and filtered dropdown's.

As a result I have the following setup:

I have a datacard, which contains a Dropdown (PowerApps control element). The SharePoint column is a Single line of text.

The Dropdown is filtered based on different selection in the form. The dropdown has multi selected turned on.

I save the value from the Datacard using a Concat formula:

Concat(drpTechnician.SelectedItems;'Name (technician)'& ",")

The Value is stored in the SharePoint Column as desired. (Name1,Name2,Name3,...)

My problem: I"m not able to set the DefaultSelectedItems for this Dropdown when the Form is opened again in Edit-Mode. Then the dropdown is empty.

When using something like

{Value:Split(Parent.Default);",")}

I get an (object object) in the dropdown.

So, I"m thankful for any help.

Best regards,

PS: I can"t switch the type of the column. It needs for dependences a single line field

Categories:

Building Power Apps

All responses Img

All responses (1)

Answers Img

Answers (1)

Verified answer

wit4r7 33 on at

Like
a
(0)

Report
Copy link

Link copied!
I solved after trying a lot of different approaches.

What I did: I created a New Filter
Filter('TechnicianList';'Technician)' in Split(Parent.Default;","))

The filter reads the list with all values and filters the column technician using the "in" function in the table created by the Split function.

Join the conversation