Showing results for 
Search instead for 
Did you mean: 
Helper I
Helper I

Help needed with 2 issues in my expenses app

Hi Guys,


I was trying to build an expenses app @Reza.

I have an issue with the lookup column part. 

In this video: (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.


2022-10-13 15_46_52-Power Apps.png


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


2022-10-13 15_47_27-Settings.png


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.





Accepted Solutions
Helper I
Helper I

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

View solution in original post

Helper I
Helper I

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.

Helper I
Helper I

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

Helpful resources

Power Apps News & Annoucements carousel

Power Apps News & Announcements

Keep up to date with current events and community announcements in the Power Apps community.

Community Call Conversations

Introducing the Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Apps Community Blog Carousel

Power Apps Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Top Kudoed Authors
Users online (1,764)