Adding a metadata column? (Date data was received)

[agd50]

How would you add a column of metadata that includes the date that the data was received (as at)?

[agd50]

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)

[christinepayton · Accepted solution]

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). 

[v-xinruzhu-msft]

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.

[christinepayton]

It sounds like you're using the SP folder connector? The easiest way is to just use the created date on the file. The folder connector is pulling files at the site level, so it doesn't have easy access to the custom columns on a specific library. You could potentially pull in file metadata with the OData connector and join it with your file data on filename/location, though, and expand out the custom fields that way. Kind of roundabout.

[v-xinruzhu-msft]

Hi @agd50 

Is the metadata you referring to the date that your data source is automatically generated, is your data source similar to a SharePoint list, and can you provide some example pictures that would give you a better solution?

Best Regards!

Yolo Zhu