ServiceNow data through Power Automate

[Bharathi0909]

Hi People,

I'm trying to get ServiceNow data into power bi, but we cannot purchase service now license also the data is not stored in any databases. 

User usually sends excel file from service now to Outlook on daily or weekly basis. But we want that data in SharePoint and build PBI report on top of it

Can we do it through Power Automate, if yes I need steps for that.

If anyone could help on this scenario please do.

Thanks,

Sai 

[v-nmadadi-msft]

Hi @Bharathi0909 

May I check if this issue has been resolved? If not, Please feel free to contact us if you have any further questions.

Thank you

[v-nmadadi-msft]

Hi @Bharathi0909 

I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions.

Thank you.

[Kedar_Pande]

@Bharathi0909 

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

[Bharathi0909]

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?

[v-nmadadi-msft · Accepted solution]

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