Forum Discussion

Bharathi0909's avatar
Bharathi0909
Regular Visitor
4 months ago
Solved

ServiceNow data through Power Automate

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 

Interesting Links
Need Help
Tips and Tricks
Tutorial Requests
  • v-nmadadi-msft's avatar
    v-nmadadi-msft
    4 months ago

    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

5 Replies

  • Kedar_Pande's avatar
    Kedar_Pande
    Super User
    4 months ago

    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's avatar
      Bharathi0909
      Regular Visitor
      4 months ago

      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's avatar
        v-nmadadi-msft
        Community Support
        4 months ago

        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

  • v-nmadadi-msft's avatar
    v-nmadadi-msft
    Community Support
    4 months ago

    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.

  • v-nmadadi-msft's avatar
    v-nmadadi-msft
    Community Support
    4 months ago

    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