Accessing Excel Data in formula

Like (2) Share

Report

Posted on 13 Aug 2024 19:14:13 by J-G

130

I'm attempting to set up a basic 'login' system for a data visualizer, but I don't know how to load in data from the connector inside of a formula to check against user input. I looked up the commands here Excel Online (Business) - Connectors | Microsoft Learn, but none of them have any actual examples or even explanation of how to call them or format in them the formula box.

Categories:

Connectors

Using Apps Using Formulas

All responses (2)

Answers (0)

Suggested answer

Robu1 1,202 Super User 2025 Season 1 on 13 Aug 2024 at 20:49:29

Like (0)

Report

Accessing Excel Data in formula

Hi @ J-G,

Thank you for choosing Microsoft Community.

Setting up a basic login system using Excel Online (Business) connectors can be a bit tricky without clear examples. Here’s a general approach to help you get started:

Set up an Excel file with a table for usernames and passwords.

Use Power Automate to create a flow:

Trigger: When a user attempts to log in (e.g., a button click in a Power App).

Action: Retrieve data from the Excel file using the “List rows present in a table” action.

Filter Query: Check if the username and password match the user input.

Condition: If rows are returned, the login is successful; otherwise, it fails.

This approach leverages Power Automate to handle the login logic and data retrieval. If you need more details or run into issues, feel free to ask! 😊

View documentation here:

Official Microsoft Power Automate documentation - Power Automate | Microsoft Learn

List of all Power Automate connectors | Microsoft Learn

If this fixes the issue, please mark as suggested answer.

Happy to help,

Robu 1
Michael E. Gernaey 41,538 Super User 2025 Season 1 on 13 Aug 2024 at 20:40:27

Like (0)

Report

Accessing Excel Data in formula

Hi,

So before we go far, in what platform are you building this...