web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps PowerApps, trying to u...

Power Apps

Unanswered

PowerApps, trying to use Collect , inside a If statement while the If statement is inside a ForAll iteration

(0) Share

Report

Report

Posted on by bkumar

46

ForAll(

ComboBox1_21.SelectedItems As a,

If(

IsBlank(

LookUp(

collectICSGBUBrands,

ICSPeriod = Dropdown2_58.Selected.Name And

ICSYear = Dropdown2_57.Selected.Name And

Name = ComboBox1_45.Selected.Value And

Entitiesmapping = Value(a.EntityCode)

)

),

// If the condition is true, execute the Patch function to update the data source:

Patch(

ICSGBUBrands,

Defaults(ICSGBUBrands),

{

Name: Concatenate(ComboBox1_45.Selected.Value, "bhasker"),

Entitiesmapping: Value(a.EntityCode),

ICSYear: Dropdown2_57.Selected.Name,

ICSPeriod: Dropdown2_58.Selected.Name

}

),

// If the condition is false, skip this iteration and move to the next element:

Blank();

Collect(test123,a.EntityCode) // This line is giving error also tried Collect(test123,"Dummystring") , still same error

)

);

Categories:

Power Apps Pro Dev & ISV

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (1)

Verified answer

v-jefferni on at

Like (0)

Report
Hi @bkumar ,

Is it invalid argument type error? If so, the reason is within If statement, true and false results need to be with the same structure and data type. Please try and use Switch function instead:

ForAll( ComboBox1_21.SelectedItems As a, Switch( IsBlank( LookUp( collectICSGBUBrands, ICSPeriod = Dropdown2_58.Selected.Name And ICSYear = Dropdown2_57.Selected.Name And Name = ComboBox1_45.Selected.Value And Entitiesmapping = Value(a.EntityCode) ) ), true, // If the condition is true, execute the Patch function to update the data source: Patch( ICSGBUBrands, Defaults(ICSGBUBrands), { Name: Concatenate(ComboBox1_45.Selected.Value, "bhasker"), Entitiesmapping: Value(a.EntityCode), ICSYear: Dropdown2_57.Selected.Name, ICSPeriod: Dropdown2_58.Selected.Name } ), false, // If the condition is false, skip this iteration and move to the next element: Collect(test123,a.EntityCode) ) );

Best regards,

Was this reply helpful? Yes No
bkumar 46 on at

Like (0)

Report

Dear @v-jefferni , many thanks for your kind reply.
yes the error was "there is a invalid argument in the ForAll"
It worked perfectly with your code

Was this reply helpful? Yes No

Join the conversation