excel data in powerapps | upload excel powerapps new

uploading excel into power app is a very common requirement that you definitely would have encountered hi everyone this is prashant chaudhary i welcome you all to my channel classic power in this video i will be explaining you how you we can actually upload the excel data into our powerapp i have already created the video on that but after analyzing the comment i got to know that i have missed some steps that makes viewers confused like what approach i have used and how it was working so this is actually the new version of that video okay so i'll provide the link of that video in the description of this video so this was the approach that i have used in that video what i was doing in that from the power app i was uploading one excel file through the list attachment control that list is actually the sharepoint list of mine so i was uploading one excel file from the list attachment then my list that file that is present in my list attachment would be transferred to one document library using my power automatic flow then once my file once my uploaded file comes into the document library i have used the excel connector to act to read the rows present in the excel sheet later i sent those rows as a response back to my power app and in the power app i have stored those rows into one of my collection and presented this collection through the gallery control so i find people are good confused at these two stages how they can read the excel rows and how it would be sent to the power app upper two stages they are very clear with that but below stages are actually make them confused so i decided to create new video just which is only explaining these two steps okay so without wasting time i'm just navigating it to my screen so here i decided to create the same case okay so let me just open my one of my app note let's create the new f blank app and canvas only and let's say excel data okay if i go with the approach list attachment first my file will be stored into the list attachments then it would be stored into the document library so i am assuming that you know how the file would be stored to the document library you can use any approach either you can you upload the file through the list attachment or you upload the file directly okay so i'm just assuming that you know how to upload the any file into any sharepoint library or any cloud storage data whatever you would like to use you can use any cloud to show either the onedrive folder or maybe the sharepoint or maybe any other okay so i'm just assuming that you know how the file would be stored into any document library okay so i'm just trying to explain you the blow steps so here on the app i have uploaded one excel file into one of my sharepoint document library whose name is uploaded files and it is present in my production site this is just my name of my product and sharepoint site okay so in that excel i have some data i want that data to be presented in my powerapp so for that what i need to do is i need to create one power automate okay so i'll go with the power automate and add the new and i will create the new flow click on the new one so since this needs to be add triggered from the power app so i use the blank start from scratch okay so that needs to read the excel rows first okay because the file is already stored into any folder so i use excel online cutter and use the action which is my list rows present in a table okay i use that one and i need to just add the location so my site was the production site uh sharepoint site production site this one document library was my uploaded files so i use uploaded files in that file i have that file book one and in that i have the table okay so right now i'm just passing the static values because my file is already stored and i have only one file there but if i would be doing this from uploading the file from the powerapp in that case i need to pass the dynamic content okay so the movie is just to show you how the excel rows would be read and would be stored into the powerapp so i get the x rows from this step now i'll use one action that is the initialize variable and i use one variable let's say it's my where the type i'm using is to be array because the rows that whatever the rows would be read from the excel would be would come like a row array okay so i'm just storing trying to store the response into one array variable so here i'll pass the values here the list of item values because i need all the values to be stored in that array variable okay so i pass value once i pass the value i add one more action which is sending the response okay so i write response it comes with steep deep something not this one how can i write that so here i have this response although this is a premium connector please keep in this in your mind so this would actually send the json type of format or the array of type of values okay at the place from where your power automate is actually triggered in order to get the response we have two different type of actions either we use the respond to power action or we use the response respond to powerapp is actually used to pass to send the either any type of string type of variable or any type of numeric type of variable or maybe that date and time type of variable but this response but that would can't send you any type of json or maybe any type of array okay so in order to pass this type of data we use this connector in the body what we use we use this variable and here we need to pass some json schema okay so i want that json to be created from my power automate itself so i use get excel this is my name save it okay so i get this app inside here and now i add one button which is actually triggering my flow so i use get on the on select on the on select i need to trigger that flow okay so i since that flow is getting data that data is in the json form or in the any type of a list of data okay so it should be stored somewhere either in any type of variable or maybe the collection since that would have some rows of data so it would be stored into the collection so i use clear collect function first and collection name i use col cell data and now i run my flow get excel daughter run he said i need not to pass any type of argument so now what i do i simply call this once okay once i call this now i come back to my power automate edit and i need to check my logs of this flow so that i would get this response that can be used to generate the schema okay so from where i can maybe not from here i need to go with power automate okay so here in my flows i would have this flow this is my excel data if i open this i can check the logs and it is succeeded if i just try to expand this i will get get those data so what i need to do is i need this okay it is not showing me i can eat that as well so this array is having some data i need that data to be presented in my system so i simply copy the hole okay and make this edit and in the response in the schema i need to generate it from sample and i'm pasting the same data here only once i click on this done i can see this is type of array okay and i get all the things like the item id title quantity discount whatever the column is there okay i need that schema here now i simply click on the save button and come back to my power app again and now refresh it one more time and i add one gallery that would be showing me the data if i get that data okay so i use gallery and this would make data okay let's try to check now if i click on this button i get the data here okay if i come back and try to see the settings not from the settings but from the from here i get the collection so here you can see i have my data here okay if you would like to see others you can see like for the title okay this is for the quantity so here you can see i get my data and that data is actually stored into my excel sheet okay so that is how we are getting that excel data into the power now we can once we get that data into the power app we can use that data either to store into our database or do any type of customize or any type of comparison with the database you can do whatever you would like to do okay so i've explained only these two steps i have highlighted only these two steps because i find that people are got confused with these steps that have used in that video okay if you haven't watched that video please watch it out first okay then after you can understand it very well so thank you everyone thank you everyone thanks for watching this video and if you still get out in the in this in this uh concept like how we can get the excel data please write to me i'll come with the you know on a chat with you okay because i have helped to many other viewers of my life who just tried to contact me over my linkedin or maybe any other place i simply tried to connect with them and try to resolve their queries okay so thank you for for watching this video everyone thank you

Channel: Classy Powerapps

Views: 5,208

Keywords: excel upload in powerapps, powerapps excel upload, excel data in power apps, how to upload excel in powerapp, excel upload, excel in powerapps, update data from excel data, data upload from excel, excel database in powerapps, how to use excel in powerapps, powerapp excel upload, Excel rows in powerapps, how to get excel rows in powerapps, upload excel from powerapps, collection patch in powerapps, Patch whole collection

Id: s5dV_nSUBDY

Length: 14min 0sec (840 seconds)

Published: Mon Oct 10 2022