How to use different views for same lookup field in two different tables?

(0) Share

Report

Posted on by praneshJ

121

Hello Experts,

I have a scenario, where I have two tables say 'summer_data' and 'winter_data' and I have a single lookup filed in both the table named as 'week' from table 'Dimweek'.

I also have two entity forms for summer and winter data insertion in 'summer_data' and 'winter_data' respectively.

on those two forms I have lookup field 'Week'

Now, I want to restrict the 'week' lookup field to display only summer weeks i.e. between month May to August on summer form similarly I want to display week lookup field to display winter weeks. i.e. between December to Feb.

what are the best possible ways to achieve this?

Can I use different views from 'Dimweek' table to achieve desired result?

@OliverRodrigues,

@OOlashyn ,

@justinburch

Please help me with this.

Categories:

Power Apps portals

I have the same question (0)

All responses (2)

Answers (0)

oliver.rodrigues 9,368 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hi, we can't achieve that with OOB configuration, you can add JS/jQuery and reload the data.

Please take a look at this article to see how to add JS to a lookup window in the Portals: http://oliverrodrigues365.com/2021/01/24/power-apps-portals-custom-lookup-filter/

Was this reply helpful? Yes No
MarkBiggerstaf Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hello,

I am responding to meet the SLA of this thread. You should be able to populate the lookups using a custom fetch and the criteria you described.

I will allow others to address this technical implementation.
This seems to be a good thread for this question: https://powerusers.microsoft.com/t5/Power-Apps-Portals/Portal-Execute-Dynaics-365-FetchXML-from-entityform/td-p/636807

Thanks,

Mark Biggerstaff
Dynamics Support

Was this reply helpful? Yes No