Answered

Would like to fill a sharepoint value using an excel list

(0) Share

Report

Posted on by MNik

My apologies if this this has been addressed before.

I'm trying to create a basic form that connects to a SharePoint list to track internal requests data. If possible, I would also like to connect a separate excel file to use in a combo box which would then populate the selected value(s) in the SharePoint list.

Currently I have the forms set up as needed and everything works successfully, except for the excel combo box...

Is it possible to pull values from an excel file to populate in a SharePoint column?

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (1)

Sort by

Verified answer

SudeepGhatakNZ 14,396 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Yes, First add an excel connection.
Then, you can just update the items property of the Combo box to use Excel as the dataset.

Was this reply helpful? Yes No
MNik 35 on at

Like (0)

Report
Copy link

Link copied!

I have the combo box added and it does contain the excel data. How can I now get it to populate the selected value to the sharepoint row that is created with the other entered data?

Was this reply helpful? Yes No
SudeepGhatakNZ 14,396 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
A few questions first:
Are you using a Form control?
Is your SharePoint field also a choice column?
Are you able to populate the Power Apps choice control with excel data and just having issues saving it back to SP?

Was this reply helpful? Yes No
MNik 35 on at

Like (0)

Report
Copy link

Link copied!
Are you using a Form control? Yes, the form is created from the sharepoint list.
Is your SharePoint field also a choice column? Yes, the column is set as choice.
Are you able to populate the Power Apps choice control with excel data and just having issues saving it back to SP? Yes, I have been able to populate the choice control with excel data since my last reply. The only issue that I have left is getting the choice populating the sharepoint column.

Was this reply helpful? Yes No
MNik 35 on at

Like (0)

Report
Copy link

Link copied!

I was able to get it to work using your suggestion above. Thank you, Sudeep.

Was this reply helpful? Yes No
SudeepGhatakNZ 14,396 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Awesome 👍. Good to hear. Thanks

Was this reply helpful? Yes No