Filter where created date equals modified date of an item

(0) Share

Report

Posted on by H_a_l

Looking for assistance finding a filter:

Filter( Library, Created = Modified)

Only show item where the time stamp is identical.

Categories:

Building Power Apps

All responses (4)

Answers (1)

Sort by

Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @H_a_l

Are you using SharePoint List?

If yes then whenever the record is created the Created filed is populated with time now. Modified is empty.

So you will never find any record where Created = Modified.

What is the reason you are trying to find records that have Created = Modified?
H_a_l 4 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Anonymous

Yes we are using a sharepoint list.(Library in this case)
Interesting I have always observed the modified to reflect the created time stamp in sharepoint lists for net new items.

Here is a screen shot of an item in the list.

The gallery filter is intended to show content in the list at different stage in the itesm lifecycle.

Various Filter Views
1. New Items
2. Edited beyond v0.1
3. Major versions and Approved.

Neither Version nor Approval Status are presented columns in the data source list.
Verified answer

v-yamao-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi H_a_l,

It seems that I am getting the same issue when using the similar function with you.

Though without using the function Filter( Library, Created=Modified), I can get both the timestamp for Created and Modified.

While when using the function, it returns an error saying that “value doesn't fall within expected ranges”.

Then I use the following function, and it works for me:
Filter('Test library1',If(!IsBlank(Modified),Created=Modified))

Please have a try with it.

Best regards,
Mabel Mao
PytByt 943 on at

Like
a
(0)

Report
Copy link

Link copied!

hi @v-yamao-msft

i need to sum up my item is my sp list with modified date is more than 7 days (a week long).
what formula should i use, and how?

for now, i use this formula but no luck when i customize it:
Sum('Candidate List', Modified > Created)

please help.

thanks,
pytbyt