Help needed with 2 issues in my expenses app

[Ousselg]

Hi Guys,

I was trying to build an expenses app @Reza.

I have an issue with the lookup column part. 

In this video: https://www.youtube.com/watch?v=tL_w4jVHxdg&t=752s&ab_channel=RezaDorrani (around 17:00 mark) he mentions the default property of the lookup column. If I use the code provided there it fills the default item in.

But when sending the form the value doesn't get written to SharePoint.

If I select the expense item from the dropdown menu then it writes it down to SharePoint. I don't want the user to see that value (make it visible) but when using the default value option somehow PowerApps doesn't write it back to SharePoint and I don't know why.

Any suggestions would be really helpful.

p.s how do you build an expenses app that you only see your expenses?

Because it reads out the SharePoint list but you don't want user to see each others expenses.

[Ousselg]

Hi Guys,

I am trying to get the total amount of expenses from the gallery.

if use the following formula : "€ " & Sum(Filter('Expenses Receipts', Name= Gallery2.Selected.Name), 'Amount (including Vat)')  I just get the selected item.

If I use this one: "€ " & Sum('Expenses Receipts','Amount (including Vat)') I get the total of all items in there.

I want to filter on just the selected gallery and get the SharePoint colum 'Amount (including Vat)'

The Idea is that you see your total expenses and to write this down to SharePoint.

[Ousselg · Accepted solution]

Never mind, I figured it out. Topic is closed.