Melinda Cozza - Power Platform and CMS Developer

The project:  Graduation Ceremony Check In App using refreshed sharepoint list with PowerSchool Oracle Data
Power Automate refreshes the data.
We used Sharepoint list as data backbone for app because the staff do not have Dataverse licenses

Issue:  The power automate Execute Query Action hangs
The resolution:

In my case and the error wasn't obvious because there were no error messages but extremely simple.

Do not end you query with a " ; " (semicolon)

I thought I wrote about this before but couldn't find it.

I have a coulmn in dataverse the stores text like: 1-5-0

Use Case:

I have a AI Prompt that extracts data from a PDF that is emailed to a specified email account.

The are some number fields and  text fields that may be missing or empty from the PDFs.

The usual answer for a solution is the write into the Prompt:
"If you cannot find the relative data or row write NA."

However, that will not work for a Number column type in sharepoint or dataverse.

So I tried:

"If you cannot find the relative data or row write 0."

Case Use: Power App exports a file that is created after a button is clicked.  The Power Automate clears out the dataverse table, refreshes a dataflow, writes it to the clean dataverse table, then a csv file is created from the dataverse table and placed in a sharepoint document library.

This is only the Bulk Delete Action of my Power Automate. (Perform an Unbound action/ Dataverse Action)
 

Jira change their API as sometime in 2025 and I am writing this in January 2026. 
Here is the new info for Power Automate using the HTTP action

Method: GET
URI: https://YOURCOMPANY.atlassian.net/rest/api/3/search/jql

Headers:
Accept: application/json

Just some documentation on how to get around a "Create sharing Link for a file or folder" when using Power Automate to automatically create a post in a teams channel.

Use:  I needed a power automation to create a new column after a certain date and the update the sharepoint item in the new column with values from two other columns.
IE: Our testing closes May 10 and I need to record the users that registered for current years test so we could see it next year.  The column that stores the current data is called "CurrentSchoolYR" so we can continue to use it in the future.
The archive column that will be created when the school year ends will be called assignments2026.

Choices([@'Your list name'].SharePoint_column)

Example:

Choices([@'StateTestingProctor-Teachers'].TestSeason)

In a text label
Concatenate("Total: " & CountRows( YourGallery.AllItems ))