Answered

A value must be provided for item, server error excel patch function

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hi Everyone,

I think I just may need a second set of eyes on my code, I'm sure it's an oversight.

Patch(
DailyRepairDataTable,
EditDailyRepair.LastSubmit,
{
EditBy: User().FullName,
DateModified: Now(),
PreviousQTY: varPrevQTY
}
);

My data source is an excel file. When I substitute text for my variable 'varPrevQTY' I get the text I put to patch successfully into my excel table so I was thinking it could have been that my excel column was formatted "general" so I changed it to "Number". But that does not seem to have worked even after I remove and add back my excel data source to make sure everything is refreshed. Any ideas? Appreciate any feed back.

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Sort by

Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Ok, I'm certain it's not a cell formatting problem, as I successfully replaced my variable with the number 9 and it worked. So passing text works, passing a number works, passing my variable doesn't. My variable does contain a numeric value I checked that by setting a label to the variable and it shows the number I expect. So I just must not understand how to patch a variable to excel.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

not sure if a screen shot will help.... But here it is....

Was this reply helpful? Yes No
Verified answer

Community Power Pla... Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!

Ok, for my future self and anyone else looking for the same solution. The problem was as follows:
1) I don't need a variable.
2) You can use one but it should look like this:

Patch(
DailyRepairDataTable,
EditDailyRepair.LastSubmit,
{
EditBy: User().FullName,
DateModified: Now(),
PreviousQTY: Value(varPrevQTY.Text)
}
);

Was this reply helpful? Yes No