Share
ReportI am using this formula but it's not works. if anyone have any idea about this then please feel free to share.
Formula I used in Power Apps in onselect : -
Patch(
Defaults('Leave DB'), // Replace with your actual data source
{
'Leave Type': If(
!(Weekday(DateValue(DataCardValue18.SelectedDate)) = 1 || Weekday(DateValue (DataCardValue18.SelectedDate)) = 7) &&
!(Weekday(DateValue(DataCardValue12.SelectedDate)) = 1 || Weekday(DateValue(DataCardValue12.SelectedDate)) = 7),
DataCardValue13.SelectedItems , // Allow any choice when not near Saturday or Sunday
If(
(Weekday(DateValue(DataCardValue18.SelectedDate)) = 6 And Weekday(DateValue(DataCardValue12.SelectedDate)) = 2) Or
(Weekday(DateValue(DataCardValue18.SelectedDate)) = 2 And Weekday(DateValue(DataCardValue12.SelectedDate)) = 2) Or
(Weekday(DateValue(DataCardValue18.SelectedDate)) = 6 And Weekday(DateValue(DataCardValue12.SelectedDate)) = 6) Or
(Weekday(DateValue(DataCardValue18.SelectedDate)) = 2) Or
(Weekday(DateValue(DataCardValue12.SelectedDate)) = 6) Or
(Weekday(DateValue(DataCardValue18.SelectedDate)) = 6) Or
(Weekday(DateValue(DataCardValue12.SelectedDate)) = 2),
"EL" , // Restrict to "EL" when the start date is Friday and end date is Monday
Notify("Please select a different value because the start and end dates are not near Friday and Monday.")
)
),
Start: DataCardValue18.SelectedDate, // Replace with your actual start date picker name
End: DataCardValue12.SelectedDate, // Replace with your actual end date picker name
'Name (field_0)': Label2.Text,
Reason: Value(DataCardValue17.Text),
'No. of Days': Value(DataCardValue16.Text)
}
my UI :
Categories:
I have the same question (0)
All responses (
Answers (
358
