On Start Error

(0) Share

Report

Posted on by tlevine

230

Hi All -

I have recently started to get an error when my app loads (See screenshot attached). I have tried to trouble shoot but I am unsure of how to proceed. When I run the On Start command in edit mode the data properly loads into the collection without any issue. Only when I launch the app in Play mode do I receive the issue. Below is my On Start procedure. Thoughts? Screen Shot 2019-12-13 at 11.57.32 PM.png

Concurrent(
ClearCollect(
AllRAWDATA,
'[dbo].[Slow_Moving_Raw_Data]'
),
ClearCollect(
ColPlanReview,
'[dbo].[Slow_Moving_Raw_Data]'
),
Set(
varUser,
User().FullName
),
Set(
varUserEmail,
User().Email
),
Set(
varToday,
Text(
Today(),
DateTimeFormat.ShortDate,
"en-US"
)
),
Set(
varManagerName,
Office365Users.Manager(Text(Office365Users.MyProfile().Id)).DisplayName
),
Set(
varPeriod,
Text(
Today(),
"[$-en-US]mmmm - yy"
)
),
Set(
varAdmin,
Value(1)
)
)

Screen Shot 2019-12-13 at 11.57.32 PM.png

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (1)

Sort by

mdevaney 29,991 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!
@tlevine

There's an issue at the 427th character in your code. What happens if you remove this code block? Does this issue go away? If yes, then its the problematic code.

Set( varPeriod, Text( Today(), "[$-en-US]mmmm - yy" ) ),

Also, you will want to change this code at the end of your block

Value(1)

Into this instead.

1

---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."

Was this reply helpful? Yes No
tlevine 230 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi - thank you or the reply. I did remove the code but the issue still persists. Any other ideas I could try?

Was this reply helpful? Yes No
Verified answer

mdevaney 29,991 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!
@tlevine

The next step is ensure this advanced setting is turned off. In previous forum posts it fixed the issue.

I am going to repost a formatted version of your code here to enhance readability for myself. After doing some testing there appears to be nothing wrong with the SET variables. The CLEARCOLLECT statements look fine so I'm wondering if toggling that advanced setting will fix the isuse.

Concurrent( ClearCollect( AllRAWDATA, '[dbo].[Slow_Moving_Raw_Data]' ), ClearCollect( ColPlanReview, '[dbo].[Slow_Moving_Raw_Data]' ), Set( varUser, User().FullName ), Set( varUserEmail, User().Email ), Set( varToday, Text(Today(),DateTimeFormat.ShortDate,"en-US") ), Set( varManagerName, Office365Users.Manager(Text(Office365Users.MyProfile().Id)).DisplayName ), Set( varPeriod, Text(Today(),"[$-en-US]mmmm - yy") ), Set( varAdmin, 1 ) )

Let me know how it goes.

---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."

Was this reply helpful? Yes No
tlevine 230 on at

Like
a
(0)

Report
Copy link

Link copied!

That worked for me! What exactly does that setting do?

Was this reply helpful? Yes No
mdevaney 29,991 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

@tlevine

Judging strictly from reading old forum posts the purpose of this setting is simply to break people's apps LOL. (That's a joke).

I haven't got a hot clue what it does 😿 Perhaps @v-xida-msft can let us know the next time he is online.

---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."

Was this reply helpful? Yes No