Help Matching 2 Vectors

[efroseroc]

I want to create some controls that feed a single text column in my data source.

the result would be the following: [Jhon,Mark;Jacob] -> Text column1

And                                                 [10,50,30]              - > Text column 2

I want to display in another screen a dropdown with column 1 and when you select item 1 (Jhon) you get item 1 in column 2 (10).

Is there a way to achieve this?

Thanks in advance

[rubin_boer · Accepted solution]

hi @efroseroc 

you can try the following:

datasource: colVector

ClearCollect(
    colVector,
    {
        name: "John,Mark,Jacob",
        values: "10,50,30"
    }
)

to illustrate lets add this to a gallery with source: colVector

this gallery have the following code OnSelect

ClearCollect(
    colSomeData,
    With(
        {
            _source: Split(
                Gallery4.Selected.name,
                ","
            )
        },
        ForAll(
            Sequence(CountRows(_source)),
            {
                name: Index(
                    _source,
                    Value
                ).Result,
                id: Value
            }
        )
    )
)

 the result here is a collection with the names in one column (name) and the values in another column (values)

Add a DropDown and set its Items to colSomeData as collected in the gallery's OnSelect above

Add label and set it to the follwing

Index(Split(theGalleryYouAdded.Selected.values,","),Dropdown1.Selected.id).Result

Result

Hope it helped 

R