Power Platform Community Forum Thread Details

Dear All

Would it be possible to

1. import an excel file (standardised name, standardised columns, not online) in to PowerApps

2. edit the data from the excel file, add to the date

3. submit or export to a SharePoint list

The reason

It is for recording audit activity.

The activity data comes from a source not connected to our local organisation MS365 network. It can be emailed to managers.

The activity data, if it can be imported to a PowerApp, can then be audited (i.e. add true positive, false positive, true negative, false negative etc)

Submit to an MS 365 SharePoint list.

Data needed

1. the excel file will be based on one individual - email address

2. ID number for activity

3. date of activity

The audit is based on activity outcomes database

4. Result - the power app would add TN, TP, FN, FP manually by a manager

5. the ID, date , result and individual would be uploaded to the SharePoint list.

Currently

1. xls data printed (about 200 events)

2. 50 random events picked by manager

3. manager looks at activity outcome database, the paper xl sheet and enters all the data in to the PowerApp that I have already created to edit the data.

4. submit button

However, the manager doing the auditing has to continuously look at three places of data. Can be time consuming perhaps. They are time pressured people.

I would like to have all the data in fewer places as possible - hence, can the auditing be done on the app

My initial thoughts.

1. open the app

2. import the xl data

3. use power automate to upload the xls file to store on OneDrive online

4. somehow, create a table in the uploaded xls file automatically.

5. PowerApps references the xls file and uploads to SharePoint.

Pragmatically

1. managers send xls file to me

2. I upload the xls file to OneDrive safely, create the table on the online file.

3. use the PowerApp once I have done (2) above.

Many thanks