How to Convert Your EXCEL Spreadsheets into POWER APPS | Tutorial
HTML-код
- Опубликовано: 30 май 2024
- In this tutorial video, we will learn how to convert your Excel spreadsheets into Power Apps & Dataverse Tables in a matter of minutes with AI Copilot assistance in Power Apps. For scenarios with spreadsheets that include data relationships (multiple sheets / tables in Excel), I will show how you can create, relate and import data into multiple Dataverse Tables and build fully functional Model-driven Power Apps / Canvas Apps on top of it.
#powerapps #dataverse #copilot #powerplatform
0:00 - Get started with converting Excel files to Power Apps
0:38 - Create a Canvas Power App from Excel data with Microsoft Copilot assistance
3:28 - How to work with importing multiple Excel tables in Dataverse
6:05 - Setting up Dataverse Table Relationships
8:17 - Create a Model-driven Power App (Views/Forms)
10:20 - Import your Excel spreadsheet with data relationships into Dataverse Tables
15:33 - Update your Model driven Power App to show related data & use Copilot in Power App 
Наука
The timing couldn't be more perfect. Recently worked through some videos on Model Driven Apps to deepen my understanding on Relationships especially so this has further enhanced the concepts for me. I'll re-watch and reproduce this to really "get it" Thank you for always coming through with the appropriate materials. Greatly appreciated
Most welcome!
Hi Reza! I have been following your videos since long time. They are really helpful.
Can you make a video where you can explain a process of transferring the ownership of the flow from a user to another user. And also you can explain whether we can give the ownership of the flow to a service account. If yes then how? That will be really very helpful
You should have asked me something else :)
My next video talks about it
Another banger, Reza. This is also a really good tutorial for some key Dataverse topics
Thanks so much!
Great video Reza, clear and concise way to get started. Curious if you can continue with the canvas app instead of switching to the model driven.
Thanks so much!
I have done videos on working with Dataverse table relationships in canvas apps. I will recommend checking them.
Hello Reza,
Great video! I would like to ask would you be able to continue to add new data? I would like to upload new data as well collecting response from PMs each month, would this be possible?
You can continue adding data in power app
Thank you Reza. This is a great video. Also, how would you approach adding this to a solution? 1. Set the publisher of the solution as default 2. Create tables and the app as demonstrated 3. Add them to the solution 4. Add dependency for table and app to the solution… Is there anything more?
Yes! I did a video on solution by default and preferred solution. All this will directly land in solution. ruclips.net/video/pp6wBvy9Wgs/видео.htmlsi=SZtDq7jX3Z68TXVo
@@RezaDorrani that was perfect!
Hi Reza, will you please show how to make powerapp of an excel present in SharePoint and refresh the data periodically?
I make videos when I receive multiple requests on a topic. Every 6 months I ask subscribers for topic suggestions on Community Tab of my channel. Most voted idea gets added to my backlog. Make sure to post this idea whenever I post the next topic suggestion post.
When creating this app, like when you get to the "create app" step, does Power Apps create this in a solution automatically? (e.g., the new dataverse table along with the app in a prenamed or defined solution?)
If you have solution by default turned on then yes.
Check this video ruclips.net/video/pp6wBvy9Wgs/видео.htmlsi=N6SxUwaMB5RL7Q6Y
Hi, can I know why I cant delete at the form section, the delete option is not available, its there but it I cant press it as it is not available for me
I am not sure why as it is an out of the box feature
May I ask can I add the new information directly into the excel form or into the power apps?
Power Apps
No need for excel anymore as all data is stored in Dataverse connected to power app
Hello, has anyone used powerautomate to connect two SharePoints through primary keys and export them?
I have not tried that
Hi, this is a very great video. Big fan from Vietnam. I have watched a lots of your videos and it truly help me a lot to create my own web. By the way, I am facing with a issue. I created a form with multiple tabs. I want to print the form will all information in all the tabs, not only the visible screen. Could you help me with this. I would appreciate a lot ~
You are most welcome!
Print function only supports single screen.
Hi reza I need to share power app application to external user so I added guest user in AD so I want to know I need to provide any license to the user or user can access the app?
User will always need a license.
Hello dear Raza, in my company we can't click on Create with excel file 1:08 because it is locked. Do you know how to unlock it ? Thank you
You would need to reach out to your admin. You need to have Dataverse in environment + permissions in environment
I do not see the options enabled to "create with excel" or "start with a blank table". Is that a copilot license issue?
Your environment admin might have disabled the feature
Hello Reza, is there any way to fetch the all column names of a SharePoint list dynamically from powerApps..I need all the titles of columns only not data.many thanks in advance.
Probably via flow and calling SharePoint REST API. Not something I have tried though.
@@RezaDorrani let me also try.thanks.
Hello @@RezaDorrani , please check below it's working to get only user created columns only, while parse json make sure to "EntityPropertyName" allow the null values.many thanks. " _api/web/lists/getbytitle('RanksList')/fields?$filter=Hidden eq false and ReadOnlyField eq false and EntityPropertyName ne 'Attachments' and EntityPropertyName ne 'ContentType' "
@@manjunathak4822 I have no plans to investigate in this.
I will recommend checking or posting your query on forums in case someone has done something similar powerusers.microsoft.com
Hi Reza, I have a problem statement, if you help me it will be my pleasure. I have created a power app. I have a user list in share point. I want to provide power app access when ever add a new user in the list and revoke when user removed from the list.
I do not have a video reference on this scenario and would have to try it out to provide guidance. I will recommend checking or posting your query on forums in case someone has experienced something similar powerusers.microsoft.com