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 / Save combobox data int...
Power Apps
Answered

Save combobox data into Sharepoint list

(0) ShareShare
ReportReport
Posted on by Microsoft Employee

Hi guys, i need help in saving the combobox data into sharepoint list.

 

I have created a list call "(MR) Material Record List" and also another list call " TRF Number List 2". 

In "(MR) Material Record List", the data column call "TRF Number" is a choice type column;

In " TRF Number List 2",  the data column call "TRF Number" is a single line of text type column.

In PowerApps, I have use the "(MR) Material Record List" to create a form. For the 'TRF Number' column, I have changed the dropdown box to combobox and set the data sources to " TRF Number List 2". 

The reason I do this because I want to use the data from " TRF Number List 2" and save the data to my master list- "(MR) Material Record List".

 

This step is successful. 

New_inPOWERAPPS_0-1624946978210.png

 

When i check back Sharepoint list, the TRF number that selected in PowerApps will not update when i save the result.  

 

New_inPOWERAPPS_1-1624947255430.png

 

This is the function that I use. Am I missing something in 'OnSelect' property at the save button? Testform is the form that use to save the TRF Number. Or Power Apps does not allow us to save the data in different column types? 

 

```

Patch(
'(MR) Material Record List',
varFormData,
PipngForm.Updates,
DuctingForm.Updates,
Rform.Updates,
Testform.Updates
);

Set(ShowConfirmRequest,false);
Navigate(HomeScreen);

```

 

Categories:
I have the same question (0)
  • CNT Profile Picture
    10,921 Super User 2024 Season 1 on at

    @Anonymous Please  change the "TRF Number" in "(MR) Material Record List", to Lookup type column - to lookup to the "TRF Number" column in "TRF Number List 2".

  • Community Power Platform Member Profile Picture
    Microsoft Employee on at

    @CNT I apologize bcoz I do not see the Lookup type column in the SharePoint list when I edit the column. 

     

    New_inPOWERAPPS_0-1624948943565.png

     

  • CNT Profile Picture
    10,921 Super User 2024 Season 1 on at

    @Anonymous Unfortunately there is no way to change the type directly. The best option is to create a new Lookup column and delete the old Text column.

  • Verified answer
    Community Power Platform Member Profile Picture
    Microsoft Employee on at

    Finally, i figure out the problem. this because of the update property of the datacard has incomplete function. 

    Thanks for the suggestion. 

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

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 342 Most Valuable Professional

#2
11manish Profile Picture

11manish 234

#3
Valantis Profile Picture

Valantis 187

Last 30 days Overall leaderboard