Answered

Canvas App

(0) Share

Report

Posted on by S2_0452

Hello,

I’m building a canvas app for managing documents and suppliers. I’m using SharePoint lists as my data source, one is called suppliers in which I store information regarding suppliers. I have a column named “ End Date “ which is a date time column. And a column named “Status” which is a choice column that stores three values ( Active, Renew, Expired). I want the user in my canvas app form to be able to choose a date and then based on the following condition ( if end date is less than today the value in status column will be active automatically , if end date is bigger than today the value in status column will be expired automatically, and if 180 days are remaining until end date the value in status column will be renewed automatically ) how can I achieve this exactly?

Categories:

Building Power Apps

All responses (2)

Answers (1)

Sort by

Verified answer

v-qiaqi@microsoft.com Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @S2_0452,

Could you please share a bit more about yoru form configuration?

I have made a demo for your reference.

Set the Items property of the ComboBox corrresponding to Status as below:

Choices(Suppliers.Status)

Set the DefaultSelectedItems property of this ComboBox as:

If(DatePicker.SelectedDate<Today()&&DateDiff(DatePicker.SelectedDate,Today(),TimeUnit.Days)<180,{Value:"Active"}, DatePicker.SelectedDate>Today(),{Value:"Expired"}, DatePicker.SelectedDate<Today()&&DateDiff(DatePicker.SelectedDate,Today(),TimeUnit.Days)>=180,{Value:"Renew"} )
S2_0452 38 on at

Like
a
(0)

Report
Copy link

Link copied!

Worked! Thank you so much