My Parse JSON action was giving me this:
"{""Value"":""Allentown""}" as my text Value for my CSV

Change the background color of one Sharepoint List column based on if another Sharepoint list column is empty, blank or null.
*****Note: This will only work correctly if your Multi-Line Text / String Column is Plain text. Make sure the column is set to plain text. (Not Rich text or Enhanced rich text)
 

Instead of looking for the Sharepoint list by Title, look for it by ID.

_api/web/lists/getbyid('%7B23bb13e3-ed19-42c4-9dd6-524136b89925%7D')/items(@{triggerOutputs()?['body/ID']})/versions(@{outputs('Get_changes_for_an_item_or_a_file_(properties_only)')?['body/SinceVersionId']})

How to find your sharepoint list ID?

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: