Unanswered

Filter with Sort returning incorrect data from SharePoint list

(0) Share

Report

Posted on by biterbit

406

Users of an app I developed some time ago have recently reported that data is missing from a gallery view. On investigation I have found that the gallery's Items property seems to be the problem. The property was set to:

Sort(Filter('Forms processing', Outcome.Value = "Waiting correction" ), Submission)

The Forms processing table is a SharePoint list, Outcome is a Choice column, and Submission is a date column. The gallery is returning no data even through one record matches the Filter criterion. If I remove the Sort element in the property, the matching record is shown:

Filter('Forms processing', Outcome.Value = "Waiting correction" )

This was working fine until recently and I have recently encountered a similar problem in Power Automate where sorting on a date field caused an incorrect data set to be returned. Has something broken in SharePoint?

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (0)

Shravyashree_01 174 Moderator on at

Like (0)

Report

Hi @biterbit ,
Sort(Filter('Forms processing', Outcome.Value = "Waiting correction" ), Submission,SortOrder.Descending))

Could you please try the above.

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Was this reply helpful? Yes No
biterbit 406 on at

Like (0)

Report

@Shravyashree_01 Thanks for your quick response. I tried adding the SortOrder parameter, but this too returned no data.

Was this reply helpful? Yes No