How to remove a Table from a Lookup field

(1) Share

Report

Posted on by RM-30040732-0

Hello,

Can someone help me how I change what tables a look up field can look up? I have a field which looks up Accounts, Contacts and Users but I want to remove Users from the list.

All responses (4)

Answers (1)

Verified answer

Dengliang Li Microsoft Employee on at

Like (0)

Report

How to remove a Table from a Lookup field

Hi,

Has the issue been solved?
Have there been any updates? Please feel free to ask me if you have any questions!
If it has been resolved, can you mark the response as an answer?
Dengliang Li Microsoft Employee on at

Like (0)

Report

How to remove a Table from a Lookup field

Hi,

The code is below:

function addFilter(executionContext) {

var formContext = executionContext.getFormContext();

formContext.getControl("from").setEntityTypes(["queue"]);

}

Register the code to the onload event of the Enhanced Form of the mail entity.

Upload the JS file and name it

If my answer was helpful, please click Like, and if it solved your problem, please mark it as verified to help other community members find more.
If you have further questions, please feel free to contact me .

Best Regards,
Dengliang Li
RM-30040732-0 34 on at

Like (0)

Report

How to remove a Table from a Lookup field

Thanks! This is exactly what I want!

Can you talk me through in more detail how to enter that code? I am unfamiliar with api and the link doesn't tell me how to add it to my app.

Thanks!
Suggested answer

Dengliang Li Microsoft Employee on at

Like (0)

Report

How to remove a Table from a Lookup field

Hi,

This can be implemented using the following API.

setEntityTypes (Client API reference) in model-driven apps - Power Apps | Microsoft Learn

In my testing, this API was used to filter the From field of the email entity to show only the queue entity type.

If my answer was helpful, please click Like, and if it solved your problem, please mark it as verified to help other community members find more.
If you have further questions, please feel free to contact me .

Best Regards,
Dengliang Li