Unanswered

Power apps patch

(0) Share

Report

Posted on by JamesArthur12

Hi Power Users,

I'm still learning power apps, I'm trying to create an app for forecasting and getting issues. Its a simple app. I have a filter that contains products,month and forecast value.

I have created the app by using gallery. My table looks like below. The data is stored in SQL.

ID	Product	Month	Forecast
1	A	Jan	0
2	B	Jan	0
3	C	Jan	0
4	A	Feb	0
5	B	Feb	0
6	C	March	0

I have created labels for Product and Month and insert box for Forecast. The default value for Forecast is 0 and when i entered the Forecast value in APP then it should update in SQL table.

Please help.

Thanks

Categories:

Building Power Apps

All responses (5)

Answers (0)

Sort by

mdevaney 29,993 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!
@JamesArthur12

Put this code in the OnChange property of the Text Input.

Patch(your_datasource_name, ThisItem, {Forecast: Value(TextInput1.Text)})

Then use this code in the Default property of the Text Input.

ThisItem.Forecast

---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."
JamesArthur12 28 on at

Like
a
(0)

Report
Copy link

Link copied!

@mdevaney
Thanks for reply. I have used same patch function but getting error as PATCH some invalid arguments. The data source is read only so the PATCH can not write. I have checked the Data source and i have admin access to the server and database.

Thanks
mdevaney 29,993 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

@JamesArthur12

SQL views are read-only in PowerApps. Are you using a SQL view?

Otherwise, the permissions issue would have to be handled on your end.

---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."
JamesArthur12 28 on at

Like
a
(0)

Report
Copy link

Link copied!

Its not the View its Table only.
mdevaney 29,993 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

@JamesArthur12

Sorry, I can't help much on the database permissions side of things. You'll have to speak with your administrator.