web

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

News and Announcements icon

Power Platform CommunityForums Power Apps Automatically Update T...

Power Apps

Answered

Automatically Update The status column

(0) Share

Report

Report

Posted on by admin025

17

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 Img

All responses (1)

Answers Img

Answers (1)

Verified answer

v-qiaqi@microsoft.com Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
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

Join the conversation