Answered

Filter an edit Form on results from a Combo box used on another screen not working

(0) Share

Report

Posted on by matty2000

Hi Everyone,

i am fairly new to Power Apps and having probably a simple problem with one an App i am putting together for a SharePoint List.

I have build most parts of the App but having trouble with the Edit form as the Item property is not working as i need it too. I would like the Edit form to display my fields that are connected to the SharePoint list from the selection in a Combo box on another screen. the below is what i have come up with and this does not accept as a valid formula:

Filter('TML Stocklist','Part Number'=PartNumberCombo.Selected.Value)

I have also tried:

Filter('TML Stocklist','Part Number'=PartNumberCombo.Selected.Result)

It feels like it is something simple so please help if you can and advise upon what Filter i should use to display Items it is the edit form that match a Combo box selection.

Thanks in advance,

Matty2000

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (2)

Sunil Kumar Pashikanti 1,077 Moderator on at

Like (0)

Report
Copy link

Link copied!
Where are you applying the formula?

Checklist for verification:

1) Did you set the Edit form DataSource property to same SharePoint list - TML Stocklist?

2) The PartNumberCombo is correctly connected to SharePoint list - TML Stocklist (items property set to TML STocklist).

3) Edit Form - Default property - Filter function

Filter('TML Stocklist', 'Part Number' = PartNumberCombo.Selected.Value)

4) Make sure the field name 'Part Number' match the actual column name in SharePoint list.

5) Double check the column names and data types.

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.

Was this reply helpful? Yes No
WarrenBelz 154,621 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hi @matty2000 ,

What is the Items of PartNumberCombo and what type of field is 'Part Number'

Was this reply helpful? Yes No
matty2000 42 on at

Like (0)

Report
Copy link

Link copied!
Hi WarrenBelz,

Thanks again for the fast response and checklist completed below:
Checklist for verification:
Did you set the Edit form DataSource property to same SharePoint list - TML Stocklist? Yes checked that.

The PartNumberCombo is correctly connected to SharePoint list - TML Stocklist (items property set to TML STocklist). Yes and the combo box works well with the sort of a list connected to it already.

Sort(Distinct('TML Stocklist','Part Number'),Value,SortOrder.Ascending)

Edit Form - Default property - Filter function

Filter('TML Stocklist', 'Part Number' = PartNumberCombo.Selected.Value)

The error I get is Record not recongised
Make sure the field name 'Part Number' match the actual column name in SharePoint list.
Checked and I type the formula in and it is populated with the name from the SharePoint list.
Double check the column names and data types.
These are all correct as other combo boxes work as just the Filter on the Edit Form named “EditFormTMLStocklist”.

The Items in the PartNumberCombo are alphanumeric (Letters and Numbers) and the Part Number field is a Single line text in SharePoint (Alphanumeric).

There was no change to the error as you can see by my screen shot about also.

Thanks in advance for you looking at my issue.

Was this reply helpful? Yes No
Verified answer

Sunil Kumar Pashikanti 1,077 Moderator on at

Like (0)

Report
Copy link

Link copied!

Hi @matty2000 ,

The error message is - The error I get is Record not recongised.

The error message “Expected record value” in Power Apps typically occurs when there is a mismatch between the expected data type and the actual data being processed.

Can you change your filter like below for your edit form:

First(Filter('TML Stocklist', 'Part Number' = PartNumberCombo.Selected.Value))

Use First() function to provide a single record, instead of unknown collection. The edit form is expecting only a single record.

or use

LookUp( 'TML Stocklist', 'Part Number' = PartNumberCombo.Selected.Value )

The LookUp function is used to find the first record in a table that matches a specified formula. It allows you to search for a single record based on one or more criteria.

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.

Was this reply helpful? Yes No
Verified answer

WarrenBelz 154,621 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!
Hi @matty2000 ,

Your Form Item should be

LookUp( 'TML Stocklist', 'Part Number' = PartNumberCombo.Selected.Value )

Was this reply helpful? Yes No
matty2000 42 on at

Like (1)

Report
Copy link

Link copied!

@SunilPashikanti @WarrenBelz Thanks again as your help is muchly appreciated.

Was this reply helpful? Yes No