Automatically Update The status column

(0) Share

Report

Posted on by admin025

Hi.

I have an app for tracking Projects. I have a date column and a single line text column which is the status. I want the status column to automatically be changed to "closed" when the date column is entered. The controls are in a gallery and the DataSource for the gallery is a collection.

Kindly help on how I can achieve this.

Categories:

Power Apps Pro Dev & ISV

I have the same question (0)

All responses (1)

Answers (1)

Verified answer

v-qiaqi@microsoft.com on at

Like (0)

Report
Hi @admin025,

Do you want to update the status column based on the date column?

Could you please share a bit more about your scenario?

If you want to update the status column once there is input happened to the date column, please try to set the OnChange property of the DatePicker as below:

Patch(Collection, ThisItem,{Status:"Closed",Date:DatePicker1.SelectedDate})

Was this reply helpful? Yes No