Canvas App Dropdown column does not show options

(1) Share

Report

Posted on by MTNK

819 Moderator

Good morning!

I made a canvas app from SharePoint list and sometimes for dropdown columns, it does not show options(added images for reference). And it happens with other columns(with same drop down options) also. It is not particular with only this column. It also happened with Location Dropdown column.

What could be the reason.

(No error in power apps)

Categories:

Building Power Apps

I have the same question (0)

All responses (9)

Answers (1)

KeithAtherton 3,707 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!

Hi @mtsts,

What is the Item property for the dropdown control please?

Also, if you select the Items property in the formula bar and expand the data view, what do you see? For example:

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
MTNK 819 Moderator on at

Like (1)

Report
Copy link

Link copied!

@KeithAtherton
Thanks much for helping.

Items Property -

Options -

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

Like (1)

Report
Copy link

Link copied!
Thanks for the info. Have you noticed anything in common when the dropdown values (Good / Action Needed / N/A values values) do / don't show?

For example, the values may not show if you try the dropdown quickly, almost as if the values are taking a while to be retrieved.

I'd suggest trying a test where the dropdown values are saved to a collection on the App OnStart action (see example below) then use that collection for the dropdown Items property:

ClearCollect(colOptions, Choices([@'Walk Through Inspection Checklist 2024'].'Material has at least 2 feet of clearance before a ceiling light'));

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
MTNK 819 Moderator on at

Like (1)

Report
Copy link

Link copied!

@KeithAtherton Yes you are absolutely right. The values are taking a while to be retrieved. And if I knew the options and I search Good and the option just pops up in selections to select.

I tried this formula and It is creating errors(added image for reference).

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

Like (1)

Report
Copy link

Link copied!

Did adding the Power Fx in my last message introduce all those errors?

If so, please provide all code in the App OnStart action.

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
MTNK 819 Moderator on at

Like (1)

Report
Copy link

Link copied!

@KeithAtherton
Yes.

There is no code in the App OnStart action.

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

Like (1)

Report
Copy link

Link copied!

I previously suggested placing the code in the App OnStart action which is why I expected it to be there 🙂

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
MTNK 819 Moderator on at

Like (1)

Report
Copy link

Link copied!

@KeithAtherton That makes sense. Thanks much for helping.

And the code is for only one column and the app does not also seems to work with other columns as well sometimes(behaves same way with all other columns also). How to fix it.
(As when I shared the app to the concerned person to test, it was behaving same way for a particular column and on my end it was working fine at same moment.)

Was this reply helpful? Yes No
Verified answer

KeithAtherton 3,707 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!

You're welcome. It's difficult to pinpoint the root cause if the app behaves differently for you and for someone else, unfortunately.

If the only issue was the delay in retrieving data then I would suggest saving the data to a local collection (as per the previous message) and using a timer control to perform a delay while that data is obtained.

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