Hiding a gallary item based on sharepoint list data

[surfer1978]

Hi

I have a gallery with events pulled from an Outlook calendar and users can register their interest in each gallery item.

Once a user clicks register interest a patch sends the data to a SharePoint list

All good at this point , what I would like to do is if the user closes the form, then reopens the form, Powerapps knows that the user has already submitted their interest in the gallery item so it is set to visible = false, or the button is replaced with text.

I don't know where to start so any help, even it is tips - would be great

Thanks!

[Anonymous]

I would recommend crating a SP List for events that a user has signed up for. You would need a column for the user, a column for the event ID, etc.

Then, you can use Lookup() to see if the user has registered for that event (i.e. if there is an entry where user = User().Email and EventID = ThisItem.EventID). If so, you can make it invisible.

[cwebb365 · Accepted solution]

Ok, So just utilize a filter with a lookup like this.
Filter('OutlookData',EventTitle <> LookUp('My Events new',EventTitle = 'OutlookData'[@EventTitle]).Eventtitle && 'Created By'.Email = User().Email )

It's basically saying, give me the records where you <> (do not) have a Lookup Match. The filter filters current record EventName and where you are the creator.

There are delegation issues here, so you may need to take both the Outlook data into a local collection if you don't already, and also do a clearcollect to collect your signed up events into a collection, then compare off those collections. Long term, if you get over 500(2000 with setting) events signed up for, you'll have to toss in some date filtering tricks to stay under delegation but hopefully by then they make date comparisons delegable!

[cwebb365]

Also need to consider if your eventnames are unique or not. You may need to somehow concatenate the start dates to them or something to make them unique with the names, but if you have an ID in the eventname or something this wont' be an issue.

[v-xida-msft]

Hi @surfer1978 ,

Based on the needs that you mentioned, I have made a test on my side, please take a try with the following workaround:

Set the DisplayMode property of the "Regiser Interest" button to following (disable the "Regiser Interest" button):

If(
   !IsBlank(
             LookUp('My Events new', 'Created By'.Email = User().Email && EventTitle = ThisItem.Subject)
   ),
   DisplayMode.Disabled,
   DisplayMode.Edit
)

or you could also consider apply a Filter formula to the Items formula of your Gallery:

Set the Items property of the Gallery to following:

Filter(
        Office365Outlook.CalendarGetItems("Calendar").value,   // replace your Gallery Items formula here
        Not(Subject in Filter('My Events new', 'Created By'.Email = User().Email).EventTitle)
)

Please consider take a try with above solution, check if the issue is solved.

Best regards, 

[surfer1978]

Thanks everyone for the solutions you provided. They have helped me a great deal in moving forward with this project.

Kind regards