Gallery Filtered by Dropdown and by Values not in DataTable | Hyperlink in Gallery

[CEChandler]

Hey folks!

So, I was able to successfully build a dashboard for my team, which went over very well, but now they would like two ponies:

1. Additional filter functionality, wherein the gallery that is supplying the options for the entry form to filter out items that have already been entered, which are displayed in a separate DataTable on the dashboard.

2. A hyperlink associated with an individual gallery item, to go a resource.

So, I have both items sort of working, but they are not working in the way I need them to work. Let's go with the easiest one first.

With the hyperlink in the gallery - I have a label that shows the hyperlink, you click the gallery item, it goes to the linked site, so no problem there.

I want it so that the link does open, but you stay in the app. Right now when you click on a gallery item, you go to the link, and then have to click back to go to the app, which does have the correct gallery item now selected, but data entry is interrupted.

Is there a way to allow the link to launch, but the user stay in the app, essentially popping open a tab with the hyperlinked content, but you aren't interrupted in data entry. I hope this makes sense. Currently, the action is:

Launch(ThisItem.Reference);

If I click anywhere in the gallery card, it activates the hyperlink.

Now, to the filter:

I have a filter that works, which only shows items associated with a particular week, based on a dropdown value. I've added another filter, and I know it's wrong. It is filtering out whatever I might select in the datatable. I want all the datatable entries to be filtered from the gallery, not just the first entry, or whatever I click.

This is the current filter (which also has a function to create banded rows in the table, but that works fine):

With({records: Filter('Weekly Onboarding Tasks','Task Week'=Dropdown2.Selected.Title,!(Title in DataTable1.Selected.Objective)

)},

ForAll(Sequence(CountRows(records)), Patch(Last(FirstN(records, Value)),{rowNumber:Value}))
)

(bold is my addition)

I understand that DataTable1.Selected.Objective in the filter means that the filter is depending on me making a selection, but I do not understand how to have the Title (which is the "Objective" in the SharePoint List of all the types of tasks) be filtered by only showing those that aren't anywhere on the datatable, which itself is filtered by the same dropdown2.

So, I need the gallery to be filtered by week (via the dropdown), and to only display entries that aren't currently in the datatable.
 

Thank you for your time and energy with this. I appreciate it!

-Chris

[cavitha]

You can use the launch to open it in a new tab - https://learn.microsoft.com/en-us/power-platform/power-fx/reference/function-param#target

It is difficult to understand your second point, maybe if you can explain with screenshots it would be easier

[CEChandler]

@cavitha , thank you for the initial response. I appreciate your help!

I've attached a screenshot of the dashboard. The left-hand gallery provides entry options for the central data-entry form. A user clicks on a gallery item to prefill some form fields, then fills out the form, then clicks submit, and this works just fine. Additionally, there is a data table below the data entry form that displays the completed entry options.

My team member wants individual Gallery items on the left to no longer display after the user has completed them. For example, after the user completes the "Microsoft Teams" task in the data entry form and clicks Submit Task, the data table would update with the new "Microsoft Teams" entry, and the left-hand gallery would filter out the "Microsoft Teams" option.  Does that make sense?

As far as the hyperlink issue is concerned, the link works in opening up into a new tab, but it navigates the user away from the app and to the hyperlinked tab. My team member wants the link to open without leaving the app, that is, the user clicks the link, and it opens, but the user isn't automatically navigated away from the app and onto the new tab. It's similar to when you right-click a link in Chrome and select "Open link in new tab".

The "LaunchTarget.New" parameter simply makes sure the url is opening in a new tab, but the user is still navigated to that tab, instead of staying put.

[CEChandler]

@cavitha and any others with insight -

To clarify, I can get the gallery to filter, excluding an individual gallery item that is on the datatable. I need to exclude all the gallery items that are on the datatable. How can I do this? I've been researching more, and I've still come up short.

[CEChandler · Accepted solution]

So, I was able to work through a solution after researching for quite some time. I do not understand why I was not able to create an exclusionary filter from the datatable (i.e. filter(datasource,!(item in datatablecolumn) or similar), and so had to filter from the SharePoint list directly. Here is the final code:

With({records: Filter('Weekly Onboarding Tasks','Task Week'=Dropdown2.Selected.Title,Not(Title in Filter('Onboarding Tasks','Team Member'.Value=User().FullName).Objective)

)},

ForAll(Sequence(CountRows(records)), Patch(Last(FirstN(records, Value)),{rowNumber:Value}))
)

 Wherein it filters by week (via Dropdown2), then additionally filters out all existing Objectives for the current user (based on the Onboarding Tasks SharePoint List), so that the gallery only displays the user's remaining Objectives that need to be completed for the selected week.