Can I get the value of the Site URL (datasource)?

[KukoyLP]

Right now, my data source is

Site URL: company.com/sites/locations/Toronto/

Is it possible to get this value and put it in a column, along with the data I get from the sharepoint site?

So for example, the table I import for the site is like this

First name || Last name || Location

John          || Doe           || company.com/sites/locations/Toronto (or better yet, just the value Toronto)

Jane          || Doe           || Toronto

[v-yulgu-msft]

Hi @KukoyLP,

Per my knowledge, it might not available to fetch the location information from source URL to load it as datain dataset. Only if the URL or location information can be stored in source table which is hosted on sharepoint site.

Regards,

Yuliana Gu