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 Number | Submission Time | Period Selected | Employee ID | Name | Position | Job 1 | Selected Job 1 | Job 2 | Selected Job 2 | |
1 | 1/9/20022 5:56PM | 1 | 1234 | Joe | P | Details | (Choice List) | Details | (Choice List) |
|