cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
ArneVTR
Regular Visitor

Making a list of tables to open the table you wish to edit

Hello

I am making a PowerApp to edit multiple different Excel tables. If I were to make seperate screens for every table I have I would need over 300 screens... I now have a table with an overview of the names from available tables (generated as Strings). (See image 1.) So if I click on one of my test table names it should open the correct table in a new screen.

I tried using a global variable to save the name of the table you click on as 'TabelKeuze'. So that I could use it to open te corresponding table (see image 2, 'Search([@TabelKeuze];') in a new screen. The problem is that my global variable is a String (the name of the table) and not the table itself, so PowerApps cannot open the table on the new screen. Is there a way to use the String to open the correct table?

Cheers

Arne

image.png

image.png

1 ACCEPTED SOLUTION

Accepted Solutions

Hi @ArneVTR ,

I'm afraid it's not supported to use variable to represent table name in the search function currently in PowerApps.

For now, you could only use the tablename itself directly in this function.

Here's a doc about this function for your reference:

https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/functions/function-filter-lookup

 

Based on your description, do you mean that you have many tables with the same structure?

Maybe you could consider using group or component to reduce development complexity.

Many repetitive operations can be omitted, which could save munch time.

Here are docs about group and component for your reference:
https://powerapps.microsoft.com/en-us/blog/enhanced-group-experimental-control-with-layout-control-a...

https://powerapps.microsoft.com/en-us/blog/components-available-in-preview/

 

 

Best regards,

Community Support Team _ Phoebe Liu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

2 REPLIES 2
ArneVTR
Regular Visitor

I currently worked around it by making one big Switch-statement, this works but is a bit of a mess with around 100 options. Any better solution would be helpfull!

Hi @ArneVTR ,

I'm afraid it's not supported to use variable to represent table name in the search function currently in PowerApps.

For now, you could only use the tablename itself directly in this function.

Here's a doc about this function for your reference:

https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/functions/function-filter-lookup

 

Based on your description, do you mean that you have many tables with the same structure?

Maybe you could consider using group or component to reduce development complexity.

Many repetitive operations can be omitted, which could save munch time.

Here are docs about group and component for your reference:
https://powerapps.microsoft.com/en-us/blog/enhanced-group-experimental-control-with-layout-control-a...

https://powerapps.microsoft.com/en-us/blog/components-available-in-preview/

 

 

Best regards,

Community Support Team _ Phoebe Liu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Power Apps Community Call Jan. 2022 768x460.png

Power Apps Community Call

Please join us on Wednesday, January 19th, at 8a PDT. Come and learn from our amazing speakers!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Top Solution Authors
Top Kudoed Authors
Users online (1,301)