Advanced SharePoint lookup

[JCD-JTP]

Hi,

I have a request, I can't seem to find the best approach on...

I have x number of users in one SharePoint list.

I then have another list with user registrations.

I need to know if every user has at least one registration per day, in the current week.

I can't seem to find the best approach for this, so any help would be appreciated..

[Expiscornovus · Accepted solution]

Hi @JCD-JTP,

For the first part you can probably use a get items on the user list and then use an apply to each to iterate through all individual users to see if their are registrations in the second list. You can use an get items for that again with a filter query.

The challenging bit will be the current week requirement. To clarify, is that the next 7 days based on today's date or is that the current week starting on Monday? The first option will be a bit easier.

[JCD-JTP]

Hi @Expiscornovus 

I managed to get it working using the suggestens you provided...

The flow is running at a specific time, so I can calculate the correct days.