Using A Sharepoint List to Disable Pages

(0) Share

Report

Posted on by LF-14012120-0

Greetings,

I am trying to build a fairly unique circumstances, but keep running into problems, and hope that this community can help.

I have a page of my PowerApps with Toggle Switches that turns on and off (Yes/No Field) in a SharePoint List. That part works great, when I turn on or off the toggle, it updates the Sharepoint List.

Now, I am trying to use 'IF/THEN' type statements to turn 'DisplayMode' and/or 'Visible' to True/False based on those toggle switches.

Two problems seem to exist:

1) The 'Title' Label and the 'Yes/No' Field are different columns, so I'm not sure how to say, "IF Location1 (Title) is marked 'Yes' (Yes/No Field), THEN ..."

2) I am trying to use the IF/THEN Statement outside of a Gallery or Form, so 'ThisItem' doesn't seem to be a viable option.

The end goal is that I can turn on or off a toggle for a Location, and it will display that location in the Main Menu Page, and a few Internal Buttons that will link to that screen.

Thoughts?

Larry French

Categories:

General topics

I have the same question (0)

All responses (3)

Answers (0)

Sort by

WarrenBelz 155,838 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @LF-14012120-0,

Any Visible property is simply the toggle value (both are Boolean values and therefore translate directly). So if the Visible of a Control is
Toggle1.Value

then it is visible when the Toggle is on and not visible when the toggle is off. If the toggle is outside the gallery, it will affect the same control in every record, but only the relevant record if the Toggle is in the Gallery.

For DisplayMode, using Edit and View as the options

If( Toggle1.Value, DisplayMode.Edit, DisplayMode.View )

Is this what you are trying to do ?

Please ✅ Does this answer your question if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider answering Yes to Was this reply helpful? or give it a Like ♥
Visit my blog Practical Power Apps LinkedIn

Was this reply helpful? Yes No
Suggested answer

BriannaReddick 25 on at

Like
a
(0)

Report
Copy link

Link copied!

I think using a lookup() function may assist with your problem. Especially when working outside of a gallery or form, you will need a way to reference the specific record you want the Yes/No to come from. If you expect more than one record to come back you would use a Filter() expression instead but I don't think that is what you would expect in this scenario.

Here is the link to how documentation on using LookUp : https://learn.microsoft.com/en-us/power-platform/power-fx/reference/function-filter-lookup

Based on the size of your list you could also consider using a collection and on change of your toggle button add or remove that item from the collection then use that collection as the menu listing, this would be faster than always looking up records from the datasource.

Was this reply helpful? Yes No
WarrenBelz 155,838 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @LF-14012120-0,

A quick follow-up to see if you received the answer you were looking for. Happy to assist further if not.

Please ✅ Does this answer your question if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider answering Yes to Was this reply helpful? or give it a Like ♥
Visit my blog Practical Power Apps LinkedIn

Was this reply helpful? Yes No