Hello all,
i can't find the way how to collect() an ne item to a sharepoint list with a refenced collumn to another sharpoint list.
let me explain what i need:
We have a list for planing internal educations in our company. So the fist List called (Schulungsübersicht) has all the informations except the employees who can book the education by itselve. The second List called "Teilnehmer" has a reference field to the "Schulungsübersicht" Title, wich is the Name of the Education.
i've created a Powerapp to search and select an education. on the Detailscreen there are all the informations. so there should be one button "book education" to add an item to the "Teilnehmer" List with the Title Information from the selected education an add the name of the current User to the List.
So my code looks like this but it doesn't work:
Collect(
Teilnehmer;
{
Schulung: {
'@odata.type': "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference";
ID: LookUp(
Schulungsübersicht;
Titel = DataCardValue12.Text;
ID
);
Value: DataCardValue12.Text
}
};
{
Teilnehmer: {
'@odata.type': "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser";
Claims: "i:0#.f|membership|" & Lower(User().Email);
Department: "";
DisplayName: User().FullName;
Email: User().Email;
JobTitle: ".";
Picture: "."
}
}
)the reference Field in "Teilnehmer" is Schulung and it references to the Titel field in "Schulungsübersicht".
any idea?
kind regards Alex
