cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
RameshKumarE
Helper I
Helper I

Need an idea on, how to generate a Excel report from my outlook Inbox

Hi All,

I need an idea on, how to generate a monthly Excel report from my outlook Inbox for the tickets received,

On Condition If my Email Subject has a string "Book" or "Booked" and has a July month date, then, copy the ticket reference starting with "CRQ" and the start and end date mentioned in the mail subject please? as Most of the tracking cases will be done like when a new email arrives, but I need to generate a report from the emails which I have already received

Any solutions, please?


FW: *Book* CRQ000001144185 - C10/223344 - 15/07/22 19:00GMT - 16/07/22 05:00 GMT for Site closure Project.
FW: **Book** CRQ000001144186 - C10/223345 - 16/07/22 19:00GMT - 17/07/22 05:00 GMT for Site closure Project.
FW: CRQ000001144187 - C10/223346 - 17/07/22 19:00GMT - 18/07/22 05:00 GMT for Site closure Project.
FW: **Booked** CRQ000001144188 - C10/223347 - 18/08/22 19:00GMT - 19/08/22 05:00 GMT for Site closure Project.
FW: CRQ000001144189 - C10/223348 - 19/07/22 19:00GMT - 20/07/22 05:00 GMT for Site closure Project.
FW: *Booked* CRQ000001144190 - C10/223349 - 20/07/22 19:00GMT - 21/07/22 05:00 GMT for Site closure Project.

Expecting output as below,

 

RameshKumarE_0-1657190804806.png

 

 

I really appreciate any help you can provide.

1 ACCEPTED SOLUTION

Accepted Solutions

I mean, ideally you're here after trying something already ... what have you tried?

 

There's a Get emails action you could try by also including CRQ in the Subject filter ...

View solution in original post

6 REPLIES 6
RameshKumarE
Helper I
Helper I

@Pstork1 can you able to help me, please?

RameshKumarE
Helper I
Helper I

@eliotcole can you able to help me, please?

My advice is to not create an excel spreadsheet report, @RameshKumarE 😉

 

Feed this into a SharePoint list, and develop different views for the data so that it's always up to date, that way whenever anyone needs the latest information they can look at either the list view, or a SharePoint page with that information on it.

 

Remember, too, that you can cache that information on a tab in Teams, too. So that someone can literally flip to another tab to get the latest information on a given thing.

@eliotcole thanks for your advice, sure will create it in a SharePoint list.

any advice on how to fetch data from my outlook Inbox for the tickets received, as Most of the tracking cases will be done like when a new email arrives, but I need to generate a report from the emails which I have already received, please.

I mean, ideally you're here after trying something already ... what have you tried?

 

There's a Get emails action you could try by also including CRQ in the Subject filter ...

RameshKumarE
Helper I
Helper I

Sorry for the late reply, Thank you for the Input "Get emails action".

Trying with it now, able to get what I need, but receiving a slightly different output. though I'm getting different outputs, playing now again and again with different inputs to see how outputs vary.

Thanks again.

Helpful resources

Announcements
Power Automate News & Announcements

Power Automate News & Announcements

Keep up to date with current events and community announcements in the Power Automate community.

Community Calls Conversations

Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Top Kudoed Authors
Users online (4,177)