I'm wondering if anyone has tried to create a flow which leverages the ServiceNow connector (ServiceNow - Connectors | Microsoft Learn) for Power Automate? My main concerns are:
- Do you need to set anything up in ServiceNow? If so, does it cost anything in terms of licensing?
- Has any experienced performance issues? Such as, pulling to many rows causing their ServiceNow instance to slow down.
- Is query building rather straightforward, or are there any best practices/tips that we should be aware of?
- Is there a way to limit access so that we can only list records, but not post or take any other action? I want to limit anyone being able to create things in ServiceNow, but still be able to pull data.
- What type of database is ideal for this type of flow?
We're currently only starting to explore this option, therefore any sort of advice would be appreciated. I have very minimal experience in Power Automate, so far creating flows to pull data via scheduled reports, so working just with XLXS files. However, it would be nice to pull live data into a database, then use that data to create a Power BI dashboard from it.