Unanswered

How to create absentee list using PowerApp

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

I am trying to write an app that would create a list of the students those were absent for any selected week. I have Students' master table with Student ID, Name, SS etc. fields in a SharePoint list and an another SharePoint list call attendance with Student ID and attendance-week fields. The app will have a drop down for the week and user can select the week to generate the absence report for with the click of a button. The list of the absent students can be display in a List Box control or I can write to a SharePoint list ( I figured out how to add record to the list using Patch). How would I do this? I looked at ForAll and AddColumn but I am still not sure how to implement this.

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (0)

Sort by

Shanescows 2,218 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
What have you tried? Where are you stuck? There are different angles you could try here.

Using a Shopping Cart mentality to collect all of the absences and then write records back to SharePoint when you are done.
Use a gallery of all of the students and when they mark a student absent update that students record right then.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
@Shanescows wrote:
What have you tried? Where are you stuck? There are different angles you could try here.

Using a Shopping Cart mentality to collect all of the absences and then write records back to SharePoint when you are done.
Use a gallery of all of the students and when they mark a student absent update that students record right then.
I haven't tried anything because I don't know how to go about it.
I just started reading about ForAll documentation.
I am not sure if I phrased my question clearly or not but I have to go through Students' Master list for each student and if it is not in Attendance list, add it to the List Box Control or create a new share point list and add ot it.
Thanks for your help.

Was this reply helpful? Yes No
SmartMeter 248 on at

Like (0)

Report
Copy link

Link copied!

Hi, and welcome Yugpatel, I suggested a table design for this soul off in Hawaii, Perhaps you might want to read this too, Best wishes, SmartMeter. https://powerusers.microsoft.com/t5/General-Discussion/PATCH-Advice/m-p/107307#M38932

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

@SmartMeter wrote:
Hi, and welcome Yugpatel, I suggested a table design for this soul off in Hawaii, Perhaps you might want to read this too, Best wishes, SmartMeter. https://powerusers.microsoft.com/t5/General-Discussion/PATCH-Advice/m-p/107307#M38932
Thanks for the suggestion. I will look into it.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

What is wrong in this syntax? Somehow I get red mark under = sign. ClearCollect (ABCTable, ForAll(ToolsMasterVersion2,If(ToolsMasterVersion2.'{Name}'= toolsweeklyverification.bwtoolnumber,{bwtoolNumber:'{Name}'})))

Was this reply helpful? Yes No
SmartMeter 248 on at

Like (0)

Report
Copy link

Link copied!

Put the "Name" objects from each side of the = sign into text boxes. See if they are different:1 ) object types, 2) values. Normally this error means you are attempting to compare two incompatible objects, or the If does not want the = at that place in the code. Sometimes if you hover over the error, it will tell you the objects are not similar.

Was this reply helpful? Yes No