cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
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
Highlighted

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
Highlighted
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!

Highlighted

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
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

News & Announcements

Community Blog

Stay up tp date on the latest blogs and activities in the community News & Announcements.

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors
Users online (8,012)