Filter the Power apps data card value in 1 SharePoint list and save the data in another SharePoint list.

Hello Experts!
I Have 2 Share Point List.
1) Task List - (Manager name, Project Name, Task Title, Description, Assigned To)
2) Employee List - (Employee name, Time Taken, Project Name and Task Title)
I taken the Project name and Task Title as Look up Column in Task List)

I created Power app edit form source data is Employee List.

Property	Project Name Data card	Task Title Data card
Items	Choices([@'Employee List'].Project Name)	Filter('Task List', User().Email in AssignedTo.Email && ProjectName.Value = DataCardValue1.Selected.Value)
Update	DataCardValue1.Selected	DataCardValue2.Selected

When user selects a project name in power apps , the Task Title data card will filter the assigned tasks based on the login user with respective project name.

The Filtering Part is working fine, the Task Title data card doesn't store in Employee List SharePoint Site.
I filter the Task Title records based on Task List Share point site.
When power app submit the button the 'Task Title' data will store in Employee List.
How to resolve this.

Thanks in Advance,
Pooja-B

Categories:

General Questions