dynamic data source - schedule refresh issue for odata feed

Hi All,

I have changed my approach, instead of using dynamic parameter for title, I am able to filter selected title and expand FieldValueAsText and select required columns.

Step 1 -

Source = Odata.Feed(" https://sharepoint.com/sites/department1/_api/web/lists?")

Step 2 - Remove other columns

Step 3- Filter selected libraries

Step 4 - Expand Items - FieldValuesAsText

Step 5- Selected required columns

Looping is not required with each title as parameter.

This approach or workaround works for me and I am able to successfully reduce the schedule refresh time significantly with odata compared to other sharepoint connectors.

Thanks,

Pallavi