Skip to main content

Notifications

Power Apps - Building Power Apps
Suggested answer

Ability- to add New Entry in the Drop Down field

Posted on by 172
Hi,
 
I've a drop down field, were I added below code to Items property. This is connected to SharePoint List
Sort( Distinct(SharePointListName,Title),Value)
Whenever I have a new name to add, I would prefer to add this from the PowerApps form and not to the SharePoint List.
 
Any new names added through the PowerApps form should also get update to my SharePoint List.
 
Can someone please advise. Thanks!
  • Prem4253 Profile Picture
    Prem4253 172 on at
    Ability- to add New Entry in the Drop Down field
    I already have a Submit button which says:
    SubmitForm(FormInspection)
    I need to add a + sign in the form, which will add a new item into the Combo box within the form itself. I do not want users to add new record into SharePoint List, which will than automatically reflect in the form.
     
    I need this feature from the form.
     
    My Combo Box is named cbCustomerName
     
  • Suggested answer
    mmbr1606 Profile Picture
    mmbr1606 9,998 on at
    Ability- to add New Entry in the Drop Down field
    hey
     
    you can try this in a onselect of a button for example:
    If(
        Not IsBlank(TextInputControl.Text) && IsEmpty(Filter(SharePointListName, Title = TextInputControl.Text)),
        Patch(
            SharePointListName,
            Defaults(SharePointListName),
            {Title: TextInputControl.Text}
        );
        Refresh(SharePointListName);
    )
    
    if my answer helped please mark as verified answer,
     
     
    cheers

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

November 2024 Newsletter…

November 2024 Community Newsletter…

Community Update Oct 28…

Power Platform Community Update…

Tuesday Tip #7 Community Profile Tips…

Welcome to a brand new series, Tuesday Tips…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 143,591

#2
RandyHayes Profile Picture

RandyHayes 76,308

#3
Pstork1 Profile Picture

Pstork1 64,090

Leaderboard