I am currently having an issue with Dynamics as a data source.
I have an app, which enables a user to add a new weight measurement for an animal. The weight is a custom entity on D365, and is linked to the animal, another custom entity. Within the animal entity, there is a field called Current Weight Date, which populates itself from the most recently added weight linked to that specific animal from the Weight entity.
Adding a new weight works fine, and listing old weights also works perfectly.
I am trying to get the animals that have already been weighed on a day to remove from the gallery of animals but this is currently not working. I have checked the entries, and they are populating D365 as expected, and filling out the related field, but the gallery is not updating in real time.
The gallery does not refresh when navigating back to the gallery after adding the weight, and also does not work on the click of a refresh button, which is set to refresh both the Weight and Animal entities as data sources. The Refresh function is in the formula of the navigation after the weight is added as well.
The gallery only updates if a user exits the list of animals back out to a previous screen which chooses the barn where the animals are located, and re-selects the barn. The gallery then does not show those animals with a Current Weight Date of today.
The back and forth is really not practical, as some barns hold well over 100 animals.
The gallery items formula is as follows;
SortByColumns(Filter(Animals,currentbarnid_value='FS Barn Dropdown'.Selected.barnsid && 'Current Weight Date'<> Today() && StartsWith(animal_name,'FA Text Search Box'.Text)),"animal_name")
Can someone shed any light? Any assistance is appreciated.
Hi @yashag2255 ,
Thanks for the swift response. I have tried your suggestion, and still getting the same issue. The weights are adding, and are listed in the correct order, but those animals weighed today are not removed from the gallery list.
Check out the on demand sessions that are available now!
Stay up tp date on the latest blogs and activities in the community News & Announcements.
Features releasing from October 2020 through March 2021
Check out the Power Platform Community Highlights