cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
pmscorca Member
Member

Inputting data by a Power App

Hi,

I've created a simple report + dataset on Power BI service. The dataset reads from a local SQL Server database.

I've registered a local gateway in order to read the SQL Server database.

Working in the Power BI service environment, I've created a Power App by putting in a form two input text boxes

(for the customer code and description fields), a button, a data connection to the SQL Server database using

the above local gateway: when I try the Power App specifying a value for the code and the description and

pushing the button nothing data is inserted in the customer SQL Server table.

 

Any suggests to me in order to solve this issue, please?

Many thanks

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
pmscorca Member
Member

Re: Inputting data by a Power App

Hi,

to solve the issue, inside the PowerApps environment, I've specified for the OnSelect action a similar function:

Collect('<data_source>'; {<mySQLField1>:TextInput1.Text; <mySQLField2>:TextInput2.Text}).

 

Thanks

4 REPLIES 4
Super User
Super User

Re: Inputting data by a Power App

Well, sounds like you did the right sorts of things. However, that's more of a PowerApp issue so I would use their forums.

 

https://community.powerapps.com/t5/PowerApps-Community/ct-p/PowerApps1


Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!


pmscorca Member
Member

Re: Inputting data by a Power App

Hi Greg,

thanks for your reply but I thought that my question was a basic one for the Power BI community.

Likely it is enough that anyone remembers how has used PowerApps for inputting data into a SQL table linked to a Power BI dataset.

Thanks

Super User
Super User

Re: Inputting data by a Power App

I guess my perspective on this is that the Power BI aspect of this issue is completely superfluous. Your problem, as stated is that PowerApps is not pushing a new item back into the SQL Database. I don't see how Power BI is related to this issue, that's a problem with your PowerApp.


Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!


Highlighted
pmscorca Member
Member

Re: Inputting data by a Power App

Hi,

to solve the issue, inside the PowerApps environment, I've specified for the OnSelect action a similar function:

Collect('<data_source>'; {<mySQLField1>:TextInput1.Text; <mySQLField2>:TextInput2.Text}).

 

Thanks