EDITING SUMMARIZES

[Gorilla_8]

Hey guys, I need some help, I have a problem....

Here I go...

I have a reimbursement app, where it summarizes based on the type of expense of the users, within them: Food, travel, others and transportation.

However, the user needs to modify an item or the type of expense (food, travel, others or transportation), so how do I update my list on the sharepoint based on a form in the powerapps, without losing the other summaries that are already done?

[Gorilla_8]

I am trying using this: 

Sum(
Search(
MasterGallery.Selected.'Resumo Alimentação Total' in "Alimentação";'Tipo de Despesa'
);
DataCardValue57_1.Text
)

[v-yutliu-msft]

Hi @Gorilla_8 ,

Do you want to calculate all the 'valor do gasto' field value based on the selected 'Tipo de Despesa' field value?

Actually, I'm not familiar with Portuguese. So I  not quite understand the feather that you want.

I just make a assumption based on your pic and formula.

Could you describe more clearly about the feather that you want and your app, your data source all in English?

Based on your formula, maybe you need to pay attention to this:

Search function syntax:

Search( Table, SearchString, "Column1" [, Column2, ... ] )

MasterGallery.Selected.'Resumo Alimentação Total' in "Alimentação" is not a table.

What's more , what does DataCardValue57_1.Text represent?

Maybe you could try this formula:

Sum(
    Filter(database;"Alimentação" in MasterGallery.Selected.'Resumo Alimentação Total');
    'Tipo de Despesa'
    )
-Value(MasterGallery.Selected.'valor do gasto')+Value(DataCardValue57_1.Text)

//please replace with your database name. 
filter table based on this rule:"Alimentação" in MasterGallery.Selected.'Resumo Alimentação Total'
-Value(MasterGallery.Selected.'valor do gasto') means minues original 'valor do gasto' value
+Value(DataCardValue57_1.Text) means plus value in DataCardValue57_1

Best regards,

[Gorilla_8]

Hey, @v-yutliu-msft !

• Do you want to calculate all the 'valor do gasto' field value based on the selected 'Tipo de Despesa' field value?
  Yes, I want to save the entire sum based on a filter in the 'Tipo de Despesa'(In English it would be: 'Type of Expense), and adding the edition of the current item.

Okay, I'm sorry you don't understand me, so here's a better explanation, I hope...

I have two galleries, one has the items from a sharepoint list and the other the details, based on table repeating

The first one is this>

The red mark is the list where the "parent" items are....

The green check mark is the ID for selecting the item and viewing the same...

And the blue marking is the gallery with the items with the details of the items, that is, all the user's expenses ... (yes, it is a refund app)

----------------------------------------------------------------------------------------------------------------------------------------------

So when the user clicks on edit an item a form will appear for him ...

You can see that the 'Valor do gasto'(In english would be: 'expense amount') is '20' in the form and in the second gallery (that one with the items) and it is also '20' in the first gallery, where there is 'Resumo alimentação'(In english would be: 'summary food'), I want it to add any and all change made in the 'Valor do gasto'(amount spent) and update the sum(resumo alimentção = 'summary food') also in the first list.

And another thing, the 'Tipo de Despesa'(In english would be: 'Type of Expense') is where he selects the type of 'Resumo Alimentação'(In english wolud be 'summary food') that will add up, among them, there are 4 options ...

Among them are ...

Food              - 'Resumo Alimentação' / Summary Food
Transport      - 'Resumo Transporte'  /  summary Transport
Travel            - 'Resumo Viagem'        /  trip summary
Others           - 'Resumo Outros'           /  Summary others

Did you get it?

[v-yutliu-msft]

Hi @Gorilla_8 ,

Ok.

Let me explain my understanding firstly:

1)gallery1 list all the cost(sum of food, sum of travel, sum of  Transport, sum of others) based on selected user

2)gallery2 list the user's cost in details

3)user update cost based on expense type(food,travel,Transport,others)

