Power Platform Community Forum Thread Details

Hi, how do I confirm if an entry exist based on two parameters in a SharePoint list.

I have used Power Automate to achieve an output to compare with the list; direct reports to find staff and compose

utcNow('MM-dd-yyyy') to obtain todays date.

I now need to use the output to see if staff has created an entry for todays date. There is a column in the SharePoint list called day and then there is the created by column.

How do I compare the output with the SharePoint list to see if a member of staff has created an entry for todays date?

Thanks in advance.

Categories:

Building flows

I believe that you could do this purely via the Get items filter box (ODATA), @TheTurnip., but it's not the most efficient way.

Take a look at @tom_riha's cheat sheet, here.

If your column names are unchanged, then you'd use this in the filter, obviously putting a proper reference where DATE_VARIABLE and EMAIL_VARIABLE are:

day eq 'DATE_VARIABLE' and Author/EMail eq 'EMAIL_VARIABLE'

It's inefficient as it would have to run in a loop based on your list of users, but you could easily count the amount of entries each user had using this in each loop run.

Alternatively, remove the Auther/EMail part, and just perform more conventional filter/select combos.

You could probably construct a more complex filter condition that returns counts, but I've not got that mastered quite yet.

---

Oh, and also, if you're seeing problems, try modifying your variable's date format to yyyy-MM-dd as that is more inline with standards, I think.

---

As ever, we'll all be able to assist you a lot more easily with: