PowerApps DropDown values not visible in Excel

(0) Share

Report

Posted on by safifaruqi

Hey Everyone,

Reaching out for some guidance.

Building an app to log product quality issues, right now its excel based table which captures the information collected in the Powerapps form. I have 5 dropdowns in my form that for some reason, populate and function just fine within the app, but when I submit the form, those 5 dropdown fields, show up as blank when the record is transferred to excel sheet.

Interestingly, when I search records within the app, I am able to retrieve the information entered in those dropdown boxes.

So far I have looked into update properties and onchange but I cant figure out. These fields were populating just fine, I did not make any changes to the default properties, but stopped out of nowhere.

Please help me troubleshoot.

Please let me know what other information can I share to help you help me.

Thank you!

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (0)

Sort by

StalinPonnusamy Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!
Hi @safifaruqi

We can try to use Patch command instead of SubmitForm. The below code is for new or update.

Patch( DataSource, If( EditForm1.Mode = FormMode.New, Defaults(DataSource), LookUp( DataSource, ID = SelectedId or Gallery1.Selected.ID ) ), { Issue : Dropdown1.Selected.Value, 'Sub Issue': Dropdown2.Selected.Value, 'Seviority': Dropdown3.Selected.Value } );

Was this reply helpful? Yes No
safifaruqi 69 on at

Like (0)

Report
Copy link

Link copied!

@StalinPonnusamy

Thank you so much for the response! I really appreciate it. I will try this out and get back to you!

Was this reply helpful? Yes No
safifaruqi 69 on at

Like (0)

Report
Copy link

Link copied!

just tried the patch, still same output. I am guessing its got to do with the update properties of the form in someway.

Was this reply helpful? Yes No
StalinPonnusamy Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Let me try this. Is excel stored in one drive?

Was this reply helpful? Yes No
safifaruqi 69 on at

Like (0)

Report
Copy link

Link copied!

yes it is,

Was this reply helpful? Yes No
safifaruqi 69 on at

Like (0)

Report
Copy link

Link copied!

this is what I had used for the on select property :
Patch(
QMS_Data_Table,
If(
EditForm1.Mode = FormMode.New,
Defaults(QMS_Data_Table),
LookUp(
QMS_Data_Table,
ISSUE_x0020_ID = IssueID_SubmitScreen.Text Or BrowseGallery1.Selected.ISSUE_x0020_ID )
),
{
ISSUE: drpIssue.Selected.Result,
'SUB-ISSUE': DrpSubIssueType.Selected.Result,
'SEVERITY': drpSeverity.Selected.Severity
}
);
Navigate('Success Screen',ScreenTransition.Fade)

Was this reply helpful? Yes No