Unanswered

Invalid argument type error

(0) Share

Report

Posted on by Community Power Pla...

Hi,

I am getting the following error, i tried changing the column data type in the share point list but still am getting this error, do i have to change something in the code

Categories:

Building Power Apps

I have the same question (0)

All responses (7)

Answers (0)

eka24 20,923 on at

Like (1)

Report

Remove the Datevalue in the formula since you are working with a DatePicker.

If you still have issues give the full formula.

------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

@eka24 the error is gone, but the formula is not working as expected, i want the app user to select only the dates in the current week & add a condition to restrict the user from selecting any dates from previous or upcoming week, here's the formula used

If(And(DateDiff(DateAdd(Now(),-Weekday(Now(),11)),(DatePickerbox.SelectedDate))>0,DateDiff(DateAdd(Now(),7-Weekday(Now(),11)),(DatePickerbox.SelectedDate))<=0),1,0)

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

@eka24 , is that formula to be changed to get the expected result

Was this reply helpful? Yes No
eka24 20,923 on at

Like (1)

Report

You can also us the fill property to change the color:

If(And(DateDiff(DateAdd(Now(),-Weekday(Now(),11)),(DatePickerbox.SelectedDate))>0,

DateDiff(DateAdd(Now(),7-Weekday(Now(),11)),(DatePickerbox.SelectedDate))<=0),White,Red)

------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

@eka24 , thanks you, the fill property works, is there way to show an error message or restrict the user from selecting the date in previous/future week.
I am trying to connect this date picker with calendar gallery, i want the following condition to be executed,
If(date picker date = calendar date & (total text box value >= 8, Green, Red ), also want to add another color based on a toggle how to get this result in power apps

Was this reply helpful? Yes No
AC-16100139-0 on at

Like (0)

Report

Hi @Anonymous,

Have you found a solution or did you need further input on this. Let us know and I'll dig into this for you if still outstanding.

Thanks.

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

@ACahill , i have been trying the below formula but not getting the expected result

Was this reply helpful? Yes No