Beginners question. I have a database with team member name as one column and then individual columns for each training class offered. I need to patch the table to show the course has been completed. I have a dropdown that allows for the manager to select the course taken and the employee but I'm not sure how to write the patch function to only patch the records based on what was selected in the dropdowns. I have attached a screenshot of the table to clarify as best I can.
There are several "unknowns" from your post, so the above is a general concept - not verbatim.
I hope this is helpful for you.
_____________________________________________________________________________________ Digging it? - Click on the Thumbs Up below. Solved your problem? - Click on Accept as Solution below. Others seeking the same answers will be happy you did. NOTE: My normal response times will be Mon to Fri from 1 PM to 10 PM UTC (and lots of other times too!) Check out my PowerApps Videos too! And, follow me on Twitter @RandyHayes Really want to show your appreciation? Buy Me A Cup Of Coffee!
The issue with this it seems, is that I would need to redo how the database is structured. As the columns are just the course which they may have completed. I need a way to look at the first column ( team member name ) based on the Team member selected in the dropdown. Then After it finds that member, search through the remaining column names for the course specified by the course_selected dropdown, and patch that record with an O.