Creating a Lookup columns in Sharepoint list with excel file

Like (0) Share

Report

Posted on 13 Feb 2023 16:31:16 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:

General Questions

Connecting to Data

All responses (10)

Answers (0)

omarelm321 31 on 02 Mar 2023 at 12:29:25

Like (0)

Report

Re: Creating a Lookup columns in Sharepoint list with excel file

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.
Drrickryp Super User 2024 Season 1 on 02 Mar 2023 at 11:18:19

Like (1)

Report

Re: Creating a Lookup columns in Sharepoint list with excel file

@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.
omarelm321 31 on 02 Mar 2023 at 11:14:06

Like (0)

Report

Re: Creating a Lookup columns in Sharepoint list with excel file

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 ?
omarelm321 31 on 15 Feb 2023 at 08:28:40

Like (0)

Report

Re: Creating a Lookup columns in Sharepoint list with excel file

4000 rows * 8 - 9 columns
JaguarMonkey 71 on 15 Feb 2023 at 01:44:11

Like (0)

Report

Re: Creating a Lookup columns in Sharepoint list with excel file

When you say large how many rows are we talking
omarelm321 31 on 14 Feb 2023 at 08:39:38

Like (0)

Report

Re: Creating a Lookup columns in Sharepoint list with excel file

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 ?
Drrickryp Super User 2024 Season 1 on 13 Feb 2023 at 17:38:40

Like (0)

Report

Re: Creating a Lookup columns in Sharepoint list with excel file

@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.
omarelm321 31 on 13 Feb 2023 at 17:31:01

Like (0)

Report

Re: Creating a Lookup columns in Sharepoint list with excel file

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 ?
omarelm321 31 on 13 Feb 2023 at 17:27:00

Like (0)

Report

Re: Creating a Lookup columns in Sharepoint list with excel file

By the way Product table is in Sharepoint
Drrickryp Super User 2024 Season 1 on 13 Feb 2023 at 17:21:18

Like (1)

Report

Re: Creating a Lookup columns in Sharepoint list with excel file

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