web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Copilot Studio / Issues with an Action ...
Copilot Studio
Answered

Issues with an Action reading an Excel File

(0) ShareShare
ReportReport
Posted on by 48

Hello,

 

I have been trying to create a ChatBot within Teams and have created multiple choice questions, triggers etc. I have gotten stuck with calling an Action where I would like the Input from a question:

 

What is the company name?

 

To return the Assigned Person (same row within the excel table, different column) I have a simply excel sheet (CompanyName and Assigned_Person). The aim is to return the Assigned_Person if the CompanyName entered is in the file.

 

I followed the very informative video by Rezza Dorrani where they explain and build something similar but check the status of a numerical ticket, I have done some digging and change slightly but doesn't work.

 

Any suggestions or posts that go through creating an Action looking up a word/letter string in a row within excel?

 

ScottinPoland_0-1680766647156.png

and the condition:

ScottinPoland_1-1680766904039.png

 

 

 

 

 

 

 

 

 

I have the same question (0)
  • Verified answer
    ScottinPoland Profile Picture
    48 on at

    I managed to solve the issue by moving the excel file to SharePoint. Works as I would like 🙂

    If anyone is looking at something similar then I can recommend the youtube video by DamoBird365:

    Power Virtual Agents & Power Automate: Quick Start Guide in Under 8 Minutes

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Copilot Studio

#1
Romain The Low-Code Bearded Bear Profile Picture

Romain The Low-Code... 240 Super User 2026 Season 1

#2
Valantis Profile Picture

Valantis 226

#3
Arild Aarnes Profile Picture

Arild Aarnes 73 Super User 2026 Season 1

Last 30 days Overall leaderboard