You’re offline. This is a read only version of the page.
[SOLVED BY MESELF]
Good day
I'm trying to figure out if the following would be possible?
My senario:
i'm creating a sharepoint list with several columns one this list is linked to a powerapp. In this list i have one column for this purpose i will call it TypeOfAccount when a value(120 values) in this column is selected it must automatically update the column next to it to display the current allocated(budgeted) amount of that account.
E.g
-Insurace was selected from the drop down.
-Budget amount is R2000
-Paid for January the amount of R300
After this is completed i need to update the 2nd column to the new amount Col 1= insurace, Col2 = Budget amount(R2000) Col3 = paid amount(R300) Col2=[column2]-[Column3]
This amount must be unique to each of the 120 values in the dropdown changing everytime the same line item is chosen Insurance for Jan will be R2000-300 for feb it must be R1700-300.
hope this makes sense.
if i can read this data out of an excel and then updating the field in excel would it make logically sense?
Share
Report
All responses (
Answers (
237
