Power Apps Default function - Argument Defaults is inaccurate,expected a text variable

(0) Share

Report

Posted on by Tj7933

143

Hey guys,

All the patches are failing ALL the time. I finally figured out how to program the patch without errors, and now they will not patch the data to the appropriate list. The error appears to be a run-time error, but I cannot see why it is happening.

So I have been trying to follow these instructions: https://www.matthewdevaney.com/power-apps-patch-function-error-handling/

But I can't get it to work for the life of me. The error exists with the Default line of the coding. That is where the redstarts. It doesn't matter what I type after that line. It is an error. When I hover over the red line, the error message in the subject line appears.

IsBlank(
 Validate(EMR_tblFinance_Timesheets_APP, 
 Defaults(EMR_tblFinance_Timesheets_APP),

There is no need for single quotes because there are no spaces in the title of the list.

Thank you for your help.

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Sort by

Verified answer

v-qiaqi@microsoft.com Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Tj7933,

I think I have reproduced your issue.

Here is the thing, the second parameter within the Validate() fucntion expects a column or a record, however in my test, I found that second parameter within the Validate() fucntion only expects a text literal which means it expects a column. Well we call the column name as a text literal, that's why you have this error message.

Performance of Defaults() expression is slow because every time the Defaults() function is invoked, there is a call to the server where MyTable is stored. The Patch() expression would then make at least two calls, one for the Defaults() and one for the Patch().

To improve performance is to cache locally the return value of Defaults() in a global variable. Then you can use the variable instead of Defaults() elsewhere in the app.

Set(varRecord,Defaults(EMR_tblFinance_Timesheets_APP))

Or you could directly use a blank record to replace the Defaults() function:

Patch(EMR_tblFinance_Timesheets_APP, {ID: Blank()}, {Column1: "xxx", Column2: "yyy"})

Was this reply helpful? Yes No
Tj7933 143 on at

Like
a
(0)

Report
Copy link

Link copied!

Thank you so much @v-qiaqi-msft .

Was this reply helpful? Yes No