Blogs

Power Automate- HTTP Request- Error- Sharepoint List does not exist- SharePoint Subsite Sharepoint list

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?

Power Automate- HTTP Request: Cannot recognize sharepoint list column that begins with a number, how to find the column name to use

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:

Data Flows- Power Query M code- Get the percentage using two columns- Cheater code

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

Power Automate- JSON get uploaded file from MS Forms to add as Attachments in Sharepoint List - Cheater Expressions

Grab the Uploaded file from the MS Forms response

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

Power Query - Dataflow - get rid of duplicate entries/ values in "Group by" function

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:

Power Apps Cheat Sheet for Gallery Filter and Search Feature

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.

Power Apps- Make field visible based on Option Field Value- Galleries

In the Visible Property:

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

 

Pages

Subscribe to RSS - blogs