You’re offline. This is a read only version of the page.
Hi Experts!
In Power apps form, my source list is from SharePoint List . I added a drop down name called Tasks Drop down, I connected with my source data.
In that drop down list how to manually add a value as "Other".
Thanks in advance,
Pooja-B.
Please try the following (make sure List, Column names are correct),
Share
Report
All responses (
Answers (
Ungroup(
Table(
{DDOptions: RenameColumns(ShowColumns(Filter('Task List',User().Email in AssignedTo.Email && Customer.Value=DataCardValue1.Selected.Value), "AssignedTasks"), "AssignedTasks", "Value")},
{DDOptions: ["Other"]}
),
"DDOptions"
)
Please remember to give a đź‘Ť and accept my solution as it will help others in the future.
In Employee List Column fields
1) Customer - Look up (Customer List).
Customer SharePoint list only have single column which have distinct customer names
2) Assigned Tasks - Look up (Task List).
In Task List SharePoint List Column Fields
1) Manager Name - Person Data type
2) Customer - Look up Data type from (Customer List)
3) Assigned Tasks - Single Line of Text
4) Assigned To - Person Field.
In Power Apps Edit Form,
Customer data card value => source data is Employee SharePoint List,
Column = Customer, Data type Look Up Column.
Assigned Tasks drop down = source data is "Task List" Share Point List,
Column = Assigned Task, Data type Single Line of Text.
For Example,
In Task List,
In customer data card value , when an Employee 1 select Customer 1
In assigned task drop down it list "Employee 1 assigned task for the particular customer + Other option"
If you need any further clarification, kindly let me know @CNT
Thanks
Pooja-B
@B-Pooja Can you share in detail the contents of the Filter (how many columns, their names, datatypes etc.,) and the column that you want to be displayed in the DropDown.
Hi @CNT ,
I have customer data card value and Assigned task drop down value.
My scenario is,
If customer selects a value , the assigned task drop down value lists based on
1) Selected Customer value related
2) Current user's assigned task
3) also shows "other" option.
How to narrowing into 1 column
can you help me to resolve this issue @CNT
Thanks
@B-Pooja If the following formula returns a multi-column table, try narrowing it down to one column.
Filter('SharePoint List',User().Email in AssignedTo.Email &&
Customer.Value=DataCardValue1.Selected.Value)
Hi @CNT ,
Thank you for your Quick response,
I have an issue in this coding.
Ungroup(
Table(
{DDOptions: Filter('SharePoint List',User().Email in AssignedTo.Email &&
Customer.Value=DataCardValue1.Selected.Value)},
{DDOptions: ["Other"]}
),
"DDOptions"
)
When I run this app, it shows blank value, Not Showing "Other" option.
Thanks,
Pooja-B
Please try the following,
Ungroup(
Table(
{DDOptions: Choices(yourSPList.columnName)},
{DDOptions: ["Other"]}
),
"DDOptions"
)You can also look at this excellent article from @mdevaney for more info,
https://www.matthewdevaney.com/create-a-dropdown-with-an-other-option-in-power-apps/
Please remember to give a đź‘Ť and accept my solution as it will help others in the future.
#1
WarrenBelz
146,651
Most Valuable Professional
#2
RandyHayes
76,287
Super User 2024 Season 1
#3
Pstork1
65,997
Most Valuable Professional
