Skip to main content
News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps - Building Power Apps / Submit data to SQL dat...
Power Apps - Building Power Apps
Unanswered

Submit data to SQL database

(0) ShareShare
ReportReport
Posted on by Community Power Pla...

Hi all,

I am building a PowerApp with PowerBI data source which I am hoping users can select the reason and then submit to database.

 

Here is the script I put on the submit button's On Select

ngct_0-1662365746165.png

 

Could you please advise the error reason and how it could be solved?

Many thanks for that!

 

Categories:
General Questions
  • Community Power Platform Member Profile Picture
    Community Power Pla... on at
    Re: Submit data to SQL database

    @BCBuizer , here is the gallery2 look like.

    All columns are from PowerBI, and I would like update the a SQL table "POWERAPP_REASON_DEMO" with the last column.

    ngct_1-1662371837425.png

     

    ngct_2-1662372077010.png

     

  • BCBuizer Profile Picture
    BCBuizer 22,262 Super User 2025 Season 1 on at
    Re: Submit data to SQL database

    Hi @Anonymous ,

     

    Try adding .Value after Gallery2.Selected.ID.

     

    If that doesn't work, can you share a bit more about Gallery2? What controls are in there, what is the Items property, etc.

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

News and Announcements

Welcome to the Power Platform Communities

Quick Links

Paul Stork – Community Spotlight

We are honored to recognize Paul Stork as our July 2025 Community…

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 791 Most Valuable Professional

#2
MS.Ragavendar Profile Picture

MS.Ragavendar 410

#3
mmbr1606 Profile Picture

mmbr1606 275 Super User 2025 Season 1

Last month Overall leaderboard

Featured topics

Gallery Tabs - Show or Hide Tabs based on Field Value
How to patch multiple records at once
Enable Copilot for end users in model-driven apps

Product updates

Microsoft Power Platform Community release plans