cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
JSnapp
Frequent Visitor

Patch row based on column

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. 

2 REPLIES 2
RandyHayes
Super User
Super User

@JSnapp 

The question comes more from this...

If a course is selected and an employee selected, but yet there is no record in the list for the employee...what then?  Create the record?

 

If so, then your Patch formula would be:

Patch(yourList,
    {ID: LookUp(yourList, course=yourCourseDropdown.Selected.Value && Employee = employeeDropdown.Selected.Value, ID),
     Course: yourCourseSelection
    }
)

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.

Helpful resources

Announcements
Power Apps News & Annoucements carousel

Power Apps News & Announcements

Keep up to date with current events and community announcements in the Power Apps community.

Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Power Apps Community Blog Carousel

Power Apps Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Top Kudoed Authors
Users online (2,841)