Skip to main content
Community site session details

Community site session details

Session Id : eGm38KFNJiwGKYQimyNEwB
Power Apps - Building Power Apps
Answered

Dynamically add item to lookup list

Like (0) ShareShare
ReportReport
Posted on 14 Sep 2022 12:09:23 by 1,360

From a SharePointIntegration form pointing at a SharePoint list my form contains lookups.

When the user opens the form and clicks any of the drop downs, the dropdown may not have the selection they are looking for.
Is there a way to add a lookup value dynamically without having to leave the form and manually add the item to the lookup list?

golfnutt82_0-1663157064846.png

 

  • golfnutt82 Profile Picture
    1,360 on 15 Sep 2022 at 12:45:03
    Re: Dynamically add item to lookup list

    Hello and thank you for your reply and the added refresh did the trick.

  • Verified answer
    v-bofeng-msft Profile Picture
    on 15 Sep 2022 at 03:27:49
    Re: Dynamically add item to lookup list

    Hi @golfnutt82 ,

     

    Please refresh the data source after you add a new item into tblGageType. For example: 

     

    Patch(tblGateType,Defaults(tblGateType),{XXXXXX};

    Refresh(tblGateType);

    Refresh(GageTracking);

    Navigate(GageXXXXXX)

     

    Best Regards,

    Bof

     

  • golfnutt82 Profile Picture
    1,360 on 14 Sep 2022 at 17:08:27
    Re: Dynamically add item to lookup list

    Ok, I was able to find a way to dynamically add a new lookup list item when the lookup on the form doesn't have the value I am looking for. 
    I created a new screen that is connected to the datatype (GageType) where the lookup values are.
    In the GageType lookup list of values I added a value called "New Entry".
    When in the main form, where I am adding a new Item, I click the Gage Type dropdown and chose "New Entry".

    golfnutt82_0-1663174454701.png

    Using the OnChange event for the DataCardValue4 control, I set the navigation to open the new "GageTypeNewForm1" form when "Add New" is selected.

     

    The Add New Gage Type form opens where I can now add the new gage, save and then open the GageTrackingToolForm. 
    The issue I now have is the current Gage Type lookup doesn't get updated with the new entry.
    Am I missing something?

    golfnutt82_1-1663175101491.png

     

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

Paul Stork – Community Spotlight

We are honored to recognize Paul Stork as our July 2025 Community…

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 791 Most Valuable Professional

#2
MS.Ragavendar Profile Picture

MS.Ragavendar 410

#3
mmbr1606 Profile Picture

mmbr1606 275 Super User 2025 Season 2

Loading complete