Power Platform Community Forum Thread Details

Hi I have dataverse table EmployeeDetails with 7 Columns Name,Email,Designation, Department, JoiningDate, YearOfPromotion,Location and i have listed records of EmployeeDetails table in a power app gallery gallery 7,

So I have another dataverse table called Nominations with 9 Columns Name,Email ,Designation, Department, JoiningDate, YearOfPromotion,Location , Nomination Status and Nominated by .

On click of button Nominate i want to save all records of Employee Details table from gallery7 into Nominations with Nomination status column value "Yes" and Nominated by column value with user().email

i wrote patch function but i don't know how to update 2 additional columns Nomination Status and Nominated by in Nomination table as these columns are not present in EmployeeDetails table

i wrote below formula on Onselect of nominate button it shows error .

ForAll(
Gallery7.AllItems,
Patch(
Nominations,
Defaults(Nominations),
{
Name: ThisRecord.Name,
Email: ThisRecord.'Email Address',
Designation: ThisRecord.Designation,
Department: ThisRecord.Department,
Joiningdate: ThisRecord.'Joining Date',
Location: ThisRecord.Location,
PreviousYoP: ThisRecord.'Previous year of Promotion',
'Nomination Status' : "Yes"

'Nominated By' : User().DisplayName
}
)
);

How do I achieve this can where if I click on button I should be able to save all records of EmployeeDetails into Nominations Table with Nomination Status column value to be updated as "Yes" for all records and NominatedBy column value with logged in username

Categories:

Building Power Apps