4)if you click the edit button in gallery2, you will open an edit form for a specific expense record.

5)If you submit the edit form, you want to update detailed expense in gallery2 and update the sum cost based on expense type in gallery1

Am I right?

Could you tell me the data type of  'Tipo de Despesa' field? I assume that it is a choice field which these choices:

 Alimentação,Transporte,Viagem,Outros.         

If so, you could try this:

1)gllery1's Items:

Filter(
AddColumns(
GroupBy(listname;userID,"sumcost");
"Resumo Alimentação";
Sum(Filter(sumcost; 'Tipo de Despesa'.Value="Alimentação"); 'Valor do gasto');
"Resumo Transporte";
Sum(Filter(sumcost; 'Tipo de Despesa'.Value="Transporte"); 'Valor do gasto');
"Resumo Viagem";
Sum(Filter(sumcost; 'Tipo de Despesa'.Value="Viagem"); 'Valor do gasto');
"Resumo Outros";
Sum(Filter(sumcost; 'Tipo de Despesa'.Value="Outros"); 'Valor do gasto');
);
userID=drop down1.Selected.Result
)

 2)set the drop down's Items:

Distinct(listname;userID)

3)set gallery2's Items:

Filter(listname;userID=drop down1.Selected.Result)

 4)set the edit form's data source to your listname

set the edit form's Item:

gallery2.Selected

set the submit button's OnSelect:

SubmitForm(Form1)

Then gallery1 will display cost record based on selected userid and display sum of cost based on expense type.

Gallery2 will display all the cost records in detials.

The edit form will be used to update the specific cost record.

When you submit the edit form, the detailed data in gallery2 will update and sum of cost in gallery1 will update too.

What's more, some of my column name, listname may not be correct, please replace with yours.

Best regards,

[Gorilla_8]

Hi @v-yutliu-msft , yes you understand correctly,  but I dont get the "sum cost", what do you  mean with that?

[v-yutliu-msft]

Hi @Gorilla_8 ,

I just showed you how to display these four sum cost in gallery1:

Food              - 'Resumo Alimentação' / Summary Food
Transport      - 'Resumo Transporte'  /  summary Transport
Travel            - 'Resumo Viagem'        /  trip summary
Others           - 'Resumo Outros'           /  Summary others

Do you want to get sum cost of all the kinds of expense?

Could you tell me how do you calculate for this?

I notice that food+transport+travel+others  is not equal to the sum cost in your picture.

I need to know the rule.

Best regards,

[Gorilla_8]

Do you want to get sum cost of all the kinds of expense?

Yes, I need this too....

Could you tell me how do you calculate for this?

When the user creates a new item, it is added to a collection and then saved to SharePoint, based on the type of exception

I notice that food+transport+travel+others is not equal to the sum cost in your picture. I need to know the rule.

And I got this error:

He says, "GroupBy" has arguments invalid

[v-yutliu-msft]

Hi @Gorilla_8 ,

I'm sorry that I made a little mistake.

Try this formula to set gallery1's Items:

Filter(
AddColumns(
GroupBy(listname;"userID","sumcost");
"Resumo Alimentação";
Sum(Filter(sumcost; 'Tipo de Despesa'.Value="Alimentação"); 'Valor do gasto');
"Resumo Transporte";
Sum(Filter(sumcost; 'Tipo de Despesa'.Value="Transporte"); 'Valor do gasto');
"Resumo Viagem";
Sum(Filter(sumcost; 'Tipo de Despesa'.Value="Viagem"); 'Valor do gasto');
"Resumo Outros";
Sum(Filter(sumcost; 'Tipo de Despesa'.Value="Outros"); 'Valor do gasto');
);
userID=drop down1.Selected.Result
)

 I lest a "" in my original formula.

The syntax of GroupBy should be like:

GroupBy(tablename,"fieldname","newfieldname")

Here's a doc about this function for your reference:

https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/functions/function-groupby

Best regards,

[Gorilla_8]

same error