Unanswered

Patch Blank() not working suddenly

(0) Share

Report

Posted on by JYKalpha

Hi fellows,

My colleague and I have been using Power Apps for over a year and we are very familier with Patch function and putting Blank() in SP List columns.

The code is just as simple as this:

    Patch(
    'SP List' ,
    LookUp('SP List',ID = 333),
{
            Note:Blank()
        }
    );

we remember that we used to turn "Formula-Level Error Management" on in order to use Blank() in Patch().

However, Today morning, we both found out our Blank() in Patch() function ain't working at all. After struggling hours we just found out that "Formula-level error Management" was turned off by itself!!!!

We've been using Blank() for a long time and had no issue and suddenly it just turned off!

I strongly believe this is a mistake caused by Power Apps editor develop team.

I hope this warning will save numerous developer's time to solve this issue.

Categories:

Building Power Apps

All responses (5)

Answers (0)

Sort by

Ramole Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
@JYKalpha
What is the note field type?
why not use Note: ""

Patch( 'SP List' , LookUp('SP List',ID = 333), { Note:"" } );
WarrenBelz 156,545 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @JYKalpha ,

Not sure if there is a question in there, but you are correct, you need Formula Level Error Management turned on to patch fields with blank values. I have not experienced this, so it would be interesting to know the trigger.
JYKalpha 4 on at

Like
a
(0)

Report
Copy link

Link copied!

It's single string there.

Yes we found using "" works.
But this code is just an example. we use blank() in many other types of columns
I believe many people tend to use Blank() instead of "" so they don't need to put manual values in different types of columns. such as choice and lookup columns.
JYKalpha 4 on at

Like
a
(0)

Report
Copy link

Link copied!

I'm posting this for other developers to solve this issue quicker than we did.
I do also want to know what was the trigger of this. haha
Ramole Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@JYKalpha
I have never experience this but interesting thanks for letting us know.

Good day ....