Melinda Cozza - Power Platform and CMS Developer

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 ))

Concatenate("Your Label Text " & CountRows(Filter('SharepointList', YourColumnName = "Your text condition" )))

For example: 
The below script looks at a couple conditions and counts the items that fit the criteria. This script is placed in a Text Label.
Concatenate("Diplomas that will need to be mailed" & " Total: " & CountRows(Filter('2025SummerGradCeremony', StatusColor.Value = "Yellow" And DiplomaEarned.Value = "Yes" )))

What it looks like on the Power App