some employees are not an AD users - best practices

[ElMeSaFeR]

Hello,

I need to create a form for vacation request for a company has more than 2000 employees and NOT all of them are registered on the Active Directory  -no login name, no mail address -, and to resolve this case I add a special ComboBox connecting with SharePoint column name "Request on behalf of ".

some columns like on behalf of is a person or group column type on SharePoint list, also in parallel there's another fields connecting with HR database to retrieve some information about the form Author like file number and joining date and some other information.

my question now is what's the best practice when a "non register employee " want to request a vacation, yes the vice person of his department will create the request on behalf of him but how to design this on the PowerApps.

what's the best practice for "on behalf of " DataCard configuration
what's the best practice for the view list to allow the vice person of the department to check the requests history

Thanks

[v-xida-msft · Accepted solution]

Hi @ElMeSaFeR,

Could you please share a bit more about your scenario?

Could you please show more details about the SP list on your side?

Further, do you want the other people (e.g. the vice person) of this department to create a vacation request for the people who are not registered on AD?

I suppose that the " Request on behalf of " column (Person or Group type column) is used to store the people are not registered on AD, is it true?

If you want to create a vacation request for the people who are not registered on AD, you should not create a Person or Group type column to store the people's info (Who are not registered on AD) within your SP list.

You should add a Single line of text type column (called "Request on behalf of") to store the Name or Employee ID (I think it is better) of the people (Who are not registered on AD). Then based on the Employee ID, retrieve people's profile from the HR database.

After you created your SP list, you could consider take a try to generate an app form the SP list on your side. It would generate three Screens (Browser Screen, Detail Screen, Edit Screen) automatically within your app. 

More details about generaing an app from SP list, please check the following article:

Generate an app from SP list

Best regards,

Kris

[ElMeSaFeR]

@v-xida-msft

I agree with you about converting the column type 

I think also to make the primary search by employee ID because it's already connected with the employee information database 

so the requester has to write the employee ID them make a query to show the employee name in the "on behalf of" Datacard 

any other suggestions?

[v-xida-msft]

Hi @ElMeSaFeR,

I think your thought is correct. 

Please take a try with the solution that I provided, then check if the issue is solved on your side.

If you have solved your problem, please go ahead and click “Accept as Solution” so that this thread will be marked for other users to easily identify.

Best regards,

Kris