Helllo @v-monli-msft ,
The formula for the function is something like that
create function dbo.[Function](
@vb1 nvarchar(100))
returns nvarchar(500) with schemabinding as
BEGIN
DECLARE @res nvarchar(500);
select @res = c.[column1] + ' - ' + c.column2
FROM [dbo].[table1] c
where c.[column3] = @vb1;
return @res;
end;
After creating the function I have added a column in the SQL table which has the following definition:
add [CalcColumn] as dbo.[Function]([parameter1]) ; In the power apps form I have removed any update on this calculated column but it still does not work.
I wanted to avoid using the flow. I am mentioning that I have in the table another computed column which has the formula [ColumnA] AS (CONVERT([nvarchar](50),[ColumnB])) and the form works with this field, but it does not have a user-defined function in the definition.
Thank you.
