Hello,
first I apologize for my english I’m french ^^. So I’m a beginner on Sharepoint online and I’ve created an expense sheet where people write how much did they spend, the type of expenditure, the tax-free amount. And I’d like to link the VAT colum with the type of expenditure (It’s a column where you choose among the proposals) . Like if you choose that you went to restaurant then the VAT is at 20% or if you took the taxi maybe 10%. I’d like to fill automatically the VAT column according to the choice on the type of expenditure column. Do you think it is possible and how ?
Thanks
You can do this several ways, but I would look at creating a PowerApps form that will automatically fill in that information based on Choice or Lookup fields that the user selects. Here’s a link to get started: https://powerapps.microsoft.com/en-us/
