Lookup for two columns in data verse table
Dears I created a table named "onboarding employee" I made a column name "Sector name " and the type is choices, which are (Production sector, Support sector, ...) I created another table named "All Jobs", this table has two columns "Sector name" and "Job title" and each sector has some job titles like the below photo I created a new field in the "onboarding employee table " named "Job title " My request is when I select a sector from the "sector name field" like the production sector and then when I press on "the Job title field", it shows me only the jobs related to the production sector what can I make this? Thanks in advance
Use dataverse as a source for lookop in Sharepoint Online list
I have a few Sharepoint sites running. They all have listst that need employee info (lookup field). So now I have for every Sharepoint site a seperate list of employees. Every update has to be done over all the seperate employee listst. I recently synchronised the employee data from our SQL server ERP system to Dataverse. So I have one online source (table) where all employee data is stored. Can this be used in lookup fields in Sharepoint Online lists? This way I always have one source of data which is automatically updated. Tried to google it but I only find results explaining the other way around, fromSharepoint to Dataverse. Thanks in advance!
