Patch function error

(0) Share

Report

Posted on by masumbillah

Please Help

My patch showing error. i can't find out the reason.

My data base is MS SQL.

Formula:

Patch(
'Cost$',
Defaults('Cost$'),
{
Name: Nam.Text,Date: DatePicker1.SelectedDate, Cost_Type:TYpe, Cost_Description:DesCrip.Selected.Value,Cost:taka.Text,Remarks:remar.Text
}
)

Data Base Table:

SELECT [Name]
,[Date]
,[Cost_Type]
,[Cost_Description]
,[Rate]
,[Cost]
,[Remarks]
,[SLNo]
FROM [Family].[dbo].[Cost$]

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Sort by

Rajkumar_M 3,747 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @masumbillah

If TYpe is combo box control so you should use

Cost_Type:TYpe.Selected.Value

Refer this link: How to Patch Power Apps Combo Box - Enjoy SharePoint

Thanks!

If my response has been helpful in resolving your issue, I kindly request that you consider clicking "Accept as solution" and "giving it a thumbs up" as a token of appreciation.

Was this reply helpful? Yes No
Verified answer

M_Ali_SZ365 1,110 on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @masumbillah
Try This
Patch( 'Cost$', Defaults('Cost$'), { Name: Nam.Text, Date: DatePicker1.SelectedDate, Cost_Type: TYpe.Selected.Value, // Assuming 'Type' is a Dropdown or similar control Cost_Description: DesCrip.Selected.Value, Cost: Value(taka.Text), // Converts text to number Remarks: remar.Text } )
Please accept this solution if it resolves the issue. ✅
Best regards,
Muhammad Ali

Was this reply helpful? Yes No
masumbillah 5 on at

Like
a
(0)

Report
Copy link

Link copied!

Can you guide me to use the formula in patch function
"NewForm(EditForm1);Navigate(EditScreen1, ScreenTransition.None)"?

Was this reply helpful? Yes No