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

Answered

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)

Sort by

Verified answer

v-jefferni Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
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
Copy link

Link copied!

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