How to Convert Your EXCEL Spreadsheets into POWER APPS | Tutorial

แชร์
ฝัง
  • เผยแพร่เมื่อ 27 ธ.ค. 2024

ความคิดเห็น • 66

  • @dougydoe
    @dougydoe 7 หลายเดือนก่อน +2

    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

    • @RezaDorrani
      @RezaDorrani  7 หลายเดือนก่อน

      Most welcome!

  • @WTFireResistance
    @WTFireResistance 7 หลายเดือนก่อน

    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

    • @RezaDorrani
      @RezaDorrani  7 หลายเดือนก่อน

      You would need to reach out to your admin. You need to have Dataverse in environment + permissions in environment

  • @edersongarcia855
    @edersongarcia855 3 หลายเดือนก่อน

    Hello, I have an application that I need to import data from a standard report on a daily basis. Do you have a video showing how to have an interface where I can select the file and run the command to load the SharePoint table or list with the Excel or CSV data?

    • @RezaDorrani
      @RezaDorrani  3 หลายเดือนก่อน

      I don’t have a specific video on that. However there is a manually triggered flow option which has input options to upload a file.

  • @Binaryfyre
    @Binaryfyre 7 หลายเดือนก่อน

    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?)

    • @RezaDorrani
      @RezaDorrani  7 หลายเดือนก่อน +1

      If you have solution by default turned on then yes.
      Check this video th-cam.com/video/pp6wBvy9Wgs/w-d-xo.htmlsi=N6SxUwaMB5RL7Q6Y

  • @akhimullahkaswan6368
    @akhimullahkaswan6368 7 หลายเดือนก่อน

    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

    • @RezaDorrani
      @RezaDorrani  7 หลายเดือนก่อน

      I am not sure why as it is an out of the box feature

  • @ArunKumar-zj6zd
    @ArunKumar-zj6zd 4 หลายเดือนก่อน

    I can not import/ convert 20k+ records how do we deal with large set of records?

    • @RezaDorrani
      @RezaDorrani  4 หลายเดือนก่อน

      Use dataflows to import the data into DV Tables and then build an app from table

  • @greg2kdotcom
    @greg2kdotcom 7 หลายเดือนก่อน +1

    Another banger, Reza. This is also a really good tutorial for some key Dataverse topics

    • @RezaDorrani
      @RezaDorrani  7 หลายเดือนก่อน

      Thanks so much!

  • @tomatoK-mu5hg
    @tomatoK-mu5hg 7 หลายเดือนก่อน

    May I ask can I add the new information directly into the excel form or into the power apps?

    • @RezaDorrani
      @RezaDorrani  7 หลายเดือนก่อน

      Power Apps
      No need for excel anymore as all data is stored in Dataverse connected to power app

  • @jaymangukia15
    @jaymangukia15 7 หลายเดือนก่อน +2

    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

    • @RezaDorrani
      @RezaDorrani  7 หลายเดือนก่อน +2

      You should have asked me something else :)
      My next video talks about it

  • @oluwatobiyusuf
    @oluwatobiyusuf 6 หลายเดือนก่อน +1

    Thank you Reza. This came in handy

    • @RezaDorrani
      @RezaDorrani  6 หลายเดือนก่อน

      Most welcome

  • @manjunathak4822
    @manjunathak4822 7 หลายเดือนก่อน

    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.

    • @RezaDorrani
      @RezaDorrani  7 หลายเดือนก่อน

      Probably via flow and calling SharePoint REST API. Not something I have tried though.

    • @manjunathak4822
      @manjunathak4822 7 หลายเดือนก่อน

      @@RezaDorrani let me also try.thanks.

    • @manjunathak4822
      @manjunathak4822 7 หลายเดือนก่อน

      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' "

    • @RezaDorrani
      @RezaDorrani  7 หลายเดือนก่อน

      @@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

  • @arunwats
    @arunwats 6 หลายเดือนก่อน

    Thank you Reza, this is great!
    I want to design an App where I need to read the data either from SQL or Dataflow, have some additional fields updated by users and save the complete record to the sharepoint or dataverse table, how should I setup that? Thanks in advance!

    • @RezaDorrani
      @RezaDorrani  6 หลายเดือนก่อน

      Welcome!
      I have not come across the scenario mentioned. I will recommend checking or posting your query on forums in case someone has done something similar powerusers.microsoft.com

  • @bhavnishah6931
    @bhavnishah6931 6 หลายเดือนก่อน

    Hi Reza, great video.
    Can the model driven app pick up financial data from SAP. Currently we download from SAP every week and have lookup columns to our spreadsheets. Thank you in advance 😊

    • @RezaDorrani
      @RezaDorrani  6 หลายเดือนก่อน +1

      Dataverse Lookup cols to spreadsheets?
      As long as you get your data connected in Dataverse, you can build model-driven app

  • @hindireaction8585
    @hindireaction8585 7 หลายเดือนก่อน

    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?

    • @RezaDorrani
      @RezaDorrani  7 หลายเดือนก่อน

      User will always need a license.

  • @Harry-lj4xm
    @Harry-lj4xm 7 หลายเดือนก่อน

    Hello, has anyone used powerautomate to connect two SharePoints through primary keys and export them?

    • @RezaDorrani
      @RezaDorrani  7 หลายเดือนก่อน

      I have not tried that

  • @patelbhargav
    @patelbhargav 7 หลายเดือนก่อน +2

    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?

    • @RezaDorrani
      @RezaDorrani  7 หลายเดือนก่อน +2

      Yes! I did a video on solution by default and preferred solution. All this will directly land in solution. th-cam.com/video/pp6wBvy9Wgs/w-d-xo.htmlsi=SZtDq7jX3Z68TXVo

    • @patelbhargav
      @patelbhargav 7 หลายเดือนก่อน +1

      @@RezaDorrani that was perfect!

  • @santoshbojan106
    @santoshbojan106 5 หลายเดือนก่อน

    Hello Reza, can we create same way from unstructured excel to power apps

    • @RezaDorrani
      @RezaDorrani  5 หลายเดือนก่อน

      Any excel file will work but unstructured means more work and depends upon the scenario

  • @gmatdakuti
    @gmatdakuti 7 หลายเดือนก่อน

    I do not see the options enabled to "create with excel" or "start with a blank table". Is that a copilot license issue?

    • @RezaDorrani
      @RezaDorrani  7 หลายเดือนก่อน

      Your environment admin might have disabled the feature

  • @denistonarmstrong5219
    @denistonarmstrong5219 7 หลายเดือนก่อน +1

    Hi Reza, will you please show how to make powerapp of an excel present in SharePoint and refresh the data periodically?

    • @RezaDorrani
      @RezaDorrani  7 หลายเดือนก่อน

      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.

  • @michaelc2712
    @michaelc2712 7 หลายเดือนก่อน

    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.

    • @RezaDorrani
      @RezaDorrani  7 หลายเดือนก่อน

      Thanks so much!
      I have done videos on working with Dataverse table relationships in canvas apps. I will recommend checking them.

  • @omarjackson6366
    @omarjackson6366 2 หลายเดือนก่อน

    Does it refresh when you refresh excel?

    • @RezaDorrani
      @RezaDorrani  2 หลายเดือนก่อน

      No

    • @omarjackson6366
      @omarjackson6366 2 หลายเดือนก่อน

      @@RezaDorrani so theres no way to do that?

    • @RezaDorrani
      @RezaDorrani  2 หลายเดือนก่อน

      @omarjackson6366 Not via steps shown in video. You can check dataflows in detail and see if you could schedule that to run periodically to sync from excel.

  • @chkrishna1
    @chkrishna1 6 หลายเดือนก่อน

    Hi Reza, I learned lot from your videos and implementing apps. Thank you so much for helping others. I am trying to create an app from excel. In the excel I have twelve months columns and one additional column as a category. I have 4 category values, first two category as data entry and other category as calculations based on first two entered data. I want user to enter data like in excel. Do you have solution for that. Appreciate if you can show some examples for this scenario.

    • @RezaDorrani
      @RezaDorrani  6 หลายเดือนก่อน

      You’re most welcome!
      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 done something similar powerusers.microsoft.com

  • @REDzVelvet
    @REDzVelvet 7 หลายเดือนก่อน

    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?

    • @RezaDorrani
      @RezaDorrani  7 หลายเดือนก่อน

      You can continue adding data in power app

  • @SubrataPal123
    @SubrataPal123 7 หลายเดือนก่อน

    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.

    • @RezaDorrani
      @RezaDorrani  7 หลายเดือนก่อน

      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

  • @remuslupinhp
    @remuslupinhp 5 หลายเดือนก่อน

    Hi Reza, first of all thanks for this. I think your tutorials are pretty in depth and always helpful. However, I want to convey a few things to you about this particular tutorial. It is pretty complicated. I had to follow it several times to get it right. I think maybe the topic itself is way too complicated but if you could follow it step by step then it would be much easier.
    For example, you haven't mentioned in several places, what is the significance of what you are doing. Coming from a Power BI background, I am used to creating relationships in the Data Model view. And I guess that kind of view is not available in PowerApps, or maybe I am not aware of it as I am a newbie here.
    When I tried importing Excel it failed several times because the column order wasn't right. I used my prior Power Query knowledge to figure it out.
    You never mentioned that using 2 different tables for lookups is necessary. What if I had to create lookup to one table only but then there was only one primary column in that table.
    Also Why does that annoying Created on column keep popping up all the time in any new table that's created.
    Also the primary column can only be a text column, this needs to be clarified, or maybe I am doing something wrong or maybe it is because I am on the developer environment.
    Such small small pitfalls were taking me a lot of time to get things right. Though I finally got it right.
    So if you can possibly include a few lines on things you can do wrong in each step, it will be very helpful because I am working with another dataset as your dataset is not available for download. So it gets very tricky because I need to constantly keep in mind the parallels.
    If at each step you can also explain a little about the additional stuff like Primary column while creating a table etc.. It will bring a lot more clarity.
    Ultimately the thing is that following your tutorials results in developing several components, but it doesn't bring complete clarity because there is so much to grasp. Also if you can mention related videos such as maybe a video covering features of a dataverse table, then viewers can go to those and get the clarifications they need.
    I hope you won't mind me giving you this feedback but I have seen so many PowerApps videos and yours are the best, but a little difficult for newbies to grasp and I have previously gained basic PowerApps understanding and still finding some concepts difficult so imagine if someone starts with PowerApps for the first time with your videos, that person will be completely lost.
    But still thanks a lot, most of your videos are pretty thorough, only this one lost me. Keep up the good work.
    Thanks

    • @RezaDorrani
      @RezaDorrani  5 หลายเดือนก่อน

      The video is a tutorial and focused on sharing what the feature does.
      Typically I target around 20 mins for a video.
      What you are asking for is more of training.
      Im also running a training program for channel members in Gold tier where we are covering all aspects step by step with live q/a. That could be a good option.
      Additionally, I would recommend to utilize the forums for assistance powerusers.microsoft.com

  • @NghiLuuVinh
    @NghiLuuVinh 7 หลายเดือนก่อน

    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 ~

    • @RezaDorrani
      @RezaDorrani  7 หลายเดือนก่อน

      You are most welcome!
      Print function only supports single screen.

  • @vanessasales028
    @vanessasales028 6 หลายเดือนก่อน

    Can i email you and you can help me create an app i have in mind. Need to know your rate too
    Thank you in advance

    • @RezaDorrani
      @RezaDorrani  6 หลายเดือนก่อน +1

      I do not offer 1:1 consulting. I would recommend posting your issue on forums at powerusers.microsoft.com

    • @vanessasales028
      @vanessasales028 6 หลายเดือนก่อน

      Thanks for your prompt response. We are planning to create a tool where users can click buttons and it will generate a template. We dont want the app to save the info that users have entered for security pusposes. Its just a simple template generator that will help the user document stuff immediately. Is that possible w/ Power apps ?

    • @RezaDorrani
      @RezaDorrani  6 หลายเดือนก่อน +1

      @@vanessasales028 Not sure as this is not a scenario I have tried. I will recommend checking or posting your query on forums in case someone has done something similar powerusers.microsoft.com

    • @vanessasales028
      @vanessasales028 6 หลายเดือนก่อน +1

      @@RezaDorrani thanks again, Reza! You're the best!!