Unanswered

Creating a Lookup columns in Sharepoint list with excel file

(0) Share

Report

Posted on by omarelm321

hello everyone,

I have a sharepoint list that contains
Product ID , Product name, Product sales, Sales date , amount,

and i am trying to retrieve all product columns from an excel automatically using Lookup function. i 've used this function

LookUp(Tableauproduit, 'Product ID' = DataCardValue3.Text, 'Product Name')
but i got this error :
Error when trying to retireve data from the network.

Could you pls help.

Categories:

Building Power Apps

I have the same question (0)

All responses (10)

Answers (0)

Drrickryp Super User 2024 Season 1 on at

Like (1)

Report

@omarelm321

I would assume you have Tableauproduit connected to your App. In any event, Excel is a terrible database https://www.youtube.com/watch?v=RtmZM3tm2Zs and I would first suggest that you move your data to SharePoint. It is very easy to corrupt the link by changing column names, column types or any aspect of the schema of the table after it has been imported into PowerApps.

Was this reply helpful? Yes No
omarelm321 31 on at

Like (0)

Report

By the way Product table is in Sharepoint

Was this reply helpful? Yes No
omarelm321 31 on at

Like (0)

Report

im trying to move it to Sharepoint list but the product table is so large and i need like 8 columns to do the lookup any idea , suggestion how to solve it ?

Was this reply helpful? Yes No
Drrickryp Super User 2024 Season 1 on at

Like (0)

Report

@omarelm321

First, see if your data is corrupted. Put a Datatable control on the screen and in the datasource on the right side of the screen, select your Excel table. It should populate the data in all the fields. If not, let me know. If so, please share a screenshot of the datatable.

Was this reply helpful? Yes No
omarelm321 31 on at

Like (0)

Report

Hello, so i used DATA table preview and then i've added columns. so data got populated from my data source.
I guess the problem maybe in the formula ?

Was this reply helpful? Yes No
JaguarMonkey 71 on at

Like (0)

Report

When you say large how many rows are we talking

Was this reply helpful? Yes No
omarelm321 31 on at

Like (0)

Report

4000 rows * 8 - 9 columns

Was this reply helpful? Yes No
omarelm321 31 on at

Like (0)

Report

Hello everyone,
Now im exporting my excel DATA to Sharepoint list in order to use it in Powerapps.
So im launching a power automate flow that get DATA from excel and publish it in SP list. but i dont know how to refresh the connection in power apps when the power automate flow is ended.
Any ideas how to do it ?

Was this reply helpful? Yes No
Drrickryp Super User 2024 Season 1 on at

Like (1)

Report

@omarelm321

Use this method https://techcommunity.microsoft.com/t5/microsoft-sharepoint-blog/create-a-list-from-microsoft-excel/ba-p/1422192#:~:text=1%20From%20within%20your%20SharePoint%20site%2C%20click%20the,from%20files%20already%20in%20Microsoft%20365%20More%20items

Before import remove spaces and special characters from column names.

Was this reply helpful? Yes No
omarelm321 31 on at

Like (0)

Report

Thank for your response. I ve managed to upload data from excel to SP list by Power automate. now im willing to refresh the SP list in Power apps when the flow in power automate is finished. i'm thinking maybe using the response to power apps action but still don't know how to do it.

Was this reply helpful? Yes No