Power Apps

Power Apps- Disable button for 3 second after clicked and display notification to prevent multi-clicks

I don't know why but this was extremely difficult to find on the web.

This is how to add a button to a Power App that will disable after clicked, display a notification, and then re-enable after three seconds.

 

Power Apps- Order your Dropdown options for Distinct Text Sharepoint list Column Values

I added a Dropdown list that filters a gallery by Manager Name.

Using distinct Manager Names as option for my drop down were is a crazy order.

I want the options on the dropdown to be alphabetical so Managers are easier to find and select.

Here is the cheater code:

Sort(Distinct('Your Sharepoint List', ColumnName),Value,SortOrder.Ascending)

Sharepoint List- Json for when a text column is not Null change background color of the Name column

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)

 

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

Pages

Subscribe to RSS - Power Apps