Cannot filter data in SharePoint lists (MS Beta office can't help me!)

[afernando]

Hi,

I have been trying to import a list of distinct values and filter them within a PowerApp but not having any luck.

My formula is below;

Distinct(Filter(workorders,  Not(OrderNo in Production.OrderNo) && DateValue(DateRequired) = dpPlanDate.SelectedDate), OrderNo)

workorders and Production are two SharePoint lists that only include number and text fields. And the formula is used for 'items' in a dropdown menu.

The issue I'm having is, the formula doesn't seem to work in the 'view' mode. Most of the time I open the app in the view mode, my dropdown menu is empty and the moment I switch to 'Edit' mode, dropdowm menu starts showing data.

I have tested with many apps and different SP lists but issue seems to be persistant. Any help to resolve this issue is highly appreciated!

Thanks

[LauraOnu]

Formula looks all good, indeed for the dropdown. Is view mode the "View item" screen in an app created via "start from data"?

Want to make sure I understand the question, did you add a dropdown to that screen as well and is not populating with any data?

[WendyLi]

Hi ,

As the data could show well in "Edit" mode, it should work in "View" mode.

To narrow down this issue, could you add a dropdown list into the same screen, then check if the dropdown list works?

In addition, check if you are using the latest version of PowerApps. If not, please install the latest version, then test agin.

Thanks,

Wendy

[afernando]

Thanks for your reply. I have the latest version installed. And I tried adding a new drop down menu, connecting to a different sharepoint list and creating the app from the beginning. But none of them worked.

This is a common problem in all my apps. I am confused why they work perfectly in edit mode but not in the edit mode! 

Please let me know if you need more details or have any suggestions. Thanks

[afernando]

Hi Laura,

Thanks for your reply. The entire app was created from the scratch. 

And my problem is the dropdown menu not populating data in 'View Mode'. But it works perfectly in the edit mode. 

This is a common issue in all my apps and not limited to dropdown menus. Even galleries cannot populate data in 'view mode.' 

All my lists have less that 100 rows and only text and number fields. I would really appreciate if you can help sort this issue as I'm completely stuck with all my projects becuase of this issue! 

Please feel free to contact me if you need more information. Thanks

[LauraOnu]

We could not repro this issue on our end yet, to help us narrow down the investigation, can you confirm please if this is happening with the following configuration:

- the latest PowerApps client version

- using a newly created SharePoint connection

[afernando]

Hi All,

Thanks for your valuable feedback. I figured out the issue myself and it was due to the diffrence in dateTime format that data wasn't apprearing. 

I fixed the issue by specifying locale in my formula but data is still shown only in US format in my apps.