SOLVED

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
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
Highlighted
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.
Highlighted
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!
Highlighted

@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!