Answered

Patching a DateTime column in Model Driven App Command Button

(0) Share

Report

Posted on by OwenS28

Sorry I'm new to this. I'm trying to make a command bar button that will update (using the Patch function) a column in the record to the current date. From the videos and documentation I've found I thought this would be correct, but it is throwing an error. Invalid argument type. Expecting one of the following: ...

And putting "" around Today() like this, "Today()" gives the error that it is expecting datetime value but receiving a text value.

Putting DateValue("Today()") also doesn't work

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Shaheer Ahmad 2,194 Moderator on at

Like (1)

Report
Try:
Text(Today())
Or:
Now()

Was this reply helpful? Yes No
Verified answer

OwenS28 47 on at

Like (0)

Report

Alright I found what was wrong. It wasn't anything to do with the Patch function. I was trying to use two different formulas but I guess you can only use one formula in the model driven app command bar buttons. So what I did was make an If() function so that if the confirmation box is accepted, the record will patch. Otherwise it wont do anything to that column. Here is the code. And the youtube video I found that helped me, https://youtu.be/x4AKnyQjtYQ?si=dGMWUAJ5yIfZbgf-

If(Confirm("Email customer that we received their shoes?", {Title:"Run Auto-Email"}), Patch(Orders, Self.Selected.Item, {'Received Shoe': Today()}))

Was this reply helpful? Yes No