cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
MrGadget
Level: Powered On

AddColumns with SQL Database

Hey,

 

how do I add 2 more colums to a SQL Database? 

I have 2 dropdowns, where the people can select Month and Year. The entries they do in the Forecast Form are shown in the second pic. I want to add the month and the year for each monthly entry the make..

Forecast ANzeige.pngForecast.png

1 ACCEPTED SOLUTION

Accepted Solutions
Super User
Super User

Re: AddColumns with SQL Database

Hi @MrGadget 

If you want users to be able to save the month and year that they enter onto your forecast form, you'll need to add these fields to your SQL Server table.

With PowerApps, the AddColumns function adds columns locally so a typical use of the AddColumns function is to add columns to a datasource for display purposes.

1 REPLY 1
Super User
Super User

Re: AddColumns with SQL Database

Hi @MrGadget 

If you want users to be able to save the month and year that they enter onto your forecast form, you'll need to add these fields to your SQL Server table.

With PowerApps, the AddColumns function adds columns locally so a typical use of the AddColumns function is to add columns to a datasource for display purposes.

Helpful resources

Announcements
firstImage

Watch Sessions On Demand!

Continue your learning in our online communities.

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

FirstImage

Power Platform World Tour

Coming to a city near you

thirdimage

PowerApps Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

FourthImage

Join PowerApps User Group!!

Connect, share, and learn with your peers year-round

SecondImage

Power Platform Summit North America

Register by September 5 to save $200

Top Kudoed Authors
Users Online
Currently online: 230 members 5,198 guests
Please welcome our newest community members: