Skip to main content

Notifications

Community site session details

Community site session details

Session Id : gmf6X5n+06rKjJwFhBLy+X
Power Apps - Building Power Apps
Unanswered

Accessing Excel Data in formula

Like (2) ShareShare
ReportReport
Posted on 13 Aug 2024 19:14:13 by 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. 
  • Suggested answer
    Robu1 Profile Picture
    1,220 Super User 2025 Season 1 on 13 Aug 2024 at 20:49:29
    Accessing Excel Data in formula
    Hi @ ,
     
    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:
     
     
     
    If this fixes the issue, please mark as suggested answer.
     
    Happy to help, 

    Robu 1
     
  • Michael E. Gernaey Profile Picture
    42,301 Super User 2025 Season 1 on 13 Aug 2024 at 20:40:27
    Accessing Excel Data in formula
    Hi,
     
    So before we go far, in what platform are you building this...

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

🌸 Community Spring Festival 2025 Challenge Winners! 🌸

Congratulations to all our community participants!

Warren Belz – Community Spotlight

We are honored to recognize Warren Belz as our May 2025 Community…

Leaderboard > Power Apps - Building Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 250 Most Valuable Professional

#2
MS.Ragavendar Profile Picture

MS.Ragavendar 122

#3
stampcoin Profile Picture

stampcoin 108

Overall leaderboard
Loading started