cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Alikecheese
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 :

 

Alikecheese_0-1663930663513.png

 

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 

 

 

1 REPLY 1
Alikecheese
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

Announcements
Power Apps News & Annoucements carousel

Power Apps News & Announcements

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

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 (3,322)