Date colum validation need to implement in PowerApps

(0) Share

Report

Posted on by MSD52

Hi All,

I have a SharePoint List and customizing with PowerApps.

I have date columns those are Request Date, Requested Go Live Date, Review date, Go Live Date.

I need to implement below logic, Please help us as I am new to PowerApps.

Intake review date >= Request date =< Requested Go live date

Go live date >= Request date

Where to put logic. Please suggest.

Thanks.

Categories:

Building Power Apps

All responses (4)

Answers (0)

Sort by

sahana_23 46 on at

Like
a
(1)

Report
Copy link

Link copied!
Open your PowerApp in the PowerApps Studio.
Go to the screen where your SharePoint List data is being displayed.
Select the data card for each date column (Request Date, Requested Go Live Date, Review Date, and Go Live Date).
Click on the "Advanced" tab in the right-hand pane.
Scroll down to the "Default" property and click on the "Edit" button.
In the formula bar that appears, write the logic you want to implement for each date column.
For example, for the Request Date column, the formula could be:
If(ReviewDate>= RequestDate && RequestDate <= RequestedGoLiveDate, RequestDate, Blank())
This formula checks if the Review Date is greater than or equal to the Request Date, and if the Request Date is less than or equal to the Requested Go Live Date. If both conditions are met, it returns the Request Date; otherwise, it returns blank.
Similarly, for the Go Live Date column, the formula could be:
If(GoLiveDate >= RequestDate, GoLiveDate, Blank())
This formula checks if the Go Live Date is greater than or equal to the Request Date. If the condition is met, it returns the Go Live Date; otherwise, it returns blank.
After adding the formulas for all the date columns, save the changes and test your app to ensure that the logic is working as expected.
MSD52 71 on at

Like
a
(0)

Report
Copy link

Link copied!

I am keeping this formula on DefaultDate Property of Request Date but getting error.
If(DataCardValue26.SelectedDate >= DataCardValue4.SelectedDate && DataCardValue4.SelectedDate <= DataCardValue9.SelectedDate, DataCardValue4.SelectedDate,Blank())

Request Date ---DataCardValue4
Requested Go Live Date----DataCardValue9
Review Date--- DataCardValue26
Go Live Date--- DataCardValue27
sahana_23 46 on at

Like
a
(0)

Report
Copy link

Link copied!

The formula you have provided appears to be correct based on the logic you have mentioned. However, without knowing the specific error message you are receiving, it is difficult to provide a specific solution.
One common issue that can occur with date fields in PowerApps is that the date format may not be compatible with the formula. Make sure that the date format used in the data card controls matches the format expected by the formula. For example, the date format used in the SharePoint list and the date format used in the data card controls should match.
Another possible issue could be with the order of operations in the formula. Try wrapping the logical conditions in parentheses to ensure that they are evaluated correctly. Here is an updated version of your formula with parentheses added:
If((DataCardValue26.SelectedDate >= DataCardValue4.SelectedDate) && (DataCardValue4.SelectedDate <= DataCardValue9.SelectedDate), DataCardValue4.SelectedDate, Blank())
If you continue to receive an error after trying these solutions, please provide the specific error message you are receiving, and I can help you further.
MSD52 71 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi,

Thanks for your Reply!! Request date as it is but need to implement like below based on request date selected
1. Review Date should be lessthan or eq to requested go live date
2. Review date should be Grater than or eq to Request Date
3.Planned go live date graterthan or eq to Request Date