I have a form with a ton of fields (50) whose data source is an excel Table.
I'd like to change the Visible property of each DataCard to =IF(card.DataField=varDynamicName,true,false)
Seems simple, but I can't figure out what to replace card.DataField with.
Card is obviously not the right parameter. I tried DisplayName and ThisItem. I really just need the Field Name.
The varDynamicName is text, but this is all an oversimplification to make the question easier to follow.
Solved! Go to Solution.
There is a trick to select all. You just need to change the form from vertical to horizontal then hit the Undo button. You can then edit all the fields properties all at once. Saved me countless hours.
I suppose its not really the DataCard Item properties that I want. Its the fields property. For instance, in the datacard item I can get the field name property I want by using Parent.DisplayName, but since I want to reference it at the Parent Level I cant use "Parent".
GOT IT: The answer is Self.DisplayName! I wouldn't have been able to figure it out if you hadn't sent me down the thought path though.
It's going to be one of the properties of the card you are referencing; In the example below, if I wanted to set the visible on the field in Text_DataCard1, I would do this:
If(varDynamicText in DataCardValue6, true, false)
That value is only for the one Card. I would need to manually change it for every card. I would just type the column in manually for each card if I had to do it that way. I need a formula that works like ThisItem.DataField. That way I can do, Select All -> Visible->Paste and have it work on all ~100 fields.
Cards don't work that way. Unfortunately you do have to manually change each one.
Each field in a form has it's own set of DataCard items and you can't even select them all because each data card is separate.
There is a trick to select all. You just need to change the form from vertical to horizontal then hit the Undo button. You can then edit all the fields properties all at once. Saved me countless hours.
I suppose its not really the DataCard Item properties that I want. Its the fields property. For instance, in the datacard item I can get the field name property I want by using Parent.DisplayName, but since I want to reference it at the Parent Level I cant use "Parent".
GOT IT: The answer is Self.DisplayName! I wouldn't have been able to figure it out if you hadn't sent me down the thought path though.
I might have to try your trick for selecting all the fields. Hadn't seen that before
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.
Power Platform release plan for the 2022 release wave 2 describes all new features releasing from October 2022 through March 2023.
User | Count |
---|---|
200 | |
97 | |
56 | |
51 | |
41 |
User | Count |
---|---|
264 | |
157 | |
83 | |
80 | |
56 |