Answered

Save Gallery and Form PowerApps into SharePoint List

(0) Share

Report

Posted on by Lucas_Ignatius

230

Hi everyone, I just want to save my powerapps gallery data to SharePoint List but there is only one column (only title) if I add other column it will be an error.

Can anyone help me

I attach my screenshoot bellow

Save Gallery to List SharePoint.JPG

My command : ForAll(ExpenseCollection,Patch('Budget Tracking',Defaults('Budget Tracking'), {Title:Title, NominalBiaya:Amount,}));

The problem if I add NominalBiaya:Amount it can't save but if only title:title it will be save to my sharepoint

And then I want to save my other column Department (dropdown2 it from my database sharepoint list) into my SharePoint List but it can't save

Categories:

Building Power Apps

All responses (12)

Answers (1)

Sort by

Boynog 84 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Lucas_Ignatius ,
Use this code below.
ForAll(ExpenseCollection,Patch('Budget Tracking',Defaults('Budget Tracking'), {Title:Title.Text, NominalBiaya:Value(Amount.Text)}));

-------------------------------------------------------------------------
If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.
Lucas_Ignatius 230 on at

Like
a
(0)

Report
Copy link

Link copied!

It still have an error.
Boynog 84 on at

Like
a
(0)

Report
Copy link

Link copied!

@Lucas_Ignatius ,
Use this only. If you want to save a single row.
Patch('Budget Tracking',Defaults('Budget Tracking'),{Title:Title.Text, NominalBiaya:Value(Amount.Text)});

Then can you highlight the error.

-------------------------------------------------------------------------
If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.
Boynog 84 on at

Like
a
(0)

Report
Copy link

Link copied!

@Lucas_Ignatius ,
Just make sure no space
Patch('Budget Tracking',Defaults('Budget Tracking'),{Title:Title.Text,NominalBiaya:Value(Amount.Text)});
-------------------------------------------------------------------------
If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.
Lucas_Ignatius 230 on at

Like
a
(0)

Report
Copy link

Link copied!

Yap, it works but only saved amount only first row on column nominalbiaya.
Boynog 84 on at

Like
a
(0)

Report
Copy link

Link copied!

@Lucas_Ignatius ,

Patch('Budget Tracking',Defaults('Budget Tracking'),{Tahun:Title.Text,Department:DropdownDepartment.Selected.Value,NominalBiaya:Value(Amount.Text),SisaBudget:SisaBudget.Text});

put the names of your components just follow the format
-------------------------------------------------------------------------
If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.
Lucas_Ignatius 230 on at

Like
a
(0)

Report
Copy link

Link copied!
Lucas_Ignatius 230 on at

Like
a
(0)

Report
Copy link

Link copied!

ForAll(ExpenseCollection, Patch('Budget Tracking',Defaults('Budget Tracking'),{Title:Title, NominalBiaya:Value(Amount.Text)}));

I just add ForAll, but it still only one row on NominalBiaya if save to sharepoint list, and for Title is correct will be save all column
WarrenBelz 156,756 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
@Lucas_Ignatius ,

You need to disambiguate Title

ForAll( ExpenseCollection As aExpense, Patch( 'Budget Tracking', Defaults('Budget Tracking'), { Title:aExpense.Title, NominalBiaya:Value(Amount.Text) } ) )

I am assuming here that Amount.Text is always the same value for each item (and is not in the Expense Collection).

If not (it is in the Collection), you need

ForAll( ExpenseCollection As aExpense, Patch( 'Budget Tracking', Defaults('Budget Tracking'), { Title:aExpense.Title, NominalBiaya:aExpense.Amount } ) )

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.
Lucas_Ignatius 230 on at

Like
a
(0)

Report
Copy link

Link copied!

ForAll(Gallery2.AllItems, Patch('Budget Tracking',Defaults('Budget Tracking'),{Title:Expense.Text, NominalBiaya:Value(Amount.Text)}));

I just using that script and it works, but I've question on NominalBiaya:Value(Amount.Text), I want to change to be NominalBiaya:aExpense.Amount. It can't why this happen? and how to can be using that?

Thanks