I am trying to filter the entity list using a metadata filter but sometimes it is not working properly.
In the metadata filter, I have included one radio button attribute filter set and one text filter (for a date, I am using date picker using Html js code and also on change of that date picker I am updating that date text to filter my data).
There is one page where I have a form created in "Student_Site_Default" Entity, this entity is storing the default of some fields and once the data is inserted by the user then a automate flow trigger to insert all the student data for that site for that day in another entity i.e "Student_Daily_Activity".
I have created Entity List on top of "Student_Daily_Activity" Entity and added metadata filter.
Example of scenario where the filter is not working:
1. From "Student_Site_Default" Web page I insert data for Site A and Date (9/23/2020), which store in "Student_Site_Default" Entity. And user navigated to "Student_Daily_Activity" web page where an Entity List is there which display all the data coming from "Student_Daily_Activity" Entity.
2. Now a power automate flow is trigger once data is inserted. trigger take around 5-10 sec. to load the data for all he student associated with Site A in Entity "Student_Daily_Activity".
3. In the "Student_Daily_Activity" Web page I am populating the Default date and select "In/After School" radio button based on the default data inserted from "Student_Site_Default" web page.
4. When Page refresh and after 15 sec I click on "Filter data" button then also data is not filtering/showing for those combinations. I can see that data is populated by automate flow in the Entity but still is it is not showing upon click on filter data.
I have checked the "Enable Change Tracing" for that Entity. I am feeling like it may be a cache issue or something is wrong with the Entity list or Filter.
Please help me with this issue.
Any Help will be appreciable.
I would absolutely agree that it's most likely a cache issue. I've talked about some of the issues caused with any asynchronous updates, as well as some of the oddities of the views (which you could try testing against this list) on my last post: https://justinburch.com/cache-tips
One way to test is the approach mentioned there on changing the sort order. Another way you could verify this issue on your end is by resetting the cache as soon as you encounter the issue and see if the data now reflects correctly.
Thanks for your response!
I have gone through your post and it's really good. But still I can't find a proper way to resolve the issue.
I can't tell the end user to change the sort order first and then click on filter data button to filter the data in entity list.
Is there any proper and full prove solution to fix this issue?
Any help or guidance will be really helpful. This issue is taking my head off 😂.
Note that all of this comes from years of personal experience, and though they don't explicitly claim this won't work when done synchronously, Microsoft simply recommends against any processing outside of direct portal configurations or updates: https://powerapps.microsoft.com/en-us/blog/caching-changes-for-power-apps-portals-with-version-9-2-6...
Thanks for all the answers!
I have raised a support ticket for the same, Lets see what I get from there.
But for now, I have used one workaround to resolve the caching issue by creating on fectxml metadata filter and used "ne" and created on the custom button where on click on that custom button I am setting a dt (var dt =new date(); ) variable value and then click on the actual button to clear the cache. By this way on every click of custom button new date with timestamp is setting to that fetchxml filter input and it is clearing the cache.
But I think there should be a proper OOTB feature which does this kind of thing
Check out the on demand sessions that are available now!
ISV Studio is designed to become the go-to Power Platform destination for ISV’s to monitor & manage published applications.
Features releasing from October 2020 through March 2021
Una semana de contenido con +100 sesiones educativas, consultorios, +10 workshops Premium, Hackaton, EXPO, Networking Hall y mucho más!