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.

I have the same question (0)

All responses (4)

Answers (1)

Sort by

Suggested answer

Dengliang Li Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
RM-30040732-0 34 on at

Like (0)

Report
Copy link

Link copied!

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!

Was this reply helpful? Yes No
Dengliang Li Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Verified answer

Dengliang Li Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

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?

Was this reply helpful? Yes No