Power Apps Error

[artross26]

Type: Bug

Accessing SQL DB from Power Apps, the app does everything except update activites. I recieve the following error: "Network error when using the patch function OnSelect". The code below is what executes to point and then update.

Patch( Student, LookUp(Student, Student_TAF_Key = Gallery1.Selected.Student_TAF_Key), { Student_Media: Text(editform_UserDetails.LastSubmit.Student_Media) // Make sure to convert to the appropriate data type // Include other fields as needed } )

Azure Data Studio version: azuredatastudio 1.47.0 (c7c2b2f21505562d21972d4c135119d00806db4f, 2023-11-07T17:17:45.669Z) OS version: Windows_NT x64 10.0.22631 Restricted Mode: No Preview Features: Enabled Modes:

System Info

|Item|Value| |---|---| |CPUs|12th Gen Intel(R) Core(TM) i7-1255U (12 x 2611)| |GPU Status|2d_canvas: enabled
canvas_oop_rasterization: enabled_on
direct_rendering_display_compositor: disabled_off_ok
gpu_compositing: enabled
multiple_raster_threads: enabled_on
opengl: enabled_on
rasterization: enabled
raw_draw: disabled_off_ok
video_decode: enabled
video_encode: enabled
vulkan: disabled_off
webgl: enabled
webgl2: enabled
webgpu: enabled| |Load (avg)|undefined| |Memory (System)|15.83GB (2.53GB free)| |Process Argv|| |Screen Reader|no| |VM|0%|

Extensions (1)

Extension|Author (truncated)|Version ---|---|--- import|Mic|1.5.5

[cheenamalhotra]

Are you running this query in ADS or Power Apps? Can you elaborate how is ADS related to the issue?

[artross26]

It says: “Network error when using patch: there is an error on the server.” I don’t know what I am to do to make this work with the server since it does not say what the error is.

This is the code I am using:

Patch( Student, LookUp(Student, Student_TAF_Key = Gallery1.Selected.Student_TAF_Key), { Student_Media: Text(editform_UserDetails.LastSubmit.Student_Media) // Make sure to convert to the appropriate data type // Include other fields as needed } )

Thanks.

From: Cheena Malhotra @.> Sent: Thursday, November 23, 2023 10:46 AM To: microsoft/azuredatastudio @.> Cc: Arthur Ross @.>; Author @.> Subject: Re: [microsoft/azuredatastudio] Power Apps Error (Issue #25006)

Are you running this query in ADS or Power Apps? Can you elaborate how is ADS related to the issue?

— Reply to this email directly, view it on GitHubhttps://github.com/microsoft/azuredatastudio/issues/25006#issuecomment-1824817553, or unsubscribehttps://github.com/notifications/unsubscribe-auth/A2LRTZGAU7RCNL4T32IN67LYF6KX7AVCNFSM6AAAAAA7TQU55OVHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMYTQMRUHAYTONJVGM. You are receiving this because you authored the thread.Message ID: @.**@.>>

[cheenamalhotra]

Do you have any screenshot you can share?

[artross26]

This happens when the “Save” button is clicked which executes the code I sent before.

Patch( Student, LookUp(Student, Student_TAF_Key = Gallery1.Selected.Student_TAF_Key), { Student_Media: Text(editform_UserDetails.LastSubmit.Student_Media) // Make sure to convert to the appropriate data type // Include other fields as needed } )

[A screenshot of a computer Description automatically generated]

From: Cheena Malhotra @.> Sent: Monday, November 27, 2023 1:11 PM To: microsoft/azuredatastudio @.> Cc: Arthur Ross @.>; Author @.> Subject: Re: [microsoft/azuredatastudio] Power Apps Error (Issue #25006)

Do you have any screenshot you can share?

— Reply to this email directly, view it on GitHubhttps://github.com/microsoft/azuredatastudio/issues/25006#issuecomment-1828614331, or unsubscribehttps://github.com/notifications/unsubscribe-auth/A2LRTZG6HWAR5MS2XZXEZFDYGT6U5AVCNFSM6AAAAAA7TQU55OVHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMYTQMRYGYYTIMZTGE. You are receiving this because you authored the thread.Message ID: @.**@.>>

[cheenamalhotra]

Screenshot didn't come through.. can you post it on GitHub?

Also, are you running this code in Azure Data Studio or Power Apps? It doesn't look like you're executing a SQL Script, so I'm not sure how is it ADS related.

[artross26]

This is being done using Power Apps. The DB is on Azure SQL and sever.

[artross26]

There is a connector to Azure SQL. It is erroring out on any function involving an update.

[artross26]

This is yet to be resolved. Can you please connect again?

[cheenamalhotra]

This repository is for Azure Data Studio, we don't provide support for Power Apps. Please reach out to Power Apps support for assistance.