📱 Microsoft Dataverse Table Setup, Import Excel Data & Configure Canvas PowerApps

Подписаться 10 тыс.

Просмотров 42 тыс.

50% 1

This video will walk through the process of how to create a table in Microsoft Dataverse, how to import excel data into a Dataverse table and how to create Canvas PowerApps. I will take you on the journey to move from excel sheets to Dataverse tables and how easily you can set up PowerApps using Microsoft 365 Power Platform.
★ TABLE OF CONTENTS ★
• 00:00 Intro
• 00:50 How to Create a Table in Microsoft Dataverse
• 02:43 How to Import Excel Data into Microsoft Dataverse Table
• 04:44 Update Microsoft Dataverse Table Views and Forms
• 08:44 Build Canvas PowerApp using Microsoft Dataverse
• 11:31 Outro & Subscribe
🔴 ** BE OUR FRIEND **
✅ Website: www.keapoint.com
✅ LinkedIn: h / 18782324
✅ Twitter: / kea_point
✅ Facebook: / keapointuk
🔎 HASHTAGS 🔎
#MicrosoftDataverse
#PowerApps
#Excel

Опубликовано:

23 июл 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 60

@kelvinleigh 3 месяца назад

Great video!

@KeaPointTechTips 2 месяца назад

Thanks.

@tinmaung9043 2 года назад

Very useful to us. Thanks Millions.

@KeaPointTechTips 2 года назад

You are most welcome Tin

@anozanb 2 года назад

Thanks for useful video👍👍

@KeaPointTechTips 2 года назад

Welcome 😊

@ushakarreddy1981 2 года назад

Excellent very useful video

@KeaPointTechTips 2 года назад

Glad you liked it

@jr713121 2 года назад

Vey useful info, thanks

@KeaPointTechTips 2 года назад

Thanks

@ventubeb 2 года назад

That's a wonderful session, thanks much for creating it. Can you please post a video on Continuously Push Data from Dataverse to Azure Data Lake

@KeaPointTechTips 2 года назад

Thanks, will try to do a video on the requested topic soon.

@kingquadri1850 2 года назад

Awesome

@KeaPointTechTips 2 года назад

Thanks.

@murthychitturi2562 2 года назад

great vedio... Q) How to export table data? Q) How to run/export reports for customized columns?

@KeaPointTechTips 2 года назад

you can export to excel from dataverse table.

@FRANKWHITE1996 2 года назад

Subscribed ✅

@KeaPointTechTips 2 года назад

Thanks

@evelynm2770 2 года назад

Hi there, thanks for this video, it's very helpful especially as I'm a beginner in Power Apps! I had a question though - could end users upload the excel data into the dataverse tables themselves or is there a way to automate this process? My app requires end users to be able to bulk import excel rows and I'm a bit lost on whats the best way to enable them to do this.. thanks for your help

@KeaPointTechTips 2 года назад

Yes you can, using either the dataflows or using the power automate to read excel content and import data to dataverse table.

@evelynm2770 2 года назад

@@KeaPointTechTips oh awesome, will definitely look into dataflows - i tried power automate but it was a bit slow

@shitalparmar8182 2 года назад

Hi great video on exporting data from excel to cds and app! Just curious question .. I think you mentioned creating model driven app but it looks like canvas app. Did I miss anything

@KeaPointTechTips 2 года назад

Yes, I think I said that by mistake, it is canvas app indeed.

@Sunilprakashsabbithi 2 года назад

Nice explanation. Quick question. My excel file is having 30K records. So can i create table in Data verse and then create a power app form without delegation limit of 2000 ? Also need to search the records ?

@KeaPointTechTips 2 года назад

Yes, you can move 30k records to dataverse. You can search for record via powerapps as long as the result set is below 2k records.

@rohittembhare6412 2 года назад

Hello, nice video, can we automate insertion of data into power apps table through power automate? if yes then please share the video demo

@KeaPointTechTips 2 года назад

Thanks. the PowerApps table could have data source as collection . You can pass collection data form power automate to PowerApps. Check this community article techcommunity.microsoft.com/t5/power-apps-power-automate/pass-collection-from-flow-to-powerapp-collection-data-comes-from/m-p/323618

