Skip to main content

Notifications

Power Apps - Building Power Apps
Unanswered

PowerApps using SP List to update and filter

Posted on by

Hello All, 

Learning the hard way here.  I have limited working knowledge but able to read and learn.  Any help is appreciated 🙂

Been looking at all the posts and trying to piece it together on my own for a while. I don't have an inhouse expert to refer to.  

 

I have a Form that collects data into a SP List using Automate and retrieve user info from the "V2" Get User info. Got that to work. Yay!

 

I would like to have PowerApps show me a screen with limited contents from the list and update the list as selections in the PowerApps gallery are made that can be filtered and with the end result is to generate a printout containing the information selected from the current display. 

 

It would be Ideal to create an event in the SP Calendar for the company and invite the selected users to it. ( but that is the next adventure)

 

As of now I have a gallery that displays the information of how Id like to see it. 

- I would like to filter the gallery via "Period Selected" and further by columns (or content of the columns) "Job 1", "Job 2".... and so on.

- In the gallery I have check boxes that I wish to use to the columns "Selected Job 1", Selected Job 2"... and so on that are choices. Only choice is null or "Assigned". Those would need to correlate to the Job columns.

- To the right would be fields __/__ and __/__.  Those would display the total number of Jobs the employee has taken been assigned/taken on (from the SP list) for the selected "Period Selected" followed by total number of Jobs employee had been assigned/taken on for the year to date.

 

So what I'm trying to accomplish is a sign up for work available on a volunteer basis that employees can sign up for(Forms).  Collect the information in the SP List and send email confirmation to user of their selections (Automate, got that to work as well).  Once the sign up period closes (Automate task to selected supervision), supervisors will use the App to make selections for the jobs and print a list with the details to post/email.  Preferably the selections stay in the SP List if the paperwork needs to be reprinted/emailed in the future. 

 

Feels like I find formulas online but the language changed and the strings just don't work until I tinker with them and remove a command or add one. Full disclosure, Self taught and apparently not that well:)

 

So for now I'm stuck. I don't know if my approach is wrong, using wrong applications... I'm open to suggestions and a full restart if need be.  Maybe its simple, I don't know.  Thank you in advance.  

 

Submission NumberSubmission TimePeriod SelectedEmployee IDNamePositionJob 1Selected Job 1Job 2Selected Job 2 
11/9/20022 5:56PM11234JoePDetails(Choice List)Details(Choice List)

 

 

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

October 2024 Newsletter…

October 2024 Community Newsletter…

Community Update Oct 28…

Power Platform Community Update…

Tuesday Tip #4 How to Conntact Support…

Welcome to a brand new series, Tuesday Tips…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 142,733

#2
RandyHayes Profile Picture

RandyHayes 76,308

#3
Pstork1 Profile Picture

Pstork1 63,750

Leaderboard