Announcements
Hi.
New to PowerApps, I am trying to make an app where the user can select which column to work with for further processing.Excel is stored at blob storage.Question: How do I read the data from Excel and show the column headers(/names) as dropdown(/radio)?
Am not sure of azure blob. But for you to connect in the way you are requesting for, put the excel in OneDrive. Ensure the you have a formatted excel table then connect to Powerapps.
After the connection, the items of the Radio put;
TableName.ColumnName
------------If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.
Sadly, I am stuck with Blob. OneDrive is NOT an option.
@anantnd
Once your app can get her hands on the data inside the Excel file, it should be easy to put in a dropdown etc.
Have you tried to get access to your Excel file with the commands from the Azure Blob Storage connector?
https://docs.microsoft.com/en-us/connectors/azureblob/#actions
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.
Congratulations to our community stars!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
WarrenBelz 320 Most Valuable Professional
11manish 210
Valantis 167
