App Run on Start - Not working consistently

(0) Share

Report

Posted on by bsoleti

Hello,

I have a code on the App on start as

Concurrent(
ClearCollect(VarCollection11, Filter('Wheeler Docs', NumList >= 1 && NumList <= 2000)),
ClearCollect(VarCollection22, Filter('Wheeler Docs', NumList >= 2001 && NumList <= 4000));ClearCollect(VarCollection33, Filter('Wheeler Docs', NumList >= 4001 && NumList <= 6000));ClearCollect(VarCollection44, Filter('Wheeler Docs', NumList >= 6001 && NumList <= 8000));ClearCollect(VarCollection55, Filter('Wheeler Docs', NumList >= 8001 && NumList <= 10000)));
ClearCollect(CollectR, VarCollection11, VarCollection22,VarCollection33,VarCollection44,VarCollection55 )

Then i have form where i input a contract id value and search with a button and search will retreive rest of the field values from sharepoint .

When i search for a particular contract id which i know exists in sharepoint, it doesn't return anything , but when i manually run the app on start again i search the results are returned . When i publish the app to users i dont expect users asking me to run the app on start each time.

Search form

Search Contract Button Code

UpdateContext({AppIDVar:First(Filter(CollectR,ContractNumber=TextInput1_ContractID_1.Text)).ApplicationNumber});
UpdateContext({CustomerNameVar:First(Filter(CollectR,ContractNumber=TextInput1_ContractID_1.Text)).CustomerName});
UpdateContext({DocSourceVar1:First(Filter(CollectR,ContractNumber=TextInput1_ContractID_1.Text)).SourceSystem});
UpdateContext({BPNVar:First(Filter(CollectR,ContractNumber=TextInput1_ContractID_1.Text)).BPN});
UpdateContext({TINVar:First(Filter(CollectR,ContractNumber=TextInput1_ContractID_1.Text)).TIN});

Please advise on the resolution.

Thanks

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

Sort by

WarrenBelz 156,127 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
@bsoleti ,

Firstly, there is nothing wrong with your code that I can see, except I would probably drop the Concurrent to see if that makes a difference. You might also try running it at Screen OnVisible instead.

Concurrent( ClearCollect( VarCollection11, Filter( 'Wheeler Docs', NumList >0 && NumList < 2001 ) ), ClearCollect( VarCollection22, Filter( 'Wheeler Docs', NumList > 2000 && NumList < 4001 ) ); ClearCollect( VarCollection33, Filter( 'Wheeler Docs', NumList > 4000 && NumList < 6001 ) ); ClearCollect( VarCollection44, Filter( 'Wheeler Docs', NumList > 6000 && NumList < 8001 ) ); ClearCollect( VarCollection55, Filter( 'Wheeler Docs', NumList > 8000 && NumList < 10001 ) ) ); ClearCollect( CollectR, VarCollection11, VarCollection22, VarCollection33, VarCollection44, VarCollection55 )

The other part could also be tidied up as below

With( { wContract: Lookup( CollectR, ContractNumber=TextInput1_ContractID_1.Text ) }, UpdateContext( { AppIDVar:wContract.ApplicationNumber, CustomerNameVar:wContract.CustomerName, DocSourceVar1:wContract.SourceSystem, BPNVar:wContract.BPN, TINVar:wContract.TIN } ) )

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.

Was this reply helpful? Yes No
WarrenBelz 156,127 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @bsoleti ,

Just checking if you got the result you were looking for on this thread. Happy to help further if not.

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.

Was this reply helpful? Yes No
bsoleti 70 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi Warren,

So far seems to be working with your suggestion as i moved the collection code to screen visible , i am still testing further.

Thanks for your help as a;ways

Was this reply helpful? Yes No
Verified answer

WarrenBelz 156,127 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks @bsoleti ,

Also running Concurrent trying to do six collections from the same data source also is something I would not attempt and it is well worth (in my humble opinion anyway) taking the small performance hit to ensure you get all the data.

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.

Was this reply helpful? Yes No