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