Answered

Unexpected Characters

(0) Share

Report

Posted on by Incident-Manage

I am trying to enable a combobox drop down on my custom form to pull from the choices on my Sharepoint list called Major Incident Dashboard - Test, the combo box is linked to a lookup column on my list called Root Cause Secondary. I want the choices to filter based off a column on the Root Cause Secondary list called Root Cause. I wrote the code below and I have been around the block few times when it comes to power apps but I am getting the error seen in the screenshot for unexpeceted characters. Any ideas how to correct this.

Filter{ 
 Choices('Major Incident Dashboard - Test'.'Root Cause Secondary');
 Value in Filter ('Root Cause Secondary', DataCardValue15.Selected.Value in RootCause)
}

Categories:

Building Power Apps

I have the same question (0)

All responses (10)

Answers (3)

Verified answer

WarrenBelz 153,084 Most Valuable Professional on at

Like (0)

Report
Hi @Incident-Manage ,
Apart from having curly brackets {} on your filter instead of normal (), you also need to specify the field in the other table it needs to match (correct of my guess it wrong). You also have a mix of separators ; and , I do not know your location, but use the one for your Region

Filter( Choices('Major Incident Dashboard - Test'.'Root Cause Secondary'); Value in Filter( 'Root Cause Secondary'; DataCardValue15.Selected.Value in RootCause ).'Root Cause Secondary' )

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
Incident-Manage 76 on at

Like (0)

Report

Hi @WarrenBelz This worked thanks for your assistance.

Was this reply helpful? Yes No
Incident-Manage 76 on at

Like (0)

Report

@WarrenBelz @Question as I’m working on this today I’m noticing that some options where I have things available under multiple options such as for the option Caused by Change it shows up 4 times in my filter

Was this reply helpful? Yes No
WarrenBelz 153,084 Most Valuable Professional on at

Like (0)

Report
Hi @Incident-Manage ,

I cannot see your data, but you must also have duplicates in your choices - you could do this

Distinct( Filter( Choices('Major Incident Dashboard - Test'.'Root Cause Secondary'); Value in Filter( 'Root Cause Secondary'; DataCardValue15.Selected.Value in RootCause ).'Root Cause Secondary' ), Value )

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
Incident-Manage 76 on at

Like (0)

Report
@WarrenBelz So when using it I am now getting no options in my drop down menu. I made some slight changes to what you provided to what worked with my data previously. What I fed into powerapps is below.

Distinct( Filter( Choices('Major Incident Dashboard - Test'.'Root Cause Secondary'), Value in Filter('Root Cause Secondary', DataCardValue15.Selected.Value in RootCause).'Title'),Value )

Was this reply helpful? Yes No
Verified answer

WarrenBelz 153,084 Most Valuable Professional on at

Like (0)

Report
@Incident-Manage ,

Probably because the output is now Result instead of Value

RenameColumns( Distinct( Filter( Choices('Major Incident Dashboard - Test'.'Root Cause Secondary'), Value in Filter( 'Root Cause Secondary', DataCardValue15.Selected.Value in RootCause ).'Title' ), Value ), "Result", "Value" )

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
Incident-Manage 76 on at

Like (0)

Report

@WarrenBelz this works partially I get the options but when I test it the selection doesn’t save to it’s designated column.

Was this reply helpful? Yes No
WarrenBelz 153,084 Most Valuable Professional on at

Like (0)

Report

Hi @Incident-Manage ,

What is the name and type of field you are updating and what is the current Update of the Data Card

Was this reply helpful? Yes No
Incident-Manage 76 on at

Like (0)

Report

@WarrenBelz The name of the field is Root Cause Secondary which is what I pass in the choices option of the code so Power Apps reads it as 'Major Incident Dashboard - Test'.'Root Cause Secondary'. and it is a lookup. Update is currently set to DataCardValue16.Selected.

Was this reply helpful? Yes No
Verified answer

WarrenBelz 153,084 Most Valuable Professional on at

Like (0)

Report
@Incident-Manage ,

Yep - lookup columns will cause you a lot of unwanted (and unnecessary) grief and I have never needed to use them. You need to get the Id back, which is the ID of the item in the other list being looked up, so the Update of the Data Card should be

{ Value: DataCardValue16.Selected.Value, Id: Lookup( 'Root Cause Secondary', RootCause = DataCardValue16.Selected.Value ).ID }

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