Add New Columns to Excel

[tfmarcomtf]

I am creating a company wide IOU tracking app. Our current system is just pen and paper and an excel sheet. 

I have the app able to accept a users input, find their name in an excel sheet and add the new iou to their outstanding balance. I also have it write the current sessions iou to a column next to the total. 

What I would like to be able to do is have the app create a new column for every new day, any iou's that occur on that day would be filled in the proper dated column. The next day, a new excel column would be added and any iou's would occur and be added to the correct day.

Is this possible with powerapps? Is there a better solution?

[tfmarcomtf]

Hi @timl,

Unfortunately, that did not work. I tried removing the $ altogether and changing the text value to a numeric value. Still gives the same error.

Not sure how to proceed.

[timl]

Hi @tfmarcomtf 

That's really strange. Could you upload a screenshot of the Update property of your card?

[tfmarcomtf]

Hi @timl ,

I ended up removing my data source and reconnecting it and everything seems to work fine now. 

I need to build in a few more safeguards, but otherwise the app is working as expected. 

Thank you so much for taking the time to help me through these issues. It is much appreciated.

[timl]

You're welcome @tfmarcomtf! I'm glad it's working for you now.