Is there a way to access existing data through Power Apps Portals/CDS/Dataverse?
Below is list of ficticious assessments I am displaying in a Power Apps Portal page. I created all of the assessment new adn stored them in the CDS.
I have an Excel spreadsheet that has hundreds of line of data that I'd like to display instead of the ficticious data.
How do I get the data in the Excel document into CDS so that I can access it from here...
Go to Solution.
The simple way I would think is to use Dataflows
You can easily generate your entity and map each column to a field. Clear instructions are in the official URL.
1. Log into https://make.powerapps.com/
2. Choose your environment
3. Dataflows > "New DataFlow"
4. Choose an Excel Spreadsheet as the data source
5. You can use PowerQuery if you need any modifications
6. Map the appropriate fields to relevant columns
7. Click OK
All your 20,000 records will be imported. You can also use "Data Import ++" from the XRM toolbox to achieve this need. Once done. You can display the data as an entity list.
Hope it helps. ------------
If you like this post, give it a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users to find it.
View solution in original post
Read all about the most recent blogs in the community!
A great place where you can stay up to date with community calls and interact with the speakers.
Check out the latest News & Events in the community!