Customize From with Powerapps. Difficulty with combobox

%3CLINGO-SUB%20id%3D%22lingo-sub-3405821%22%20slang%3D%22en-US%22%3ECustomize%20From%20with%20Powerapps.%20Difficulty%20with%20combobox%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3405821%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3EI'm%20trying%20to%20create%20a%20new%20sharepoint%20from%20using%20powerapps.%20I%20am%20having%20difficulty%20patching%20the%20data%20from%20the%20combo%20box%20back%20to%20sharepoint.%20The%20error%20im%20getting%20is%20that%20the%20column%20in%20the%20list%20I%20am%20patching%20back%20to%20is%20a%20text%20type.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20realize%20i%20should%20probaly%20be%20using%20a%20lookup%20type%20column%20in%20sharepoint.%20However%2C%20the%20combobox%20in%20powerapps%20is%20taking%20data%20from%20an%20offline%20excel%20sheet.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHow%20do%20i%20make%20a%20sharepoint%20column%20that%20lookup%20the%20data%20from%20excel%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHow%20do%20I%20then%20patch%20the%20data%20from%20powerapps%20back%20to%20sharepoint%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3405821%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ESharePoint%20Online%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3409765%22%20slang%3D%22en-US%22%3ERe%3A%20Customize%20From%20with%20Powerapps.%20Difficulty%20with%20combobox%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3409765%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1393484%22%20target%3D%22_blank%22%3E%40eobrie22%3C%2FA%3E%26nbsp%3Bwhen%20I'm%20using%20Power%20Apps%20with%20SharePoint%2C%20almost%20always%20the%20SharePoint%20column%20types%20are%20single%20or%20multiple%20lines%20of%20text.%20I%20think%20you're%20getting%20a%20wee%20bit%20confused%3A%20you%20don't%20want%20to%20use%20a%20lookup%20type%20column%20in%20SharePoint%20because%20the%20lookup%20is%20being%20done%2C%20or%20should%20be%2C%20in%20Power%20Apps%2C%20not%20in%20SharePoint.%20All%20you're%20doing%20with%20SharePoint%20is%20storing%20the%20result.%20So%20use%20the%20combobox%20to%20lookup%20the%20data%20in%20Excel%20then%20just%20save%20that%20to%20SharePoint.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ERob%3CBR%20%2F%3ELos%20Gallardos%3CBR%20%2F%3E%3CFONT%20size%3D%222%22%20color%3D%22%23006400%22%3EIntranet%2C%20SharePoint%20and%20Power%20Platform%20Manager%20(and%20classic%201967%20Morris%20Traveller%20driver)%3C%2FFONT%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

Hi,

I'm trying to create a new sharepoint from using powerapps. I am having difficulty patching the data from the combo box back to sharepoint. The error im getting is that the column in the list I am patching back to is a text type.

 

I realize i should probaly be using a lookup type column in sharepoint. However, the combobox in powerapps is taking data from an offline excel sheet.

 

How do i make a sharepoint column that lookup the data from excel?

 

How do I then patch the data from powerapps back to sharepoint?

 

 

 

1 Reply

@eobrie22 when I'm using Power Apps with SharePoint, almost always the SharePoint column types are single or multiple lines of text. I think you're getting a wee bit confused: you don't want to use a lookup type column in SharePoint because the lookup is being done, or should be, in Power Apps, not in SharePoint. All you're doing with SharePoint is storing the result. So use the combobox to lookup the data in Excel then just save that to SharePoint.

 

Rob
Los Gallardos
Intranet, SharePoint and Power Platform Manager (and classic 1967 Morris Traveller driver)