Answered

The Function If has some invalid arguments

(0) Share

Report

Posted on by johnjohn123

3,514

I have the following formula "If(IsBlank(Var1),Parent.Default,Var1)" inside my DefaultSelectedItems, but i am getting this error "The Function If has some invalid arguments":-

Any advice on this please?

Categories:

Building Power Apps

I have the same question (0)

All responses (32)

Answers (1)

Sort by

Drrickryp Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi @johnjohn123

If your logic is to use the Parent.Default if var1 is blank then

Coalesce(var1,Parent.Default) would work. If you mean to use var1 if the Parent.Default is blank (such as would be the case if a form was in New mode, then

Coalesce(Parent.Default,var1) would be the correct formula to use. FYI, Coalesce() checks each element in sequence for one that is not blank then stops.

Was this reply helpful? Yes No
AndreaMondello on at

Like (0)

Report
Copy link

Link copied!

According to the documentation "To test specifically for a blank value use if(Value = Blank(),.. instead of IsBlank." Blank, Coalesce, IsBlank, and IsEmpty functions - Power Apps | Microsoft Docs

Was this reply helpful? Yes No
RandyHayes 76,299 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

@johnjohn123

As @Drrickryp has mentioned, the Coalesce function should become your go-to function for these type of things.

However, I don't believe that your issue is coming from the formula. It is most likely an issue with var1.

Since you are setting the DefaultSelectedItems property of that control, it MUST be a Table of Records compatible with the schema of the Items property of the combobox.

So, how are you assigning to var1 ?

Was this reply helpful? Yes No
Drrickryp Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

@RandyHayes

Thanks for coming to the rescue! I was playing around with it and found that that my approach didn't work.

Was this reply helpful? Yes No
johnjohn123 3,514 on at

Like (0)

Report
Copy link

Link copied!

@Drrickrypwhich approach will not work?

second question, if i use Coalesce(Parent.Default,var1) then on new form both the values will be empty,, so will Coalesce chose the last value?

Was this reply helpful? Yes No
johnjohn123 3,514 on at

Like (0)

Report
Copy link

Link copied!

@RandyHayesi am not assign the Var1, i am using it to set the value of the drop-down value when i click on a button, as follow:-

Set(Var1,Filter(Choices([@'Approval Process'].'Document Approval Process Status'),Value="Submitted"));SubmitForm(SharePointForm1)

i hope this explain the case for you...

Was this reply helpful? Yes No
johnjohn123 3,514 on at

Like (0)

Report
Copy link

Link copied!

@AndreaMondelloit is surprising that most of the formulas which i got on this forum do not work...

Was this reply helpful? Yes No
johnjohn123 3,514 on at

Like (0)

Report
Copy link

Link copied!

@AndreaMondelloi also tried your formual

If(Parent.Default=Blank(),Today(),Parent.Default)

and it will not work... i will always get today() date !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

Was this reply helpful? Yes No
RandyHayes 76,299 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

@johnjohn123

I am not sure why you are referring to the Date now...what does this have to do with your question on setting your combobox?

What I am not getting is what you are trying to do.

You provided the following formula:

Set(Var1,Filter(Choices([@'Approval Process'].'Document Approval Process Status'), Value="Submitted")); SubmitForm(SharePointForm1)

So why are you setting a variable and then submitting a form? That makes no sense in the context of the DefaultSelectedItems property that you are trying to set.

Can you elaborate more on where you are trying to go on this problem?

Was this reply helpful? Yes No
johnjohn123 3,514 on at

Like (0)

Report
Copy link

Link copied!

@RandyHayesnow i have a drop-down list titled "document approval process status".. and it is disabled.. and i have a button name "Submit for approval" when clicked will set the drop-down value to be "submitted" using this formula:-

Set(Var1,Filter(Choices([@'Approval Process'].'Document Approval Process Status'), Value="Submitted")); SubmitForm(SharePointForm1)

and i set the default value for the drop-down to be equal to Var1. things will work well >> where if i click on the button the value of the drop-down will be set to Submitted + the form will get saved (submitted).. but the issue is; if i edit the form and the item already has a value inside the drop-down list then the drop-down list will be empty.. so i tried this forumal to get the current value of the drop-down list, but i got the error:-

i hope this explain the case..

Was this reply helpful? Yes No