Working with variables in PowerApps

(0) Share

Report

Posted on by JamesM

271

My next challange is how to work with variables. For instance.

- Create a Data Source that gets a count of tasks from the database. Let's say I have 10 tasks.

- Be able to create a text box on the main form that displays 'You have 10 tasks' but the property is really 'You have <variable> tasks' displayed. I know that we're supposed to use ContextVariables I think? But I haven't worked out where to actually

1. Obtain that 'value' from my data source (I can create a data source and use it as the source for a gallery or a chart but not a text box?)

2. WHere to actually write out that I want to pass that value to a variable

3. Structure the text box to include that value/variable (as mentioned, "I have <n> tasks"

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (2)

Verified answer

AndyPennell on at

Like (0)

Report
Set the Text property to be something like

"I have " & CountRows(datasource) & " tasks"

Was this reply helpful? Yes No
Verified answer

SinanE 174 on at

Like (0)

Report

Hi James, you could do something like this:

In the Text property of the text box, enter this:

Concatenate("I have ", Text(CountRows(MyList)), " tasks")

where MyList is your data source name

Was this reply helpful? Yes No
JamesM 271 on at

Like (0)

Report

Hey thanks! Sounds so simple haha. I am frustrated by being so comfortable with C# but such a newbie when it comes to PowerApps! 😕 So your example is good for returning a count of rows as the value, but what if I wanted to get a text value from that data source? E.g. the task name? So the data set was

Tasks
-------
Task A
Task B
Task C

I want my text box to display "You've selected: Task B" (You've selected: <n>")

Was this reply helpful? Yes No
JamesM 271 on at

Like (0)

Report

Apologies SinanE I posted my reply before I saw yours. Thank you 🙂 I'll try that out.

Was this reply helpful? Yes No