Concat Max length

(0) Share

Report

Posted on by EddieE

4,650 Moderator

Hi all,

Has anyone had any experience using Concat to get an extra long string of filenames from a SharePoint Document Library? I'm wanting to use this process to check if a filename exists in the Library before saving via PowerApps.

My code:

// Boolean test to check if filename exists
Label10.Text in Concat(
 ForAll(
 myLibraryName,
 {FileName: ThisRecord.Name}
 ),
 FileName & ","
)

Wrapping my ForAll() in Len() shows there are ~4400 characters from 82 filenames, currently in the Library. Future plans could see this DocLib expand and I'm wondering if I should be doing this differently for longevity?

Any input welcome.

Thanks

Categories:

Building Power Apps

All responses (2)

Answers (2)

Sort by

Verified answer

WarrenBelz 156,750 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @EddieE ,

Consider storing your file name in a Text field with a Flow when it is first created (I do that on a large Library I have and call it NameFile)

IsBlank( LookUp( myLibraryName, NameFile = Label10.Text ) )

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

MVP (Business Applications) Visit my blog Practical Power Apps
Verified answer

EddieE 4,650 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

@WarrenBelz

Thanks for the reply mate - haven't you retired haha 😛

I did some further testing on a library I had access to with a large number of files, findings were

- the ForAll() peaked out at 2,000 records - this was expected

- the Concat() on those 2,000 records got up to ~50,000 characters returned

I suspect that Concat() could go further than that - not sure really.

I will take your suggestion onboard and keep it in my back pocket for when/if this library expands beyond 2k records - seems my ForAll() should be good for now, and possibly for the life of this app 🙂

Cheers again mate!