Answered

disable a button through dropdown box from a field in SharePoint list

(0) Share

Report

Posted on by WhitewolfPA123

I want to disable a "View Docs" button when the Form selected from the dropdown box has the field 'Show Form' set to No in a choice column.

I have tried using a ForAll to loop through a collection of the SP List,

At this point, I am not really sure of the best way to access the data in the SP List to achieve the results I am looking for. I am currently taking some courses in Power Apps, but they have not discussed how to do something similar to this yet.

I am also trying to filter the collection and then access the values of the collection, but I am having trouble with that as well. The collection has three string values, but when I try to use them in a condition (e.g. If(DisableFormCollect.ShowData = "No", it says it is a table and there is no Value property.

Thanks,

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (1)

Verified answer

PTBBSolutions 691 on at

Like (0)

Report
Copy link

Link copied!
Hi @WhitewolfPA123 ,

Could you please try this:
If( YourDropdown.Selected.Choices.Value = "No", Disabled, Edit )

Was this reply helpful? Yes No
WhitewolfPA123 8 on at

Like (0)

Report
Copy link

Link copied!

Well, It did not work, but I may not understand what is happening. So, just as a rehash.

With the SharePoint list that i have (shown above), I am putting the "Form Names" column in the drop down.
As in the image, there is a View Docs button that I want to disable if the Show Data column (Choice) is set to "No".

I have two problems:
1. I don't know where the logic should go to test for the "Show Data" column equal to "No"
2. I don't know how to access the data for the "Show Data" column in the Share Point list.

I can see the data both in the data source and in the collections, but having a devil of a time trying to compare the data to anything.

So far, i have tried to access the "Show Data" in various iterations of a collection, but it keeps being referred to as a table and not a "Text" or "String".

I last question, for now, is what does the "Choices" in your code stand for? I don't see anything in the intellisense for it so i assume I am suppose to substitute something for it?

Sorry, so noob. Working to change that... 🙂

Thanks

Was this reply helpful? Yes No
PTBBSolutions 691 on at

Like (0)

Report
Copy link

Link copied!

Hi @WhitewolfPA123 ,

We are all here to learn 🙂

To test, you can throw a label on your screen and adjust it's text property to [DropDownControlName].'Show Data'.Value - this should change the value in your label as you change the selection in the drop down.

The snippet I gave you earlier you go on your View Docs button's DisplayMode property.

The Choices in my code represents my SP choices column (the equivalent of yours "Show Data") - sorry for this.

Let me know if it works 🙂

Was this reply helpful? Yes No
WhitewolfPA123 8 on at

Like (0)

Report
Copy link

Link copied!

Maybe I have messed up from the start, what data source do I put in the dropdown in order to be able to see the 'Show Data' choice column in my SharePoint list. I don't see it in the Intellisense and get an error when I try to add it to the text box.

This may be my root problem...

Thanks for your patience and help.

Was this reply helpful? Yes No
PTBBSolutions 691 on at

Like (0)

Report
Copy link

Link copied!

In the dropdown, in the Items property you put your SharePoint list name. After that in the Value property of the same dropdown, you put your display column (in your case it will be "Form Names" or if you are using the default column, it will be called Title - please note that even you are using the Title column from SP, even if you have renamed it, PowerApps will still see the old name.) After that you put my code in you button OnDisplay property.

One clarification - is your SP column a Choice column or a Yes/No Column?

Was this reply helpful? Yes No
WhitewolfPA123 8 on at

Like (0)

Report
Copy link

Link copied!

Thanks, I was all turned around. All the tutorials I have taken have not covered this, plus I was actually using a combo box instead of a dropdown. Once I got that straight and looked at your first answer (in conjunction with your explanations) it made perfect sense. So, I accepted your first answer, and hopefully people will read the explanations to understand it. It works perfectly!!!

Was this reply helpful? Yes No