Import and read data from an excel file in PowerApps

Today's video we will explore how to import an excel file in PowerApps, read data from that file, extract that data and pass it as an array to PowerApps which will then be interpreted within PowerApps using any of the three options; Regex, ParseJSON, Response.
-------------------------------------------------------------
Important Links:
Mockaroo: www.mockaroo.c... ,
Shane Young's video on importing excel: • Power Apps import Exce... ,
Deepak's video on working with Regex: • Send Array/JSON Respon...
Please like, share, comment and subscribe.
see you in two weeks.
___________
Music: Another time
Musician: LiQWYD
___________
Twitter : @kylzbaba
LinkedIn: / udeagha

[@kingsleyudeagha]

Hey guys, you can find the packaged zip file for this App here -> drive.google.com/drive/folders/1sXy8vh9pFejJ2qgp2M6lr3uwAjzE-gph?usp=share_link I hope this helps out as well, Goodluck.

[@siddhkishan]

Hi, I want to use onchange property for modify collection data then after receiving responses from flow to power app then, how would I can update the collection. I struggling to do this. Please help me. I tried the patch function but succeed

[@121balu]

I am getting an error while writing clear(col_attachment) in upload button

[@janhavigunaghe8475]

did you find solution on this?

[@edersongarcia855]

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 tried to import your application to see your example but I couldn't.

[@giangtruong9467]

Thanks for sharing! I have a question. Can I get File content of excel file with many sheets?

[@kareemtoheeb5932]

awesome video kinglsy

[@kingsleyudeagha]

Thank you, Kareem.

[@jhunudash2670]

Hi Kingsley, Could you please let me know how to apply multiple filter condition while filtering the excel data. i have a large excel data with more than 2Lacs record.

[@anthonjhnon1]

Nvm, don't answer you are still using Power Automate's response.

[@anthonjhnon1]

With your Regex method, how did you tell it to use your KZbinTable (name you gave the Table in excel)? The table in my excel file is not on the first worksheet in my excel.

[@syedhammadali89]

Amazing tutorial thanks alot

[@kingsleyudeagha]

You're welcome!

[@RajYadav-e2f]

Hello Sir, request your support, my requirement is to give excess to users to upload Excel in power apps and with the help of that Excel data shave in sharepoint, Excel have only three to four fileds

[@programsinfo8974]

Hi,I need to create a button in my app to upload excel or csv data to my tblData sharepoint list inside the app. Like an Import button then it will open dialog box to choose the csv file then when the user hit Open it will save to the SharePoint list. Is that possible?

[@rosscortb]

I seem to be getting the following error after clicking the upload button - Bad gateway: The server did not receive a response from the upstream server

[@shilpapathaniya3230]

Hi Kingsley, Thanks for sharing I am also trying to upload file in sharepoint and the get the content in power apps collection. Referring your power automate flow but I am stuck at "list row present in table" action it is giving me bad gateway error I checked everything my connection with sharepoint is also ok .I have download zip file which you shared and applied the same steps as per your flow but still have the same bad gateway error. Can you please suggest something which I do to resolve this issue. TIA

[@klementinhasani7236]

But this solution is not a long term because if you publish the APP. The collection is empty. Do you have any idea how to resolve?

[@HuyNguyen-vm3ox]

can you help me please, i'm getting the parse json error expecting string but got array

[@raghukalyan7126]

Hi Kingsley what is the col_attachment_flow

[@AndreasTornbrink]

Could you share the code? im struggeling getting this import to work :( There is an cut in the clip at 7:05, so i guess i missed something that happens that is now showned.

[@kingsleyudeagha]

Hello Andreas, apologies I am just seeing this. If you still have this issue, please email me [e-mail]

[@robgarden]

@@kingsleyudeagha It's col_attachments for your gallery. You skipped the config for that. Can you quickly explain what you did there?

[@kingsleyudeagha]

@@robgarden Hi apologies, you can find that missing code clipchamp.com/watch/sFNbTfQpWTA

[@miriamtrippenbruh8518]

@@kingsleyudeagha Could you possibly repost this clip? I think it expired.

[@janicemendoza376]

Hi! Great tutorial! I am doing the exact thing. The flow runs successfully but the Compose Inputs and Outputs are downloadable files and only show 1 [ ]? Appreciate your help!

[@kingsleyudeagha]

Thank you Janice. I will need a little more information, kindly send a screenshot of your flow and more information to my mail [e-mail]

[@janicemendoza376]

@@kingsleyudeagha Great! I will send it tomorrow! Appreciate your help! Thanks in advance. :)

[@janicemendoza376]

@@kingsleyudeagha Hi kingsley! Email sent! Appreciate your feedback. Thank you! :)

[@954giggles]

I cant get the attachment to show as a field so I can copy it

[@kingsleyudeagha]

At what point are you experiencing this ?

[@c.mdsalih]

Great content, Big thank you 🙂

[@Bhojpurisongs12393]

Thank you so much it helped me alot.. Thank you

[@enabothulapavankalyan776]

After download the excel you drag and drop the excel to sharepoint list . can you share a link how to upload excel to share point list

[@kingsleyudeagha]

Hello Pavan, That is not a list but a SharePoint library. Works the same as your computer folder. You can drag and drop or pick the file from your computer.,

[@inyeneetukudo2998]

👏🏻👏🏻👏🏻

[@enabothulapavankalyan776]

Missing some steps . In Compose (input & output) iam not getting any code to copy and past at Parse JSON so what I do to get the code. Help me

[@dejifauji]

big thanks mr kingsley 🙏

[@oluwatobiyusuf]

Thanks for this awesome content Kingsley

[@kingsleyudeagha]

Thank you for watching, Tobi.

[@Ibekweeddison]

This is good, Kingsley. Thank You!

[@kingsleyudeagha]

You're so welcome!