I want percentage of days a student missed out of the school year. 

Add a custom column and put:

if [DaysEnrolled] <> null and [DaysEnrolled] <> 0 then

    Number.Round(([UNEXCUSED_ABS] / [DaysEnrolled]) * 100, 2)

else

    0

Create a dynamic date range with today's date being the end date. Counts all the "Business" days with no weekends or holidays.

let

Issue Error: The data source Extension is missing credentials and cannot be accessed 

Grab the Uploaded file from the MS Forms response

json(outputs('Get_response_details')?['body/ra8991ac565984ed196be90f7feb58394'])

I have a column that I grouped by tracking number. I want to display how many items in the shipments went to each student. 
I had a column that had the shipped dates so when I grouped by tracking date, I got duplicate dates I didn't need.

***Note: I changed my date field to a text column in another step. I was doing something else with the data, like using power automate to write the outputs to a CSV and I didn't want to deal with the whole "Format Date and Time" in Power automate.             ++

Here's the cheat FX:

Cheater code:

Displays all the items in the status color is Blue or Yellow if nothing is in the search box,

Then it will drill down by the name when the user enters name but only the items that are status "Blue" or "Yellow"

Then it sorts the gallery by the Title.

In the Visible Property:

If(ThisItem.ChoiceColumnName.Value = "-" Or ThisItem.ChoiceColumnName.Value = "No", false, true)

This code takes a Sharepoint list containing over 4000 items and allows the app user to search the list by legal name (Title) or PreferredName.
It sorts ascending and will show most of the sharepoint list items when the gallery is first loaded or if the app users resets the search text box.

However, it will search/filter the entire sharepoint list.

Reference: Blue= Null Field

In the text Property for the field:

Coalesce(ThisItem.NewLocation.Value, ThisItem.CeremonyLocation.Value)

Explanation:

If "ThisItem.NewLocation.Value" is Null or Blank then it will display this field> "ThisItem.CeremonyLocation.Value"