Hi Community, Recently I created an MS Form for my organisation to fill in and like every MS Form the results are sent to an Excel file. What I Am trying to accomplish is when a new entry comes into the Responses Excel sheet I need to extract it and add it a new output so essentially everyday I need to extract all new entries if there is any Here's an sample of three dummy entries I used as when testing my form: IDStart timeCompletion timeEmailNameNew or ExistingCompany NameIs This a Group 13/7/23 15:25:583/7/23 15:28:39JohnDoe@Gmail.comJohn DoeNew ClientABC LimitedNo23/8/23 15:28:413/8/23 15:30:20JaneDoe@Gmail.comJane DoeNew ClientTest IncNo33/8/23 15:30:223/8/23 15:31:24JoeBloggs@Gmail.comJoe BloggsExisting ClientJJJ LtdYes For example today I would need to extract the last 2 records. I know this might be a big ask but I appreciate any guidance or support that is offered for this matter.

Extracting New entries from an Excel file

Hi Community,

Recently I created an MS Form for my organisation to fill in and like every MS Form the results are sent to an Excel file.

What I Am trying to accomplish is when a new entry comes into the Responses Excel sheet I need to extract it and add it a new output so essentially everyday I need to extract all new entries if there is any

Here's an sample of three dummy entries I used as when testing my form:

ID	Start time	Completion time	Email	Name	New or Existing	Company Name	Is This a Group
1	3/7/23 15:25:58	3/7/23 15:28:39	JohnDoe@Gmail.com	John Doe	New Client	ABC Limited	No
2	3/8/23 15:28:41	3/8/23 15:30:20	JaneDoe@Gmail.com	Jane Doe	New Client	Test Inc	No
3	3/8/23 15:30:22	3/8/23 15:31:24	JoeBloggs@Gmail.com	Joe Bloggs	Existing Client	JJJ Ltd	Yes

For example today I would need to extract the last 2 records.

I know this might be a big ask but I appreciate any guidance or support that is offered for this matter.

Workflow

Help

Accepted answers

binu_acs

@Deano478you can filter out the new records with the below formula

DateTimeParse(]Start Date],’%m/%d/%y’) = DateTimeToday()

All comments

binu_acs

@Deano478you can filter out the new records with the below formula

DateTimeParse(]Start Date],’%m/%d/%y’) = DateTimeToday()

Deano478

hey @binu_acs I tried the formula but I ran into this error I'm not to sure about:

Deano478

Never mind it worked it was silly mistake on my end

Deano478

Hry again @binu_acs and @FrederikE I put the formula into a filter tool as a custom filter however its telling me that there is no new records even though I have 4 for today sorry about this. here is the SS:

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703