Answered

How to make the field with restrict drawdown list in 'Edit Form' model

(0) Share

Report

Posted on by cnzhangjia

Hello Power Apps Experts,

I create an app for end user to input something, and the data will be kept in Share Point list. Below is a simplified model to explain the issue I met.

In above database, the field 'Function' & 'Responsible' type is 'Single Line of Text', but the Responsible value is a dropdown list filter by Function in Power Apps page by other database as below when creating a new item in sharepoint list.

So this app is working well when create a new item, but the issue happened if end user want to modify the Function & Responsible.

For the edit, I am using 'edit form' function, then the type of 'function' & 'Responsible' field is 'Single line of text' as original setting in SP list.

I tried to change this 2 field into 'Choice', but I can only add all responsible name as option, which means it can't be filtered by functions.

Is there any way that that the 'Responsible' field can still be filter by 'Function' field under 'Edit Form' Model?

Best Regards,

Zhang Jia

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (3)

Sort by

Verified answer

v-mengmli-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @cnzhangjia ,

Do you want to replace text box with drop down and restrict responsible dropdown list according to function drop down?
Please try this:
1.Function drop down:
Items:Distinct(ListName,Function) Default:Parent.Default
2.Responsible drop down:
Items:Filter(ListName,Function=FunctionDropDown.Selected.Value,Responsible) Default:Parent.Default

Best regards,
Rimmon

Was this reply helpful? Yes No
Verified answer

cnzhangjia 42 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi, Rimmon,

Thank you for your reply.

I test your formula, the 'Function' one is working well, but the 'Responsible' met some issue.
Filter(Function_Responsible_Test,Function=FunctionDropDown.Selected.Value,Responsible)
This is a warning as below
The choice items still show all the name which I set in Sharepoint list, so the filter by Function is not working

Could you please advice how to resolve this issue?

Was this reply helpful? Yes No
Verified answer

v-mengmli-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @cnzhangjia ,

Please modify the formula and Fields property of combo box:
Filter(Function_Responsible_Test,Function=FunctionDropDown.Selected.Value)

Best regards,
Rimmon

Was this reply helpful? Yes No
cnzhangjia 42 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi, Rimmon,

Thank you for your great support. It works now.

Have a good day!

Best Regards,
Zhang Jia

Was this reply helpful? Yes No