Hi
I am trying to write my collection (colPEG_Members) to my dataverse table (PEG_Data).
ForAll(colPEG_Members, Filter(PEG_Data, Member_Email = colPEG_Members.cMember_Email), {Member_Stat: cMember_Stat, Record_Status: cRecord_Status})
All the fields in my dataverse table are Optional. Member_Email is not my Primary Name column. Every record in my collection and table have a Member_Email value. The error is "Name isn't valid. 'Member_Email' isn't recognized. I get the same error when I try with Member field as well. I get the same error if I try UpdateIf function instead of Filter
Marty