Concurrent not passing thrue the first formula

(2) Share

Report

Posted on by Cyril06

159

Hello I have a large library into sharepoint 12368 lines.

I saw this Breaking Free from the 2,000-Row Limit in PowerApps Data Collection | by Ege Bent | Medium

I can't understand why my concurrent do not pass the first formula.

I created a false sharepoint list with 15268 entries but it only take the first 1999 into the forts collection and nothing into the others .

Do you have clues please? For your information I'm French and the "," is replaced by ";" ;)

Concurrent(
    Collect(collection1;Filter(test15000lignes;ID<=2000));  
    Collect(collection2;Filter(test15000lignes;ID>=2001 && ID<= 4000)); 
    Collect(collection3;Filter(test15000lignes;ID>=4001 && ID<=6000)); 
    Collect(collection4;Filter(test15000lignes;ID>=6001 && ID<=8000));
    Collect(collection5;Filter(test15000lignes;ID>=8001 && ID<=10000));
    Collect(collection6;Filter(test15000lignes;ID>=10001 && ID<=12000));
    Collect(collection7;Filter(test15000lignes;ID>=12001 && ID<=14000));
    Collect(collection8;Filter(test15000lignes;ID>=14001 && ID<=16000));
    Collect(collection9;Filter(test15000lignes;ID>=16001 && ID<=18000));
    Collect(collection10;Filter(test15000lignes;ID>=18001 && ID<=20000))
);;

Thank you for your help

Categories:

Using Apps Using Formulas

General Questions

All responses (2)

Answers (1)

Cyril06 159 on at

Like (0)

Report

Concurrent not passing thrue the first formula

Hello Warren and thank you for your reply.

You are right the ID is only Delegable for = , I found it just after I posted but I couldn't find my post to retrieve it.

May be it will help someone else.

Thank you again have a nice day.
Verified answer

WarrenBelz 146,524 Most Valuable Professional on at

Like (1)

Report

Concurrent not passing thrue the first formula

Hi Cyril06

Concurrent() is not the issue - the ID field in SharePoint is only Delegable for the Equals = operator - SharePoint will not accept Delegation for Greater than > or Less than < . The only way you can make a big collection like that is to have an additional unique sequential numeric field, which would generally contain the ID (it is the Row_Id field in the article you referenced). This can be populated when the file is created using Power Automate and existing records would need to be back-populated.

I have a blog on the collection process of all records, but also bear in mind that the 2,000 item limit is there for a good reason related to performance. I have found that much more than double (4k) shows significant performance impediment and I believe 20k would be glacial and possibly unusable.

Please click Does this answer your question 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 a Like.
MVP (Business Applications) Visit my blog Practical Power Apps Buy me a coffee