web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Dropdown Values not sa...
Power Apps
Answered

Dropdown Values not saving in Dataverse table

(1) ShareShare
ReportReport
Posted on by Microsoft Employee

Hello Everyone,

 

I am creating an powerapp screen with dropdowns and text fields. My goal is to integrate ChatGPT with the app using API Key, based on the query I request it, get response in JSON format from the ChatGPT, parse the JSON in the app and fill the screen using the extracted Values.

 

After integrating ChatGPT, I am able to fill the extracted values in text fields directly.

 

For Dropdowns, I need to compare if the extracted value is in the Items of the dropdown. If exists, I will select the dropdown value using 'DefaultSelectedItems' with below formula:

 

If(BoolVariableFoundInJSON And FormName.Mode = FormMode.New, [VariableDataExtractedFromJSON], [Parent.Default])

 

Based on value 'BoolVariableFoundInJSON', I am able to set the dropdown value to  'VariableDataExtractedFromJSON' or 'Parent.Default'

 

Once the value is set, I am saving the app data to a Dataverse table, here the dropown values are not storing to the table when automatically filled. The values are saved when I select manually.

 

Can anyone please suggest me the solution for this. 

 

Regards,

Kalyan

 

 

Categories:
I have the same question (0)
  • Verified answer
    v-jefferni Profile Picture
    Microsoft Employee on at

    Hi @Anonymous ,

     

    Please try and change your formula:

    If(BoolVariableFoundInJSON And FormName.Mode = FormMode.New, Filter(Choices(Table.ChoicesColumn), Value in [VariableDataExtractedFromJSON]), [Parent.Default])
    

    Choices(Table.ChoicesColumn) is also in Items of the Combo box.

     

    Best regards,

  • Community Power Platform Member Profile Picture
    Microsoft Employee on at

    Hi Jeffer,

     

    This has helped me a lot. Now I am able to save the data of normal dropdowns to dataverse table. 

     

    In the same form I am using 2 lookup choice fields from other tables, I have to do the same task for them as well.

     

    I tried below formula in defaultselectedItems as below but it is not working. 

     

    If(
    BoolCampaignFound And LeadDeatilsform.Mode = FormMode.New,
    {Campaign: LookUp(Campaigns, Text(Value) in [VarCampaign]).'Campaign Name'},
    {Campaign: [Parent.Default]}
    )

     

    Can you please help me in this case as well.

     

    Thanks in advance,

    Kalyan

  • Verified answer
    v-jefferni Profile Picture
    Microsoft Employee on at

    Hi @Anonymous ,

     

    If it's a LookUp column but only allows single selection, use below formula DefaultSelectedItems:

    If(
    BoolCampaignFound And LeadDeatilsform.Mode = FormMode.New,
    LookUp(Campaigns, 'Campaign Name' = VarCampaign),
    Parent.Default
    )

     

    BR,

  • Community Power Platform Member Profile Picture
    Microsoft Employee on at

    Thank you Jeffer,

     

    Issue has been solved.

     

    Regards,

    Kalyan

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 549 Most Valuable Professional

#2
Kalathiya Profile Picture

Kalathiya 225 Super User 2026 Season 1

#3
Haque Profile Picture

Haque 224

Last 30 days Overall leaderboard