Unanswered

Calendar filter through query string

(0) Share

Report

Posted on by jeffgreenrc

Hi,

I am showing calendar on web page using entity list. Currently all records are shown and i want to filter those records based on query string passed in url.

For e.g i am passing course id as guid in url. Now i want to include this course id guid on entity list filter so that only specific course schedule is shown.

Thanks

Categories:

Power Apps portals

I have the same question (0)

All responses (9)

Answers (0)

jeffgreenrc 66 on at

Like (0)

Report

Anyone please?

Any suggestion or pointers will be useful.

Thank you

Was this reply helpful? Yes No
oliver.rodrigues 9,368 Most Valuable Professional on at

Like (0)

Report

Hi, I wrote an article on how to inject values to entity list metadata filter: http://oliverrodrigues365.com/2021/03/02/power-apps-portals-loading-large-data-in-entity-lists/

I haven't tried with Calendar entity list but it should work

Was this reply helpful? Yes No
jeffgreenrc 66 on at

Like (0)

Report

I had already implemented it and it was not working. Can you please confirm at your end too?

Was this reply helpful? Yes No
oliver.rodrigues 9,368 Most Valuable Professional on at

Like (0)

Report

sorry I got confused, did you implement the same technique from my article and it was working originally, but now it isn't.. is that the case?

what is happening? is it not adding the value to your filter?

Was this reply helpful? Yes No
jeffgreenrc 66 on at

Like (0)

Report

Its not working at all. It didnt filter for me what i wanted.

Was this reply helpful? Yes No
jeffgreenrc 66 on at

Like (0)

Report

Also just fyi, i want to filter lookup field and i am passing this lookup field value as guid in URL

Was this reply helpful? Yes No
oliver.rodrigues 9,368 Most Valuable Professional on at

Like (0)

Report

Works for me with a Dynamic Lookup filter as well, in the URL, I am passing the GUID in curly brackets,

can you try that? if it still doesn't work, can you share some snapshots of your Entity List metadata filter + URL that you are passing?

Was this reply helpful? Yes No
jeffgreenrc 66 on at

Like (0)

Report

Thank you for looking into this and giving me e.g.

Can you please try this on calendar view?

Was this reply helpful? Yes No
oliver.rodrigues 9,368 Most Valuable Professional on at

Like (0)

Report

Hi Jeff, I've been playing around here, and it seems the Calendar works quite different than a regular entity list.

The main problem I guess is not that it's not filtering by the query string, the problem is that it doesn't even have any metadata filter option for calendar view. I was playing around with Liquid, but unfortunately it also doesn't work with Liquid entitylist object, only legacy rewrite Page Templates, quite annoying.

I found this article from Colin Vermander that has a custom implementation rendering a Calendar view: Dynamics 365 portals: Implement FullCalendar with Liquid – Colin Vermander (wordpress.com)

This might help, but it would be a lot of work

You can also apply JS and remove elements that are not from that GUID from the query string, also might be a bit of work, but doable

Was this reply helpful? Yes No