We are trying to automate the process to get messages from message center into SharePoint list or excel with columns details to be filled automatically like message id, published date, actby date, category, Title and message text.
Is there a way to automate this using flow?
I don't think there is a way to do this right now. It has been submitted as an idea and you can vote for it here:
The only way I can think to get around it is to create a mailbox and edit your preferences to send a weekly digest of the messages to that mailbox. Then you can create a Flow when a message arrives in that mailbox. You would still have to process the message as a digest to get the individual messages out and put them in the list.
I am now able to automate this process, created a scheduled flow which runs on daily basis..retrieves the data from message center and update it in the sharepoint list.