SharePointIntegration Customized Form DataCard not visible in view or edit item

(0) Share

Report

Posted on by Shannon503

I'm using SharePointIntegration Customized Form.

I have a single text column called 'Other Conference Name'

In the Card's Visible property I have Combobox.Selected.Title = "Other" (the 'Conference Name' combobox is really the SP title column)

In the Update property I have DataCardValue2.Text

In the Default I have ThisItem.'Other Conference Name'

When I add a new item the form works (hides the card when Combobox <> "Other" and is visible when it does) and captures the data in the SP list.

When I click to view or edit the item this field is hidden even though the Combobox = "Other" in the view/edit form.

What am I missing or wrong?

Categories:

Building Power Apps

I have the same question (0)

All responses (11)

Answers (0)

Sort by

WarrenBelz 155,279 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
Hi @Shannon503 ,

You are missing nothing technically, but renaming columns (not a good practice for many reasons) may be the issue here - have you tried

Combobox.Selected.'Conference Name' = "Other"

Please click Accept as solution 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 giving it Thumbs Up.

MVP (Business Applications) Visit my blog Practical Power Apps

Was this reply helpful? Yes No
Shannon503 22 on at

Like (0)

Report
Copy link

Link copied!

@WarrenBelz
Yea, 'Conference Name' doesn't work, it doesn't even show up as an option. Renaming the title column was a specific request, mainly for users.

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

Like (0)

Report
Copy link

Link copied!
@Shannon503 ,

I was referring to renaming columns in general and for this reason, I do not use the Title column at all (but that does not help you).

Your issue is that your code is correct (there is no alternative I can give you - but what I posted was worth a try) - the only relevant property here is the Visible of the Data Card and

Combobox.Selected.Title = "Other"

is correct. An interesting test however would be to put this code on a Label outside the Form and see if you get true/false according to the choice made.

Was this reply helpful? Yes No
zuurg 546 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Shouldn't it be Combobox.Selected.Value="Other"? The combobox should be bound to the field, so all we're looking for here is a match on the selected item in the list, which should be the .Value

Was this reply helpful? Yes No
Shannon503 22 on at

Like (0)

Report
Copy link

Link copied!

@zuurg I tried that, but it errors out.
Interesting, the same logic applies to a choice card I have. When "presenter" is selected the datacard a visible (DataCardValue8.Selected.Value = "Presenter"). The value card holds it's visibility and value in the view and edit item. But for some reason same is not true for Combobox.
@WarrenBelz I place a label outside the form with the same code. Interestingly, all the other conferences that are selected retain their value in the view/edit, however, the "other" section does not.
When I edit the form and reselect "Other', it shows as true. It saves whatever changes I have made back to the SP list, but when I go to view it again, still no show and displays false as in above example.

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

Like (0)

Report
Copy link

Link copied!

@Shannon503 ,

OK we have established that the issue is the logic of the Combo Box, not the Visible of the Data Card (which is simply doing as it is told). So the next question is what are Items of the Combo Box and what field is being displayed in it.

@zuurg , Please have a read of this blog of mine and familiarise yourself with control outputs - .Value only applies to Choice and Lookup columns (and possibly Distinct filters with a recent change). When the Items are based on a List/Field, the output is the field name displayed.

Was this reply helpful? Yes No
Shannon503 22 on at

Like (0)

Report
Copy link

Link copied!

Hi @WarrenBelz
The items of the Combobox are from a SP list containing a list of current conferences ('Conference List') for users to select. The field being displayed is the 'Title' field.

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

Like (0)

Report
Copy link

Link copied!
@Shannon503 ,

OK - now I have eliminated all I things I thought might be affecting this, we seem to be left with this: -

Your Combo Box contains the entire Table of 'Conference List' and is displaying the Title field, which you have renamed to 'Conference Name'.

I assume Other is one of 'Conference Name' / Title records in this List and the number of records in this list is under your Delegation limit.

Despite logic suggesting otherwise, the formula ComboBox.Selected.Title = "Other" does not return a true result when Other is selected in the Combo Box.

Can you please confirm all of that is true.

Was this reply helpful? Yes No
Shannon503 22 on at

Like (0)

Report
Copy link

Link copied!
@WarrenBelz
Yes. I have a SP list called 'Conference List' with a list of current conferences that users can select from. Note the Title field is called ‘Name’. I have tested out both formulas, which unfortunately produce the same result.
ComboBox1.Selected.Name = "Other"
ComboBox1.Selected.Title = "Other"
Correct. I only have 12 items in the 'Conference List' and 'Other' is the last item.
It returns true ONLY on a New item and captures the data to a SP list called ‘Conference Requests.' However, it does not return true when you view/edit the item.

'Conference Requests' is where all the data is being saved. This is the SP list I used to create the SharePoint Integration Customized form.

Was this reply helpful? Yes No
Shannon503 22 on at

Like (0)

Report
Copy link

Link copied!

@WarrenBelz
So I take it this doesn't work. I know if this was a dropdown box the visibility properties do work. If I shift to a different plan/solution, and change the Combobox to the standard SP Column lookup field (choice/dropdown), then how do I auto populate the other fields (location, date, charge no.)?

The whole point is when a user selects a value from the 'Conference List' dropdown the other fields populate. That way we don't get varying degrees of spelling and data. However, there will always be a random conference that is not include on the list, hence the "Other" selection, that will allow a user to type in the information to these fields (location, date, etc.)

I tried using similar logic and replacing Comobox with DataCardValue, but it's erroring out. I'm sure I'm not writing this correctly. I'm on a deadline and need to figure this out and I'm trying to learn this program on top of it all.

If(DataCardValue2.Selected.Value <> "Other",
Coalesce(DataCardValue2.Selected.Value = ThisItem.'Conference Name: Conference Location',
ThisItem.'Conference Location'
)
)

Was this reply helpful? Yes No