Power Platform Community Forum Thread Details

Hello,

I'm completely new to Powerapps, but I'm trying to figure out how to solve the following task:
I have a MS SQL on-prem database with the following tables:
1. List of accounts: User_ID and User_FullName
2. List of groups: Group_ID and Group_FullName
3. Assigned groups: and here is the problem

In the power app I added the following fields:
- with user selection from the 'List of accounts' table
- with Group selection (more than 200 groups in the list), more than one group can be assigned to one user.

How can I now record the selected values in table 3 - Assigned groups?

Like: User ID, user name, group ID, group name, source name, record id, Record creation datetime

Example:

MPETERSON, Mike Peterson, 101, Clerk, powerapp, 00001, 31-Mar-2023 09:22

MPETERSON, Mike Peterson, 234, Key User, powerapp, 00002, 31-Mar-2023 09:22

MPETERSON, Mike Peterson, 452, Complaint, powerapp, 00003, 31-Mar-2023 09:22

.....

Categories:

Building Power Apps