I am starting working with Powerapps and I would like to ask for your help to correctly approach the following problem.
I have an excel file with data representing business trips, columns being:
At this moment I need to make a Powerapps front-end for this file. I have a plan to use the Calendar Screen, which OnStart parses the file and shows all events for the current user also allowing him to edit/add data.
Q1: As far as I understood, excel file located on One Drive for Business allows multiple app users to read AND to write to the same file. Am I correct?
Q2: What kind of formulas would you suggest to parse the file? I feel a weak spot in the fact the calendar looks for a single-day=single-event style, and I have a date range format.
Q3: Having in mind that currently I need to use an excel as a data source/destination, any other approaches that I should consider for this task?