Unanswered

INSERT Records INTO SharePoint List based on the matching records

(0) Share

Report

Posted on by davealejo

Hello,

I’d like to INSERT records into a SharePoint Attendance Details List* (Please refer to the SharePoint list in the attachment). I had a command button in the Attendance Session List and ON SELECT property, I want to pull out the Student IDs from the Registration List with a MATCHING Group ID in the Attendance Session List and INSERT them INTO the Attendance Details List after the cmd Button is clicked The goal is for the Teacher will avoid re-entering, again and again, the Student's ID whenever generating the class attendance. Kindly help me how to achieve the above. Thank you so much!

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (0)

Sort by

Drrickryp Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

@davealejo

If you have a dropdown control for selecting the student name from the registration list, you can reference it with Dropdown.Selected.ID

Was this reply helpful? Yes No
davealejo 23 on at

Like (0)

Report
Copy link

Link copied!
Hi @Drrickryp thank you for your response. But what I'd like to have is those students enrolled in class will populate my Attendance Details list once the teacher create an Attendance instance. It's like having a trigger attached to cmd button that will run like Insert sql cmd to pull students from Registration list that have matching Group ID. The teacher doesn't like re-entering his students in the Attendance Details whenever they create an Attendance. I hope this is clear to you.

Was this reply helpful? Yes No