@youngsichong 2 года назад

Great! Could you tell me the dataverse vs sql ?

@KeaPointTechTips 2 года назад

Are you planning to user Dataverse instead of SQL and looking for professional advice?

@almanzaralbert1 2 года назад

Thanks. Let's say those records have images. How do you bring those imgnes from excel?

@KeaPointTechTips 2 года назад

I have never tried that. I will add this topic to my to do video list.

@almanzaralbert1 2 года назад

@@KeaPointTechTips thanks, mi hermano.

@tansinghrathore4572 2 месяца назад

Hello, is we need to map the column once. Or everytime when we upload a excel.

@KeaPointTechTips 2 месяца назад

Hi, if table name and column structure stays teh same then it should work with existing mapping.

@shitalparmar8182 2 года назад

If there are formulas in the excel file is there an easy way to move that to data verse table ?

@KeaPointTechTips 2 года назад

I don't think there as an out of the box excel formula mapping available for Dataverse.

@ramakrishnapaidi1479 2 года назад

I have multiple tables as one data source as Excel and we some calculations one table, is it possible do calculations and validation possible ?

@KeaPointTechTips 2 года назад

If I understand your question, you can bring data from multiple excel files into PowerApps and perform the calculations on the fly.

@ramakrishnapaidi1479 2 года назад

@@KeaPointTechTips yes.

@anushaakkerapu848 Год назад

Hii I was import my data in the datavarse table I was forgotten one field name while mapping I remember that field name after I will add that field but it didn't seen in that field in mapping time what I will do please help me

@KeaPointTechTips Год назад

You have to map all fields in one go.

@antonheimdal8445 2 года назад

For some reason when I upload the excel file and want to map, the dataverse mechanic does not offer me to map several columns I have already made available. What might be the reason?

@KeaPointTechTips 2 года назад

Can you email excel file (minus any confidential data) at aziz@keapoint.com, I will have a look.

@antonheimdal8445 2 года назад

@@KeaPointTechTips thanks for the reply. I figured it out at the end. What I needed to do was make new columns in dataverse table with more unique names. Like customer age, customer job etc..

@KeaPointTechTips 2 года назад

Glad that were able to resolve it. Thanks for posting it here as this would help other people in the community .

@maheshgiragani7121 2 года назад

Hi Every one how to export the data from Excel To Sql data base using power automate could please guide me

@KeaPointTechTips 2 года назад

First you need to install on- rem data gateway to connect to sql via office 365 power platform. then you can probably write flow to copy data to sql.

@mikewashington4188 2 года назад

Can I connect access front-end to dataverse as the back-end?

@KeaPointTechTips 2 года назад

This is not possible I believe.

@Quidisi 2 года назад

Looks like it will be possible, soon. ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-N5DoteA94G4.html

@KeaPointTechTips 2 года назад

Ah, using Access connector, thanks for sharing this info.

@benjaminlahsen6721 Месяц назад

Hello friend. I keep getting this error and dunno know to solve it: ,"General error","Type=Microsoft.Dynamics.Integrator.Exceptions.IntegratorClientException, Msg=Unable to parse import file 10cc6bd55ee84c99b98002f5f939bec7.xlsx Error details PQOnline failure - Type=System.Net.WebException, Msg=The remote server returned an error: (400) Bad Request."

@KeaPointTechTips Месяц назад

“400 Bad Request” is a general error that indicates that your browser sends a request to the website's server, and the server can't process or recognize the client request. Where this file is hosted?

@pavanmj6180 2 года назад

the app you are creating at the end is canvas app not the model driven app

@KeaPointTechTips 2 года назад

Thanks for the correction. much appreciated.

@LandscapeInMotion 2 года назад

Select another powerapps environment and try this again. You will find you can’t select an existing table. Why? I noticed your on the default environment.

@KeaPointTechTips 2 года назад

I have not tried with a different environment. Will try it soon.

@LandscapeInMotion 2 года назад

@@KeaPointTechTips great! Keen to see if your getting the same issue.