SOLVED
Home

Powerapps gallery help

%3CLINGO-SUB%20id%3D%22lingo-sub-848874%22%20slang%3D%22en-US%22%3EPowerapps%20gallery%20help%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-848874%22%20slang%3D%22en-US%22%3E%3CP%3EGreetings%20everyone%20-%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20fairly%20new%20to%20Powerapps%20and%20require%20your%20assistance.%26nbsp%3B%20Please%20bear%20with%20me%20if%20I%20ask%20too%20many%20questions%20as%20I%20am%20trying%20to%20understand%20and%20learn%20at%20the%20same%20time.%26nbsp%3B%20%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20created%20a%20Powerapps%20form%20with%20a%20Gallery%20that%20pulls%20a%20Sharepoint%20calendar%20list%20of%20events.%26nbsp%3B%20%26nbsp%3BHowever%20on%20the%20gallery%2C%20I%20would%20like%20to%20have%20Powerapps%20automatically%20drop%20the%20events%20that%20has%20passed.%26nbsp%3B%20How%20do%20I%20go%20about%20doing%20so%3F%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20in%20advance%20for%20your%20assistance.%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-848874%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EPowerApps%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-849168%22%20slang%3D%22en-US%22%3ERe%3A%20Powerapps%20gallery%20help%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-849168%22%20slang%3D%22en-US%22%3EThat's%20a%20hard%20question%20due%20to%20delegation%20and%20SharePoint%20not%20being%20able%20to%20support%20date%20delegation%20yet.%20As%20long%20as%20you%20have%20less%20than%202000%2C%20you%20don't%20have%20to%20worry%20about%20it%2C%20or%20if%20you%20don't%20plan%20to%20pass%202000%20events%20in%20the%20next%20year%20or%20so%20until%20they%20support%20dates%20(Might%20be%20sooner)%20just%20throwing%20it%20out%20there%20you%20should%20be%20good.%20%3CBR%20%2F%3E%3CBR%20%2F%3EThat%20said%2C%20in%20the%20Items%20property%20of%20your%20gallery%2C%20you%20need%20to%20use%20a%20Filter%20command%20to%20filter%20your%20datasource.%20%3CBR%20%2F%3E%3CBR%20%2F%3EIt's%20formatting%20is%20like%20Filter('sharepoint%20list'%2C%20'Start%20Date%20column%20name'%20%26gt%3B%20Today())%20should%20filter%20everything%20that%20is%20older%20than%20today%20out.%20%3CBR%20%2F%3E%3CBR%20%2F%3EStart%20Date%20column%20should%20just%20auto%20type%20ahead%20as%20you%20start%20typing%20so%20find%20it%20in%20the%20list%20since%20formatting%20could%20be%20tricky.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-849171%22%20slang%3D%22en-US%22%3ERe%3A%20Powerapps%20gallery%20help%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-849171%22%20slang%3D%22en-US%22%3EAlso%2C%20this%20isn't%20they%20best%20place%20for%20PowerApps%20help%2C%20it's%20a%20redundant%20forum%2C%20that%20isn't%20very%20active.%20All%20the%20Official%20Microsoft%20and%20MVP's%20and%20community%20hangs%20out%20on%20their%20official%20forums%20here%3A%20%3CA%20href%3D%22https%3A%2F%2Fpowerusers.microsoft.com%2Ft5%2FPowerApps-Community%2Fct-p%2FPowerApps1%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fpowerusers.microsoft.com%2Ft5%2FPowerApps-Community%2Fct-p%2FPowerApps1%3C%2FA%3E%3CBR%20%2F%3ESo%20going%20forward%20you%20might%20want%20to%20go%20there%20for%20your%20searching%20and%20questions%20etc!%20%3CBR%20%2F%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-849191%22%20slang%3D%22en-US%22%3ERe%3A%20Powerapps%20gallery%20help%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-849191%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F869%22%20target%3D%22_blank%22%3E%40Chris%20Webb%3C%2FA%3E%26nbsp%3B-%20thank%20you%20for%20your%20assistance%20and%20guidance.%26nbsp%3B%20I%20will%20take%20note%20of%20the%20forum%20address%20and%20utilize%20that%20for%20future%20questions%20or%20research.%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you!%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
R3d3mpt10n
Occasional Contributor

Greetings everyone -

 

I am fairly new to Powerapps and require your assistance.  Please bear with me if I ask too many questions as I am trying to understand and learn at the same time.   

 

I created a Powerapps form with a Gallery that pulls a Sharepoint calendar list of events.   However on the gallery, I would like to have Powerapps automatically drop the events that has passed.  How do I go about doing so?  

 

Thank you in advance for your assistance.  

3 Replies
That's a hard question due to delegation and SharePoint not being able to support date delegation yet. As long as you have less than 2000, you don't have to worry about it, or if you don't plan to pass 2000 events in the next year or so until they support dates (Might be sooner) just throwing it out there you should be good.

That said, in the Items property of your gallery, you need to use a Filter command to filter your datasource.

It's formatting is like Filter('sharepoint list', 'Start Date column name' > Today()) should filter everything that is older than today out.

Start Date column should just auto type ahead as you start typing so find it in the list since formatting could be tricky.
Solution
Also, this isn't they best place for PowerApps help, it's a redundant forum, that isn't very active. All the Official Microsoft and MVP's and community hangs out on their official forums here: https://powerusers.microsoft.com/t5/PowerApps-Community/ct-p/PowerApps1
So going forward you might want to go there for your searching and questions etc!

@Chris Webb - thank you for your assistance and guidance.  I will take note of the forum address and utilize that for future questions or research.  

 

Thank you!

Related Conversations
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
22 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
Edge insider Dev bypasses IE mode website list
HotCakeX in Enterprise on
4 Replies