web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Pages / How to use different v...
Power Pages
Unanswered

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

(0) ShareShare
ReportReport
Posted on by 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?

 

 
Please help me with this.

 

 

Categories:
I have the same question (0)
  • oliver.rodrigues Profile Picture
    9,368 Most Valuable Professional on at

    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/

  • MarkBiggerstaf Profile Picture
    Microsoft Employee on at

    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

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Pages

#1
Fubar Profile Picture

Fubar 58 Super User 2025 Season 2

#2
Jerald Felix Profile Picture

Jerald Felix 27

#3
Lucas001 Profile Picture

Lucas001 25 Super User 2025 Season 2

Last 30 days Overall leaderboard