Answered

On Select change date value when drop down field change

(0) Share

Report

Posted on by WillieEra

Community:

I have a form where I want to change the status of the record from open to close, when the status is changed in the form using a drop down menu, I want to then patch the date closed value to date now:

Here is the code as it stands:

If(Job_Status_Change_drp.Selected.Value = "Closed",
Patch( Gallery_Job_Status.Selected,ThisItem, { Close_Date: Now() }),ThisItem, { Close_Date:"" })

the source table is '[dbo].[aas_wf_transaction_tbl]'

Categories:

Building Power Apps

I have the same question (0)

All responses (11)

Answers (1)

Sort by

WarrenBelz 156,369 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @WillieEra ,
Try this
If( Job_Status_Change_drp.Selected.Value = "Closed", Patch( ThisItem, {Close_Date: Now()} ) )
I am assuming ThisItem is correct.

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.

Was this reply helpful? Yes No
WillieEra 45 on at

Like
a
(0)

Report
Copy link

Link copied!

Thank you for the reply, I took your code but there seems to be an issue with the "ThisItem", so I changed it to the gallery.selected value and it shows no errors, however when I run it, the status changes from open to close but the date_close does not update the date to now()

Here is the code:
If(
Job_Status_Change_drp.Selected.Value = "Closed",
Patch(
Gallery_Job_Status.Selected,
{Close_Date: Now()}
)
)

Was this reply helpful? Yes No
WillieEra 45 on at

Like
a
(0)

Report
Copy link

Link copied!

Been testing the code, my issue is record identifier, ThisItem does not work, tried Gallery.Selected, does not work.
Any suggestions?

Was this reply helpful? Yes No
WarrenBelz 156,369 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
Try
If( Job_Status_Change_drp.Selected.Value = "Closed", Patch( {ID:Gallery_Job_Status.Selected.ID}, {Close_Date: 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.

Was this reply helpful? Yes No
WillieEra 45 on at

Like
a
(0)

Report
Copy link

Link copied!

The IF statement works, I keep getting errors saying it cant identify the record to be patched, it seems to me the identifier is the issue in the statement, tried the now code, outcome the same.

Appreciate the help.

Was this reply helpful? Yes No
WarrenBelz 156,369 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Ok @WillieEra ,
Where are you running this code from - what type of control and where is it located - screen shot would help showing the control and the gallery.

Was this reply helpful? Yes No
eka24 20,925 on at

Like
a
(1)

Report
Copy link

Link copied!

I guess see what is missing from @WarrenBelz is the table name or Datasource: '[dbo].[aas_wf_transaction_tbl]'
If I may ask it is a Gallery or a Form because in your initial question you said a form.
In changing a record, the record must already exist in the datasource. But the dropdown="Closed" is yet to be submitted.

Was this reply helpful? Yes No
WarrenBelz 156,369 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks @eka24 ,
Getting late here and I missed the obvious mistake I made at the start (typing off a tablet instead of testing).
I will leave you to the solution with @WillieEra

Was this reply helpful? Yes No
WillieEra 45 on at

Like
a
(0)

Report
Copy link

Link copied!

To give more detail:
It is a form.edit, the condition of the field is based on a drop down, the dropdown selects between ["Open","Closed"] when the user selects closed there is a date_close field that should default to Now(), so when Onselect FormSubmit I want to patch that condition into the close_date.

The form gets selected from a previous screen from a gallery.

Was this reply helpful? Yes No
Verified answer

eka24 20,925 on at

Like
a
(0)

Report
Copy link

Link copied!

If(Job_Status_Change_drp.Selected.Value = "Closed",
Patch('[dbo].[aas_wf_transaction_tbl]', (Close_Date: "Closed"),{ Close_Date: Now() })

Was this reply helpful? Yes No