Unanswered

Update SharePoint List with Power App form data using Patch function

(1) Share

Report

Posted on by Community Power Pla...

Hello,

I have been beating my head for the past week trying to find the solution to my issue.
I have a SharePoint list that runs a weekly flow that pulls in data from multiple data sources.
People are able to go into the form and enter an APP ID to find the record information.
Some of the fields are manual input where people can either enter a new value or update an existing value.
My though is that I will need a patch function that will update the record.
I am stuck getting the selected values from my combo box and updating the SharePoint list item field with the new values.

Hard to believe I am the only one with this situation as I have scoured the internet and this site for an answer without success.
Below are many pictures showing what I am trying to do without success.

This is my first stab and patching the combo box to a SharePoint list and I get an network error.

Patch(
'CST Application Portfolio',
LookUp(
'CST Application Portfolio',
Title = Value(DataCardValue1.Text)
),
{'Existing Environments': cboExistingEnvironment}
);

Categories:

Building Power Apps

I have the same question (0)

All responses (7)

Answers (1)

WarrenBelz 153,032 Most Valuable Professional on at

Like (1)

Report
Hi @Anonymous ,

Assuming Title is a Text column and 'Existing Environments' is a Single Choice, you should need with this

Patch( 'CST Application Portfolio', LookUp( 'CST Application Portfolio', Title = DataCardValue1.Text ), {'Existing Environments': cboExistingEnvironment.Selected} );

or this should also work

Patch( 'CST Application Portfolio', LookUp( 'CST Application Portfolio', Title = DataCardValue1.Text ), {'Existing Environments': {Value: cboExistingEnvironment.Selected.Value}} );

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

MVP (Business Applications) Visit my blog Practical Power Apps

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

Like (0)

Report

Hi Warren and thanks for your reply.
My Existing Environments combo box is multi select.
What changes due to that?

Was this reply helpful? Yes No
Verified answer

WarrenBelz 153,032 Most Valuable Professional on at

Like (2)

Report

Hi @Anonymous ,

You might firstly read this blog of mine as this is not a simple process.

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

Like (1)

Report

Hi Warren,
Thank you for the help.
I was able to utilize your information to create the following patch.
If(
IsBlank(
LookUp(
'CST Application Portfolio',
ID=Value(DataCardValue113.Text)
)
),
Patch(
'CST Application Portfolio',
Defaults('CST Application Portfolio'),
{Title:DataCardValue26.Text,
'App Id':DataCardValue1.Text}
),
Patch('CST Application Portfolio',
LookUp('CST Application Portfolio',
ID=Value(DataCardValue113.Text)
),
{Title:DataCardValue26.Text,
'App Id':DataCardValue1.Text,
'Existing Environments':Concat(DD_ExistingEnvironments.SelectedItems,Value,", ")
}
)
)

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

Like (1)

Report

The blog was very helpful.
I am surprised that doing this was that convoluted.

Was this reply helpful? Yes No
WarrenBelz 153,032 Most Valuable Professional on at

Like (1)

Report

Hi @Anonymous ,

So this is solved now ?

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

Like (1)

Report

Hi Warren, Yes. I will mark your blog post as accepted solution.
Thanks again!

Was this reply helpful? Yes No