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
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?
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?)
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
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
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.
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
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!
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
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 😊
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?
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. th-cam.com/video/pp6wBvy9Wgs/w-d-xo.htmlsi=SZtDq7jX3Z68TXVo
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.
@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.
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.
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
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?
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
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
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
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 ~
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 ?
@@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
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!
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
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?
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.
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 th-cam.com/video/pp6wBvy9Wgs/w-d-xo.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
I can not import/ convert 20k+ records how do we deal with large set of records?
Use dataflows to import the data into DV Tables and then build an app from table
Another banger, Reza. This is also a really good tutorial for some key Dataverse topics
Thanks so much!
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
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
Thank you Reza. This came in handy
Most welcome
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
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!
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
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 😊
Dataverse Lookup cols to spreadsheets?
As long as you get your data connected in Dataverse, you can build model-driven app
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, has anyone used powerautomate to connect two SharePoints through primary keys and export them?
I have not tried that
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. th-cam.com/video/pp6wBvy9Wgs/w-d-xo.htmlsi=SZtDq7jX3Z68TXVo
@@RezaDorrani that was perfect!
Hello Reza, can we create same way from unstructured excel to power apps
Any excel file will work but unstructured means more work and depends upon the scenario
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
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.
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.
Does it refresh when you refresh excel?
No
@@RezaDorrani so theres no way to do that?
@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.
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.
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
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
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
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
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
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.
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
I do not offer 1:1 consulting. I would recommend posting your issue on forums at powerusers.microsoft.com
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 ?
@@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
@@RezaDorrani thanks again, Reza! You're the best!!