
Announcements
Hi,
I set up a Lookup field and it works perfectly in a Form :
But when I open the grid with the Excel online
I can't choose any of my option :
Can someone help me with that ?
Thanks
You only get to select a value if it is a boolean or a choices field.
For Lookups you have to manually provided either the (Primary) Name value or the internal GUID (mappings can be changed if there is another unique field on the Lookup table).
Also, if using Name it will only successfully import if the Name is unique in the table being looked up, other wise it will find multiple matches and fail to import that record as it does not know which one should be populated in the Lookup.