cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
heimk008
Level: Powered On

Invalid number of arguments

I'm just learning PowerApps and have gotten pretty far but now can't figure out what is wrong with this formula... 

 

If(IsEmpty(Filter(MIRes, Promo = DDPromo.Selected.Value && WeekRange = DateRange.Text ), DisplayMode.Edit, DisplayMode.Disabled))

I keep getting "Invalid number of arguments: recieved 3, expected 1." and "Invalid number of arguments: recieved 1, expected 2 or more."

 

Please Help!! 

1 ACCEPTED SOLUTION

Accepted Solutions
Super User
Super User

Re: Invalid number of arguments

Hi @heimk008,

 You left off a closing parenthesis of the IsEmpty function and have an extra one at the end of the If function.  I believe   If(IsEmpty(Filter(MIRes, Promo = DDPromo.Selected.Value && WeekRange = DateRange.Text )), DisplayMode.Edit, DisplayMode.Disabled) will work.

View solution in original post

3 REPLIES 3
heimk008
Level: Powered On

Re: Invalid number of arguments

I figured it out! was missing a ) before I had my true or false results

Super User
Super User

Re: Invalid number of arguments

Hi @heimk008,

 You left off a closing parenthesis of the IsEmpty function and have an extra one at the end of the If function.  I believe   If(IsEmpty(Filter(MIRes, Promo = DDPromo.Selected.Value && WeekRange = DateRange.Text )), DisplayMode.Edit, DisplayMode.Disabled) will work.

View solution in original post

mogg
Level: Powered On

Re: Invalid number of arguments

Hi I am just a newbie to PowerApps but have done some excel previously I have checked and checked but cant work out why I am getting Invalid number of arguements recieved 1 expecting 2 or more......

 

I am checking the 'Cal Due' date to today and changing the fill colour of a label depending if its > 30 days, 1-30 days, 0 days or < Today (Overdue) 

 

If(IsBlank(ThisItem.'Cal Due'),RGBA(232,244,217,1),If(DateDiff(Today(),ThisItem.'Cal Due',Days) > 30),RGBA(232,244,217,1),If(30 > DateDiff(Today(),ThisItem.'Cal Due',Days)) > 0,RGBA(255, 255, 0, 0.42),If(DateDiff(Today(),ThisItem.'Cal Due',Days))=0,RGBA(204, 231, 246, 1),RGBA(238,204,204,1))

 

Thanks for any help

 

Helpful resources

Announcements
New Ranks and Rank Icons in April

'New Ranks and Rank Icons in April

Read the announcement for more information!

Better Together’ Contest Finalists Announced!

'Better Together’ Contest Finalists Announced!

Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.

thirdimage

Power Apps Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Join THE global Microsoft Power Platform event series

Attend for two days of expert-led learning and innovation on topics like AI and Analytics, powered by Dynamic Communities

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

thirdimage

Community Summit North America

Innovate, Collaborate, Grow - The top training and networking event across the globe for Microsoft Business Applications

Top Solution Authors
Top Kudoed Authors
Users online (10,214)