web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Adding list of connect...
Power Apps
Unanswered

Adding list of connected data sources to a combobox.

(1) ShareShare
ReportReport
Posted on by 7

Good morning all,

 

I'm trying to create a list of all tables that are connected to a Power App and display this in a Combobox.

 

The selected table would then be used in a patch statement in the on select property of a button to patch the data to the selected table.

 

The selection would only ever be used once on app load so doesn't need to keep refreshing when you add and remove tables.

 

I'm struggling to find a way to do this, is it something that might be possible or is it a pipe dream?

Categories:
I have the same question (0)
  • Verified answer
    iAm_ManCat Profile Picture
    18,228 Most Valuable Professional on at

    Pipe dream unfortunately, have been there and tried 🙂

     

    This would be great, but you can't use the datasources as a referenceable list like that, and definitely not dynamically.

     

    I would (and have) instead have a dropdown that sets a variable to a text value of the datasource name - then multiple if conditions within each action button/initiator that does a different patch to a different datasource depending on what the text value of the variable is.

     

    (pseudocode here)

    If(gbl_DatasourceChosen = "Data A",
     Patch('Data A',
     Lookup('Data A', ID = 1),
     {
     name: control1.Text
     }
     ),
     gbl_DatasourceChosen = "Data B",
     Patch('Data B',
     Lookup('Data B', ID = 1),
     {
     Email: control2.Text
     }
     ),
     gbl_DatasourceChosen = "Data C",
     Patch('Data C',
     Lookup('Data C', ID = 1),
     {
     name: control3.Text
     }
     )
    )

     

  • VishalJhaveri Profile Picture
    1,167 Moderator on at

    I believe you need to perform join operation and create a collection from all the tables that you are going to use in the combo-box.

    Then use the collection in the combo-box. 

     

  • aaaaaaaaaaaaa12 Profile Picture
    7 on at

    Ok great thank you for the guidance, I'll give them a try.

  • WarrenBelz Profile Picture
    153,034 Most Valuable Professional on at

    @aaaaaaaaaaaaa12 ,

    Please believe @iAm_ManCat here - you cannot do this

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 717 Most Valuable Professional

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 329 Super User 2025 Season 2

#3
Power Platform 1919 Profile Picture

Power Platform 1919 268

Last 30 days Overall leaderboard