Answered

Dropdown Values not saving in Dataverse table

(1) Share

Report

Posted on by Community Power Pla... 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:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (2)

Verified answer

v-jefferni Microsoft Employee on at

Like (2)

Report
Copy link

Link copied!
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,

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Verified answer

v-jefferni Microsoft Employee on at

Like (2)

Report
Copy link

Link copied!
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,

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!

Thank you Jeffer,

Issue has been solved.

Regards,
Kalyan

Was this reply helpful? Yes No