Answered

Inserting a row into an SQL Table from Powerapps with the sql datatype sysname as column

(0) Share

Report

Posted on by Community Power Pla...

Hello,

I want to submit a form / or patch an existing row which contains a sql datatype sysname.

I have this sysname in there because i'm doing Row Level Security on SQL side and i want the user to select, which users are allowed to see the new created row entry in Powerapps.

So when i try to insert a row from Powerapps to SQL with the datatype sysname, i get an error from the sql server, because Powerapps is sending it as text and the SQL Server expects a sysname.

Is there a way to cast text datatype to sysname in Powerapps?

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

v-siky-msft on at

Like (1)

Report

Hi @Anonymous ,

From the SQL Server Connector document, we can know that Only the following data types can be mapped into PowerApps, so the sysname date type is not supported. If you want this feature, please consider submitting a idea to PowerApps Ideas Forum.

SQL Server	Power Apps
bigint, decimal, int, money, numeric, smallint, smallmoney, tinyint, float, real	Number
char, nchar, varchar, nvarchar, text, ntext	Text
bit	Boolean
date, datetime/datetime2/smalldatetime, datetimeoffset, time	DateTime
uniqueidentifier	Guid

Hope this helps.

Sik

Was this reply helpful? Yes No

Community Power Pla... on at

Like (0)

Report

Alright,

I've added this as idea
https://powerusers.microsoft.com/t5/Power-Apps-Ideas/Support-SQL-Datatype-sysname-from-Powerapps-to-manage-insert-or/idi-p/612328

Greetings,
Philip

Was this reply helpful? Yes No