Skip to main content
BOOK A DEMO

Search

Getting data from an Excel?

Joerg_K.
  • Discussion Created

Hello,

is there a way to retrieve data from an Excel file?

We have an automation that is creating an Excel report that contains all SharePoint Online Sites and their Owners and Admins. The report is quite simple:

"Title","Site URL","Owners","Admins","Date Created","Date Last Modified"

At the end we like to offer a way for regular users to let them find out who is an admin of a particular site. With other words we don't want to publish the list itself as it contains sites that are not for the public (within our company). So the user should enter the URL for the site he likes to retrieve the admins for. With this URL I like to retrieve the data "Title","Owners","Admins" from the Excel by looking up the entered URL at the "Site URL" column.

I have already a solution where I use HTTP requests to get the data live from the URL, but that requires that the user needs to have permissions to the SPO site to retrieve the information.

Any idea? Many thanks in advance.

Cheers
Joerg

0

Comments

2 comments

Date Votes
  • Christof

    Hi Joerg

    This case would definitely be easier if you store the information in a SharePoint list instead of an Excel file.
    Then you can use skybow functionalities like Get items action, query list functions or filter on sublists and lookups.
    The list containing the sites can be in another site linked by Data Lookup and made hidden to avoid people finding it by mistake:

    From a permission perspective the user anyway needs to have at least Read permission on all the information he wants to retrieve...

    Personally I would configure it like this...

    1. Create a new Form with a Textfield for the user to put in a site Url.
    2. Place below a Data Lookup extended with additional Columns like Title, Owners, Admins, etc.
    3. Configure a filter on this Data Lookup just showing the site matching the typed in site Url by the user

    Hope this helps!
    Best regards,
    Christof

    0
  • Joerg_K.

    Hello Christof,

    many thanks, of course "This case would definitely be easier if you store the information in a SharePoint list instead of an Excel file." but the Excel is a result from an automated report, therefore my question. 

    However, creating a list out of the Excel and then following your description would be a workaround. But there are too many steps in general to get this all automated.

    Many thanks,

    I'm looking to find a different solution maybe a flow can grab data from the Excel...

    Cheers
    Joerg

    0

Please sign in to leave a comment.