Answered

How to filter form based on the combobox filter

(0) Share

Report

Posted on by anshenterprice

Hi Team,
Source Data-

TableA
StockName
TataMotors
Infosys
Relience
IndianOil
ITC
TATaSteel

Table B
StockName	ExternalValue	InternalValue	Date
TataMotors	204	null	11/1/2022
Infosys	230	null	11/1/2022
Relience	450	null	11/1/2022

Requirement-

I have created a form like

if user selected tatamotors from the combox then he may add the value in internal value input field and once the hit to submit button then it will update that perticuler field.

second option'- if user select ITC from the combox then it will filter the form and use will see the null values for both internal and external logically because we dont have those stock in table B but user can add the values in internal and external field

Date	11/1/2022

StockName	Comboxfilter

ExternalValue	204
InternalValue	Text Input field

	Submit button

Thanks

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

v-dezhili-msft Microsoft Employee on at

Like (0)

Report
Hi @anshenterprice ,
Do you want to update them to Tb2 when there is no option for Tb1 in Tb2?
You can create a form to filter Tb2 with the options of Tb1 on the item property of the form, and set the default mode of the form to new if the query is empty, otherwise to edit, so that you can modify the value of the table in edit mode.
I did a test for your reference, my data source is in Sharepoint.
First(Filter(list2,Title=ComboBox1.Selected.Value)) If(IsBlank(First(Filter(list2,Title=ComboBox1.Selected.Value))),FormMode.New,FormMode.Edit) If(IsBlank(First(Filter(list2,Title=ComboBox1.Selected.Value))),ComboBox1.Selected.Value,Parent.Default)
Best Regards,
Dezhi

Was this reply helpful? Yes No
anshenterprice 27 on at

Like (0)

Report

@v-dezhili-msft
Can you please tell me the form datasource property that should be list2?

Was this reply helpful? Yes No