web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps LookUp function in MyS...

Power Apps

Suggested Answer

LookUp function in MySQL data source failing in UpdateContext

(1) Share

Report

Report

Posted on by Ste_

11

Hello! I'm trying to get a record from MySQL table with the following expression:

UpdateContext({VarData: LookUp(svc_PowerApps.Status; Sk = varSk)})

And it returns the following error: "The request was not sent or there was no response from the server. Check your internet connection. Server response: svc_PowerApps.Status failed: null"

But this expression works outside the UpdateContext function. Does anyone know why this happens?

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (0)

Sort by

Suggested answer

11manish 2,126 on at

Like (0)

Report
Copy link

Link copied!
The issue occurs because UpdateContext() struggles to store complex records returned from connectors like MySQL.

These records may contain metadata or non-serializable structures, causing the operation to fail with a null response.

When used outside UpdateContext(), Power Apps evaluates the query lazily and does not need to store the full record, so it works.

The correct approach is to use Set() to store connector results or extract only the required fields before assigning them to a context variable.

Try below :

Use Set()

Set(VarData, LookUp(svc_PowerApps.Status, Sk = varSk))

Instead of storing full record:

UpdateContext({
VarData: LookUp(svc_PowerApps.Status, Sk = varSk).YourColumnName
})

Was this reply helpful? Yes No
Suggested answer

Haque 2,532 on at

Like (1)

Report
Copy link

Link copied!
hi @Ste

If it is a syntax Issue: Power Apps expects commas , as argument separators, not semicolons ;. So the correct syntax should be:

UpdateContext({VarData: LookUp(svc_PowerApps.Status, Sk = varSk)})

Other than that, there might be two issues:

Connection or Gateway Issue:
The Power Apps connector to your MySQL database might be misconfigured, offline, or the on-premises data gateway (if used) is not running or reachable.

Service or Table Name Issue:
The data source name svc_PowerApps.Status might be incorrect or the table Status is not accessible or does not exist in the MySQL database.

I am sure some clues I tried to give. If these clues help to resolve the issue brought you by here, please don't forget to check the box Does this answer your question? At the same time, I am pretty sure you have liked the response!

Was this reply helpful? Yes No

Join the conversation