cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
rcarneiroIE
Helper I
Helper I

Setup a Gallery datasource from a SharePoint TEXT column

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.

 

1 ACCEPTED SOLUTION

Accepted Solutions
v-xiaochen-msft
Community Support
Community Support

Hi @rcarneiroIE ,

 

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:

AAA.gif

 

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

View solution in original post

2 REPLIES 2
v-xiaochen-msft
Community Support
Community Support

Hi @rcarneiroIE ,

 

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:

AAA.gif

 

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

View solution in original post

rcarneiroIE
Helper I
Helper I

Many thanks Wearsky

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Welcome Super Users.jpg

Super User Season 2

Congratulations, the new Super User Season 2 for 2021 has started!

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Users online (1,770)