How to get data in the form of a single value rather than a table inside collection column

(0) Share

Report

Posted on by Anonymous_Hippo

1,247 Super User 2024 Season 1

Dears,

I am using a ForAll function but it returns the data as a table. How can i convert it into a single column

This is how the data is returned

All these tables only have one record.

I would like this collection to look like this

DrRDate | Drid | ID

5/3/2022 | 2 | 2

2/2/2022 | 1 | 1

This is the formula that i am using

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

Thanks

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Verified answer

BCBuizer 22,636 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!
HI @Anonymous_Hippo ,

Try calling the column in the record:

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

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

Like (0)

Report
Copy link

Link copied!
Sorry ,May i ask one more question @BCBuizer !

I am trying to recreate a collection by splitting it based on Char(10)

For example this is the original collection

I want to create a new collection that would basically loop though and make each date into a single row

This is how i want it to look

ID | DRDueDate

1 | 1/2/2022

1 | 5/5/2022

1 | 2/4/2022

2 | 1/2/2022

2 | 5/5/2022

How can i do that. Using two forall loops doesn't seem to work correctly, can you please help 🙂 This is my corrected formula

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

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

Like (0)

Report
Copy link

Link copied!

@BCBuizer Please disregard my previous question. I was able to figure out why it was not working . Thank you !

Was this reply helpful? Yes No