When trying to get the column name from a "Send an HTTP request to Sharepoint" action, because I was trying to get the column value BEFORE the value was changed. I need to log the old value into a "log" column.

In the Sharepoint List,  I named the column "2026-Assignments" and the column name looked like, "_x0032_026_x002d_Assignments" when I looked at the columns url in list settings. Example below:

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.