Answered

create a sharepoint list item with 2 datasources

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hi all,

I would like to create items in a sharepoint list thanks to 2 databases : The sharepoint list itself and an Excel File.

3 fields are Datacards from the Sharepoint column and the last one is a combobox from an Excel File in my OneDrive. When I submit the form, the 3 firsts fields are copied perfectly but I don't know how to copy my combobox.

I tried to create a flow in order to update the field but the formulas isn't good.

Could someone help me ?

It would help me a lot!

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Sort by

Verified answer

Shanescows 2,218 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Your submit button is going to need a patch function for updating the Excel file. The form is only connected to the SharePoint data source so that is the only thing it can update.

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

Like
a
(1)

Report
Copy link

Link copied!

I tried to add the patch function :
Patch('Visitor List',First(Filter('Visitor List', Title = DataCardValue3.Text)),{VisitedPerson : ComboBox3})

The error seems to be Combobox3. I would like the VisitedPerson column to get the Combobox3 text.

Do you have an idea?

EDIT : the correct formula is Patch('Visitor List',First(Filter('Visitor List', Title = DataCardValue3.Text)),{VisitedPerson : ComboBox3.Selected.Name})

Was this reply helpful? Yes No
Shanescows 2,218 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Nice. You beat me to it. I was just playing with the same thing.

Does you combo box allow multiple values? Does your formula work if you select 2 values? I was playing with the ConCat function thinking you might need it.

Was this reply helpful? Yes No