Unanswered

App OnStart not working when publishing the form

(0) Share

Report

Posted on by NiteWalker

Hi,

I am setting data in the App OnStart function. It works when I hit the Run OnStart button to test it. But when I publish the form, it doesn't seem work.

The code is simple, I am just trying to get an ID from a different list by another ID that is in both lists. I have tried a few different ways, like:

// Set(varEmploymentServiceID,Filter('The other List',Value(lblID.Text) = theField.Value).ID);
ClearCollect(colESData,Filter('The other List',lblID.Text = theField.Value).ID)
// If(!IsBlank(varEmploymentServiceID),Set(varESId, First(varEmploymentServiceID).ID),Set(varESId,0))

Both of these work when Run OnStart and then look at the variables. But it doesn't work when published and I try to do a Notify() to show me the ID.

Any Ideas??

Thanks,

Monty

Categories:

Building Power Apps

I have the same question (2)

All responses (5)

Answers (1)

LaurensM 12,516 Moderator on at

Like (0)

Report

@NiteWalker

Hi Monty,

OnStart works a bit different in Customized Forms - it runs the first time you open the form until you e.g. refresh the browser tab. The easiest way to achieve a similar functionality is by using the Screen's OnVisible property.

In a standalone Canvas App, the OnStart would run each time the application is opened/refreshed.

If this solves your question, would you be so kind as to accept it as a solution & give it a thumbs up.

Thanks!

Was this reply helpful? Yes No
Pstork1 68,697 Most Valuable Professional on at

Like (0)

Report

The problem is that there is no guarantee that the connections to the data sources have completed loading by the time your OnStart code runs. They will be when you run it from the designer, but when you run it from the app itself they may still be loading. I would try moving this code to the OnVisible property of your start page. That may help with the timing.

Was this reply helpful? Yes No
NiteWalker 71 on at

Like (0)

Report

Hi,

Thanks for the quick replies!
I have moved the same code into the OnVisible property and it still doesn't seem to be working. I have verified that there is a item in the other table that should be returned. I tried showing the returned value in both a Notify and setting a label's text to the returned value.. both always blank!

Also - does the OnVisible run every time a form is closed and then a different list item is open? It doesn't look like it from what I see, was just wondering what you all see.

-Monty

Was this reply helpful? Yes No
Verified answer

LaurensM 12,516 Moderator on at

Like (0)

Report
Hi @NiteWalker,

After some testing, the OnVisible indeed only seems to run once. Given that information I would recommend writing your code in the OnView property of the SharePointIntegration component.

If you need to reference the ID of the selected record in this property, you can use 'Self.SelectedListItemID'. I will change lblID.Text to this reference instead:

ClearCollect( colESData, Filter( 'The other List', Text(Self.SelectedListItemID) = theField.Value ).ID )

I hope this helps!

Was this reply helpful? Yes No
NiteWalker 71 on at

Like (0)

Report

Wow - that was way more painful that it should have been.

Using the OnView property helped a lot!! Have to remember this one.

Thanks,

Monty

Was this reply helpful? Yes No