Power app search function for recent SharePoint data

%3CLINGO-SUB%20id%3D%22lingo-sub-2550632%22%20slang%3D%22en-US%22%3EPower%20app%20search%20function%20for%20recent%20SharePoint%20data%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2550632%22%20slang%3D%22en-US%22%3E%3CDIV%20class%3D%22style-scope%20ytd-comment-renderer%22%3E%3CDIV%20class%3D%22style-scope%20ytd-expander%22%3E%3CSPAN%20class%3D%22style-scope%20yt-formatted-string%22%3ESortByColumns(Search(AddColumns('TWT%20Production%20Output'%2C%22CrewMemberValue%22%2CCrewMember.Value)%2CTextInput2.Text%2C%22CrewMemberValue%22)%2C%22Date%22%2CSortOrder.Descending).%20%3C%2FSPAN%3E%3C%2FDIV%3E%3CDIV%20class%3D%22style-scope%20ytd-expander%22%3E%26nbsp%3B%3C%2FDIV%3E%3CDIV%20class%3D%22style-scope%20ytd-expander%22%3E%3CSPAN%20class%3D%22style-scope%20yt-formatted-string%22%3EThis%20is%20my%20items%20formula%20for%20gallery.%20But%20employees%20can%20not%20search%20recent%20data%20by%20CrewmemberValue.%20because%20the%20app%20is%20taking%20first%202000%20list%20items.%20So%20is%20there%20any%20formula%20to%20fetch%20latest%201000%20items%20rather%20than%20items%20from%20beginning.%20Crewmember%20is%20a%20choice%20column%20in%20SharePoint.%20That%20is%20why%20I%20used%20'AddColumns'%20property.%3C%2FSPAN%3E%3C%2FDIV%3E%3CDIV%20class%3D%22style-scope%20ytd-comment-action-buttons-renderer%22%3E%3CDIV%20class%3D%22style-scope%20ytd-comment-action-buttons-renderer%22%3E%26nbsp%3B%3C%2FDIV%3E%3CDIV%20class%3D%22stroke%20style-scope%20yt-interaction%22%3E%26nbsp%3B%3C%2FDIV%3E%3CDIV%20class%3D%22fill%20style-scope%20yt-interaction%22%3E%26nbsp%3B%3C%2FDIV%3E%3CDIV%20class%3D%22stroke%20style-scope%20yt-interaction%22%3E%26nbsp%3B%3C%2FDIV%3E%3CDIV%20class%3D%22fill%20style-scope%20yt-interaction%22%3E%26nbsp%3B%3C%2FDIV%3E%3CDIV%20class%3D%22style-scope%20ytd-comment-action-buttons-renderer%22%3E%26nbsp%3B%3C%2FDIV%3E%3CDIV%20class%3D%22style-scope%20ytd-comment-action-buttons-renderer%22%3E%3CA%20target%3D%22_blank%22%3EREPLY%3C%2FA%3E%3C%2FDIV%3E%3C%2FDIV%3E%3CDIV%20class%3D%22style-scope%20ytd-comment-action-buttons-renderer%22%3E%26nbsp%3B%3C%2FDIV%3E%3C%2FDIV%3E%3CDIV%20class%3D%22style-scope%20ytd-comment-renderer%22%3E%26nbsp%3B%3C%2FDIV%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2550632%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EPowerApps%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor
SortByColumns(Search(AddColumns('TWT Production Output',"CrewMemberValue",CrewMember.Value),TextInput2.Text,"CrewMemberValue"),"Date",SortOrder.Descending).
 
This is my items formula for gallery. But employees can not search recent data by CrewmemberValue. because the app is taking first 2000 list items. So is there any formula to fetch latest 1000 items rather than items from beginning. Crewmember is a choice column in SharePoint. That is why I used 'AddColumns' property.
 
 
 
 
 
 
 
 
0 Replies