Showing results for 
Search instead for 
Did you mean: 
Frequent Visitor

Setting button text from Datatable source

Hi all, 


I'm trying to set the text of a button from a certain cell from a datatable. The datatable and the button are NOT on the same screen (if this is revelant).

I have a Data table named WCSINFO as such :




And I want my Button to have the text from the "Cellule1" column first row. I'm gonna have as many button as there are cells in the table. 

So I did a Lookup function like this :


LookUp(WCSINFO,Matos="EQUIPMT 1",Cellule1)


in the text field but it does not work. I get the error :


The formula contains 'ParenClose' where 'Error' is expected


I've also tried to set a variable to use in the text field But I canno't manage to make it work.


Thank you 



Frequent Visitor

Ok I found a solution.

Since the table was fetch from a excel workbook, I had to call the table from the workbook and not the one that I added in the screen. 
So I get something like this :


LookUp(Tracking_des_colis__1;Column2="EQUIPMT 1";Column3)


And this works for me.

Helpful resources

Power Apps News & Annoucements carousel

Power Apps News & Announcements

Keep up to date with current events and community announcements in the Power Apps community.

Community Call Conversations

Introducing the Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Apps Community Blog Carousel

Power Apps Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Top Kudoed Authors
Users online (4,013)