Forum Discussion
ServiceNow data through Power Automate
Hi Bharathi0909 ,
Whenever new data is received via Outlook, you can capture the attachment and append its contents to an existing file (or list) stored in SharePoint. This ensures that your data is continuously updated in a single centralized location. Once the data is appended, you can simply refresh your Power BI dataset to reflect the latest updates in your reports.I hope this information helps. Please do let us know if you have any further queries.
Thank you
Trigger: Recurrence (daily/weekly)
ServiceNow → List records (table name, query filter)
Create CSV table → From dynamic content
Create file → SharePoint library, name ServiceNow_[utcNow('yyyyMMdd')].csv
Power BI → SharePoint Folder connector → auto-refresh
Hi Kedar_Pande
The data from Servicenow comes to Outlook daily, that I need to keep in harepoint and if new data comes next data I need to append the rows from New file into existing file in sharepoint and use that file as data source in PBI
How to do?Hi Bharathi0909 ,
Whenever new data is received via Outlook, you can capture the attachment and append its contents to an existing file (or list) stored in SharePoint. This ensures that your data is continuously updated in a single centralized location. Once the data is appended, you can simply refresh your Power BI dataset to reflect the latest updates in your reports.I hope this information helps. Please do let us know if you have any further queries.
Thank you
