web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps Random text from Excel...

Power Apps

Unanswered

Random text from Excel column at push of the button

(0) Share

Report

Report

Posted on by streamg88

3

Hello everyone,

im new in PowerApps so I need little help.

I want to make an easy App that on the press of the button will give me a random text in "Text Label" from first Excel Column1 and after it should show description of this same word from column1 that is described in second column.

I connected my Excel table to a data in PowerApps (picture in attachment). Name of the table is "Table1" and first column name is "Word" and second column is "Description".

Tried with help of an chatGPT but unsuccessfully and it says CountRows are not working

On Button --> Set(selectedValue, Lookup(Table1, Rand() * CountRows(Table1), Word))

On Text Labe --> selectedValue

I tried with Set(varName,"Marko") and that works with one value.

Thank you,

Best regards

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (0)

Hassan_SZ_365 542 on at

Like (1)

Report
Copy link

Link copied!
Hi @streamg88 ,
To display a random text and its corresponding description from Excel columns on the press of a button in PowerApps:
Button's OnSelect Property:

Set(selectedValue, LookUp(Table1, Rand() * CountRows(Table1), Word))

This formula sets the selectedValue variable to a random value from the "Word" column in your Excel table.
Text Label's Text Property:

selectedValue & ": " & LookUp(Table1, Word = selectedValue, Description)

This formula displays the selected random value along with its corresponding description from the "Description" column.
Ensure that the variable selectedValue is global so that both the button and the text label can access it.

Best Regards,
Hassn Raza

Was this reply helpful? Yes No
streamg88 3 on at

Like (0)

Report
Copy link

Link copied!

Thank you for fast reply.

I tried it now, and I get this error on Text Label "Error. Error while trying to retrieve data from the network." and it says CountRows are not supported with yellow triangle on the button. Im actually from Europe so i needed to change colon to semi-colon.

How do you set selectedValue as global? Maybe this is problem

It's a bit weird, because if I put "Combobox" it show me the data from my excel table so i dont think the problem is at my network.

Was this reply helpful? Yes No

Join the conversation