How long have you spent trying to figure out how to use the format Date in a script or in any other configuration
Let’s take a look with this solution on how to trigger a flow when a feed item is published (RSS) and add a row into a table and see how we can gain time with format data by examples
Select + New Flow > Automated cloud flow
Add a name to your flow > Select the trigger When a feed item is published RSS
Select an RSS feed URL https://powerusers.microsoft.com/jgvjg48436/rss/board?board.id=BuildingFlows
Choose a property that will be used for trigger state > PublishDate
Select + New Step > Select the Action Add a row into a table (Excel Online Business)
Select Location > OneDrive for Business
Select Document Library > OneDrive
Select a file from your OneDrive location
Select the table that you have previously created (Learn how to create a table in Excel)
Select Publication Date > Select Expression > Select Format data by examples
Select Feed published on > Provide an Example
Select an Example value and a Desired output
Select Get expression
Select Apply
Select Title > Select Feed Title from the dynamic content list
Select Links > Select Primary feed link from the dynamic content list
Select Save > Test flow
Congratulations your flow is ready
Now, let’s see the column Publication Date on the Excel spreadsheet
