Forum Discussion
Adding a metadata column? (Date data was received)
Ohh, okay, there should be a bunch of videos out there on YouTube on how to get attachments from an email and send to a SP document library in Power Automate. If I recall, it uses the "create file" action. After you create the file(s), you use "update file properties" to add metadata from the original email to the library columns for the files you created (you'd add a custom date column called "date received" or similar).
For context, I'm using outlook for data and when a new data gets emailed I use that. Opening attachment will remove the metadata (such as date/time received)
Hi agd50
Maybe you can consider to move the data to sharepoint list, the sharepoint list can display the metadata, you can display the created time to the list, then when you use power bi to connect the Sharepoint list, it can connect the metadata(such as created date), you can refer to the following link.
Show or hide columns in a list or library - Microsoft Support
Create a report on a SharePoint List in Power BI Desktop - Power BI | Microsoft Learn
Best Regards!
Yolo Zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Ohh, okay, there should be a bunch of videos out there on YouTube on how to get attachments from an email and send to a SP document library in Power Automate. If I recall, it uses the "create file" action. After you create the file(s), you use "update file properties" to add metadata from the original email to the library columns for the files you created (you'd add a custom date column called "date received" or similar).