web

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

News and Announcements icon

Power Platform CommunityForums Power Apps How do I patch (update...

Power Apps

Answered

How do I patch (update) all records in a table, that match a criteria

(0) Share

Report

Report

Posted on by Nicoolai

7

I want to, at a press of a button, update all records in my table, if they have a blank "CommitedDate" field.

If the field is blank, it should get a now() inserted.

I have tried a variety of Patch() and ForAll(), with various LookUp() and Filter() on then, and not really managed.

I feel like this should be quite a simple thing but I cannot solve it.

How on earth do I do what would be a simple update statement in SQL, with a where filter that simply check if CommitedDate was null?

Categories:

Building Power Apps

All responses Img

All responses (3)

Answers Img

Answers (1)

Sort by

Verified answer

WarrenBelz 156,528 Most Valuable Professional on at

Like
a
(2)

Report
Copy link

Link copied!
Hi @Nicoolai ,

Based on the field values required

UpdateIf( TableName, CommittedDate = Blank(), {CommittedDate: Now()} )

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

MVP (Business Applications) Visit my blog Practical Power Apps
Ami K 15,689 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
@Nicoolai consider using UpdateIf:

UpdateIf( 'Your Data', 'Your Date Field' = Blank(), {'Your Date Field': Now()} )
Nicoolai 7 on at

Like
a
(0)

Report
Copy link

Link copied!

Of course it was this easy!
Thank you very much, worked like a charm.

Join the conversation