Answered

App works in Canvas studio but NOT in production. Ideas?

(2) Share

Report

Posted on by ChrisChong

Here is the formula used:

Filter(
 'SOI Orders',
 StartsWith(Title,txtFacilityName_1.Value) , 
 StartsWith(LastName,txtLastname_1.Value),
 StartsWith(City,txtCity_1.Value),
 (IsBlank(ddYearTerm_1.Selected.Value) || YearTerm = ddYearTerm_1.Selected.Value),
 (IsBlank(ddFacilityType_1.Selected.Value) || TypeOfSchool.Value = ddFacilityType_1.Selected.Value),
 (IsBlank(ddProvince_1.Selected.Value) || Province = (ddProvince_1.Selected.Value)), 
 (ddNotFilled_1.Selected.Value || DateRequestFilled=Blank()) 
 
)

This pic is production:

And this pic is in Canvas studio:

I don't understand why the production fails like this. There is no error shown.

Can someone think of what I have done wrong?

Thanks for your help.

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

Sort by

KeithAtherton 3,709 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!

Hi @ChrisChong,

The code looks good. Silly question: are you running the app in canvas studio in a Development environment but playing the app in a Production environment and they both have different data?

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.
Connect with me online.

Was this reply helpful? Yes No
ChrisChong on at

Like
a
(2)

Report
Copy link

Link copied!

Thank you for your response. They are both in the same environment.
Too bad, that would have been simple.

Was this reply helpful? Yes No
KeithAtherton 3,709 Most Valuable Professional on at

Like
a
(2)

Report
Copy link

Link copied!

Thanks - I suspected that was the case but thought I'd rule it out 🙂

As a test, could you try setting the gallery Items property to 'SOI Orders' (without any filters) to check if any data is returned? It may then be trial-and-error to see which part of the filter is causing the issue.

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.
Connect with me online.

Was this reply helpful? Yes No
Verified answer

timl 37,283 Super User 2026 Season 2 on at

Like
a
(2)

Report
Copy link

Link copied!

@ChrisChong -

The Monitor tool might help you by showing the query request to the data source and the response.

You can use this on the published by app by clicking the 3 dots next to the app in the app list, clicking Details > Monitor, and clicking 'Play published app' in the Monitor window.

Was this reply helpful? Yes No