I have two sharepoint lists: 'session' and 'event'
each session can be assigned an event which is connected to the 'event' list via a lookup column 'edd'
Now i have form that shows the 'edd' column as dropdown, but it should only display events which are not done yet.
this lead me to the following formula:
DataCardValue12.Items: Filter(Choices('session'.edd),Id in Filter(events, status.Value <> "done").ID)
So far so good, but this shows me the result as some raw sharepoint-ids which is kind of difficult to read:
I then tried the following fomula:
DataCardValue12.Items: Filter(Choices('session'.edd),Id in Filter(events, status.Value <> "done").ID).Value
Which then shows the correct values in the dropdown, yay! Unfortunately, it doesn't save the value into the list that way, as it is probably missing the Id.
The strange thing is, that usually you can choose the which fields you want to display with the DisplayFields attribute. In this case it doesn't allow any entries though. It doesn't provide any suggestions and lets me enter anything I want, but as soon as I leave the field it sets it back to ""
Can someone please help me and show me where my error is?