Setup a Gallery datasource from a SharePoint TEXT column

[Anonymous]

Hi Folks,

One more crazy question:

Please check the attached image.
I have one list with the form names and a reference to other lists (List Name).

List Structure (DropDown)

Form Name | Description | Web Link | List Name

Each FORM NAME is a Powerapps form I built (see the yellow square on the image).

I populated a Dropdown with that List and now I need to populate the Gallery depending on the form I select on the Dropdown.
So, a column called LIST NAME (text column) is the LIST with all data inserted RED SQUARE.

So that's my problem, I need to dynamically change the Gallery Datasource when I select a different item from the dropdown.

I would say, I need to transform the TEXT column info, into a Gallery DataSource (LIST NAME) depending on the selection.

The GREEN buttons will open the form with the selected record, but this part is ok, working.

Is that clear?

Thanks.

[v-xiaochen-msft · Accepted solution]

Hi @Anonymous ,

You could not directly convert a text into a list name.

However, you could use If() functon to dynamically change the gallery items property.

1\ I have two lists "LIST83" and "LIST84".

2\ Add a dropdown control 'Dropdown1' and set its Items property to:

Table({Value:"LIST83"},{Value:"LIST84"})

3\ Add a gallery control and set its Items property to:

If(Dropdown1.Selected.Value="LIST83",LIST83,Dropdown1.Selected.Value="LIST84",LIST84)

4\ The result is as follows:

Best Regards,
Wearsky
If my post helps, then please consider Accept it as the solution to help others. Thanks.

[Anonymous]

Many thanks Wearsky