Customer experience | Sales, Customer Insights,...

Populating a dataverse table based on a date range

(1) Share

Report

Posted on by RyeTeacher

163

I have an attendance table for students that needs to be populated with the student id, class id and date. So each day there could be 150 students that take eight courses each. I need to populate that for each school day in the year. Is there an easy way to do this? Would this be in a workflow? An import?

All responses (4)

Answers (0)

Suggested answer

Pradeep Rai 5,490 Super User 2024 Season 2 on at

Like (0)

Report

RE: Populating a dataverse table based on a date range

Hi,

I agreed with abdul suggestion also you can check below link which help to get data from excel:

https://softchief.com/2022/09/19/excel-operation-power-automate-get-records-from-excel-and-update-in-dataverse/
Suggested answer

Abdul Wahab 12,070 Super User 2024 Season 1 on at

Like (0)

Report
RE: Populating a dataverse table based on a date range

Hi Rachel Ryerson,

The easiest way for me is Power Automate. Use the below components to accomplish

Recurrence (Trigger)

List rows (for Students)

Apply to each

List rows (for Courses)

Apply to each

Add a new row (Create attendance record using the above details)
RyeTeacher 163 on at

Like (0)

Report

RE: Populating a dataverse table based on a date range

I see I could add that as an import. But how do I cycle through each day and add that days students and classes?
Suggested answer

Abdul Wahab 12,070 Super User 2024 Season 1 on at

Like (0)

Report
RE: Populating a dataverse table based on a date range

Hi Rachel Ryerson,

It could be done using import.

Create a view that will not list any records. or it will b okay if you create a new line in excel.

Open in Excel online

Click on save

You can create records with workflow also.