Import and read data from an excel file in PowerApps #regex #parseJSON. Send arrays to 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:

Please like, share, comment and subscribe.
see you in two weeks.

___________

Music: Another time
Musician: LiQWYD

___________

Twitter : @kylzbaba

[kingsleyudeagha]

I hope this helps out as well, Goodluck.

[balu]

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

[Bhojpurisongs]

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

[anthonjhnon]

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

[HuyNguyen-vmox]

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

[programsinfo]

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?

[oluwatobiyusuf]

Thanks for this awesome content Kingsley

[klementinhasani]

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?

[jhunudash]

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.

[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

[giangtruong]

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

[raghukalyan]

Hi Kingsley what is the col_attachment_flow

[ykzojep]

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

[shilpapathaniya]

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

[janicemendoza]

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!

[anthonjhnon]

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

[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.

[giggles]

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

[enabothulapavankalyan]

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