Answered

Trying to use Data Source to Control Button if possible?

(0) Share

Report

Posted on by BigDaddy

I' am trying to use the If statement to control the default property of a toggle. I feel like im close im just missing something. I'am using Microsoft List as my data source, I started with;

LookUp('MANC Plant Dashboard Controls', ID=1, {Control: "1"});
Set(varReclaimToggle,true);
LookUp('MANC Plant Dashboard Controls', ID=1, {Control: "0"});
Set(varReclaimToggle,false);

I have then been trying to figure out how to use the "IF" statement just to read "Control value" on the ID row. So my formulas got real bizarre real fast trying to make it work.

If('MANC Plant Dashboard Controls', ID=1, {Control.value="1"}),
Set(varReclaimToggle,true),Set(varReclaimToggle,false);

My global variable is on the default property on the toggle switch, This formula I' am running off a timer so every so often it reached out to the data source to see the current status of the control value to make it either on or off. Just don't know how to correctly code what I want it to do. Any help would be appreciated. Thanks.

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (2)

Sort by

BigDaddy 21 on at

Like
a
(0)

Report
Copy link

Link copied!

First picture is the list im grabbing from. The lower picture on the left is my timer end property and the lower right picture is my Default property on the toggle button.

Was this reply helpful? Yes No
BigDaddy 21 on at

Like
a
(0)

Report
Copy link

Link copied!

I' m trying to just change the global variable now but cant get the value from the value in the control column to change the variable;

Set(varReclaimToggle,LookUp('MANC Plant Dashboard Controls', ID="1", Control))

Was this reply helpful? Yes No
Verified answer

R Bakker 725 on at

Like
a
(0)

Report
Copy link

Link copied!

Would this work directly in the default value of the toggle?

LookUp('MANC Plant Dashboard Controls', ID=1,Control)="1"

Was this reply helpful? Yes No
Verified answer

BigDaddy 21 on at

Like
a
(0)

Report
Copy link

Link copied!

I was finally able to get it to work using;

LookUp('MANC Plant Dashboard Controls',ID=1,Control) on the Default Property on the toggle. I just changed from using "0" and "1"s to using "true" and "false" values on the data source. I appreciate your reply though. Thanks.

Was this reply helpful? Yes No