If statement inside ForAll

(0) Share

Report

Posted on by Anonymous_Hippo

1,247 Super User 2024 Season 1

This is how my data looks. I am using two ForAll loops to extract the multiline data into individual rows.

The below formula works well, But unfortunately when Deficiency # column is blank it ignore that row since no value is returned.

ForAll(
 col_Sample,
 ForAll(
 Split(
 'Deficiency #',
 Char(10)
 ),
 Collect(
 Test2121,
 {
 ID: ID,
 Drid: Result,
 DrRDate: Last(
 FirstN(
 Split(
 'DR Received Date',
 Char(10)
 ),
 Value(Result)
 )
 ).Result
 }
 )
 )
);

I would like to add a single row with the ID number added in the scenario when the spit function returns an empty table. How can this be done 🙂 Not able to figure this one out.... this feels very easy though 😫

Thank you !!!!

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

rubin_boer 4,843 Super User 2024 Season 1 on at

Like (1)

Report
Copy link

Link copied!
hi @Anonymous_Hippo try replacing

Split( 'Deficiency #', Char(10) )

With

Split(Coalesce('Deficiency #',"0"),Char(10))

Maybe give index a shot as well for

Last( FirstN( Split( 'DR Received Date', Char(10) ), Value(Result) ) ).Result

Index(Split('DR Received Date',Char(10)), Value(Result)).Result

Test Run:

Button OnSelect:

ClearCollect( colFunky, Table( { name: "test 1", check: "1 2 3", val: "abc cde edf" }, { name: "test 2", check: "", val: "klm mno pqr" } ) ); Clear(colWhoop); ForAll( colFunky, ForAll( Split( Coalesce( check, "0" ), Char(10) ), Collect( colWhoop, { rName: name, rCheck: Result, rVal: Index( Split( val, Char(10) ), Value(Result) ).Result } ) ) )

colFunky

ColWhoop

The blank is also added

Hope it helps,

R

Was this reply helpful? Yes No
Anonymous_Hippo 1,247 Super User 2024 Season 1 on at

Like (1)

Report
Copy link

Link copied!

@rubin_boer Your solution was not HELPFUL

.

.

.

.

because it was SUPER HELPFUL 🙌

Index function is new to me thank you for that as well !!!

Thank you !! 😁

Was this reply helpful? Yes No