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

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / How to set SP List cus...
Power Apps
Answered

How to set SP List custom form column default value from SQL database data

(0) ShareShare
ReportReport
Posted on by

I have a customized form for a SharePoint list. In one of the list columns, when a new form is entered, I want that column to have default data from a sql database and have that data saved into the SharePoint list. I've already connected the sql database via the gateway and added the connection to the customized form. I'm a newbie to the Power Platform and I guess I'm trying to figure out the formula that populates that Default line. Any help will be greatly appreciated. 

default-value-sql-connect.jpg
Categories:
I have the same question (0)
  • Verified answer
    RandyHayes Profile Picture
    76,299 Super User 2024 Season 1 on at

    @LJinJC 

    You have not mentioned the criteria for your data.  What is it from the SQL that you are trying to display as a default? 

    You need to basically do a LookUp on the SQL connection to get the value you want.

    Example, in the Default property of your TextInput control:

       LookUp(yourSQLTable, <criteria>, <column>)

    Where criteria specifies what record to look up, and column specifies the column of your table that you want the data from.

     

    I hope this is helpful for you.

  • LJinJC Profile Picture
    on at

    Thank you so much. This was helpful. 

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 509 Most Valuable Professional

#2
Haque Profile Picture

Haque 302

#3
11manish Profile Picture

11manish 265

Last 30 days Overall leaderboard