Skip to main content

Notifications

Power Apps - Building Power Apps
Unanswered

Canvas App Dropdown column does not show options

(1) ShareShare
ReportReport
Posted on by 272

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)

 

mtsts_3-1718031127981.png

 

mtsts_4-1718031287780.png

 

 

 

  • KeithAtherton Profile Picture
    KeithAtherton 3,640 on at
    Re: Canvas App Dropdown column does not show options

    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.

  • FnuMeenu Profile Picture
    FnuMeenu 272 on at
    Re: Canvas App Dropdown column does not show options

    @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.)

  • KeithAtherton Profile Picture
    KeithAtherton 3,640 on at
    Re: Canvas App Dropdown column does not show options

    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.

  • FnuMeenu Profile Picture
    FnuMeenu 272 on at
    Re: Canvas App Dropdown column does not show options

    @KeithAtherton 

    Yes. 

     

    There is no code in the App OnStart action.

  • KeithAtherton Profile Picture
    KeithAtherton 3,640 on at
    Re: Canvas App Dropdown column does not show options

    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.

  • FnuMeenu Profile Picture
    FnuMeenu 272 on at
    Re: Canvas App Dropdown column does not show options

    @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).

     

    mtsts_0-1718037715912.png

     

  • KeithAtherton Profile Picture
    KeithAtherton 3,640 on at
    Re: Canvas App Dropdown column does not show options

    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.

  • FnuMeenu Profile Picture
    FnuMeenu 272 on at
    Re: Canvas App Dropdown column does not show options

    @KeithAtherton 

    Thanks much for helping.

     

    Items Property - 

    mtsts_0-1718032881925.png

     

    Options - 

    mtsts_1-1718033424459.png

     

  • KeithAtherton Profile Picture
    KeithAtherton 3,640 on at
    Re: Canvas App Dropdown column does not show options

    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:

    KeithAtherton_0-1718032629851.png


    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.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,445

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,741

Leaderboard