Hsiang's Blog
Posts Tags Categories About
Hsiang's Blog
/blog/images/avatar-icon.png
/blog/posts/2023/power-automate-update-sharepoint-list-item-choice-column-and-difference-between-choices-and-distinct/switch-to-input-entire-array.png

Power Automate Update Sharepoint List Item Choice Column and Difference Between Choices and Distinct

Hsiang published on
Update Sharepoint List Item Choice Column power automate add record to sharepoint list choice Power Automate - Microsoft Forms & SharePoint choice field (multi-select) updates You can update the choice list item by this: Or you can check out this article: Microsoft Flow - populate a multi choice field in SharePoint - Office 365 Basics TL;DW Make sure you can generate the following cell value/item: 1 2 3 { "Value": "<iterated item>" } But like Destroyzer mentioned:
Read More
 Sharepoint, Choices, Column, Distinct, Combobox
/blog/posts/2023/power-automate-openai-connector-and-how-to-standardize-the-chatgpt-response-to-json-format/share-it-as-a-link.png

Power Automate OpenAI connector and How to Standardize the ChatGPT Response to JSON Format

Hsiang published on
OpenAI Connector OpenAI (Independent Publisher) - Connectors | Microsoft Learn The OpenAI IP Connector is a tool that allows you to use GPT-3 to complete your prompts in Microsoft Learn. You can write a partial sentence or paragraph and let GPT-3 generate the rest of the text based on your style and tone. You can also adjust the parameters such as creativity, length and temperature to fine-tune the output. The
Read More
 Power Automate, OpenAI, ChatGPT, Json, Json Schema
/blog/posts/2023/cant-display-data-after-addcolumns-to-a-datasource/Explicit-column-selection.png

Can't display data after addcolumns() to a datasource

Hsiang published on
Problem Re: Can’t display data after addcolumns() to a dat… - Power Platform Community (microsoft.com) Here is the table: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 With( { isnotteamhead: First(colSession).CurrLevel <> "RO", isnotbanker: First(colSession).CurrLevel <> "Banker", ro: First(colSession).CurrTeam, banker: First(colSession).CurrBanker }, Search( AddColumns( GroupBy( Filter( WAM_Trade_Summarizes, FinalDate_yyyymm in ComboBoxTradeFinalDate.SelectedItems, (isnotteamhead || RO_gb=ro), (isnotbanker || GroupBanker_gb=banker) ), "crfb8_statement_prod_type_gb", "rest" ), "total_income", Sum(rest, Final_Rev_gb), "total_aum", Sum(rest, Total_amount_gb) ), SearchTypeRevenue.
Read More
 Powerapps, Connecting To Data, Creating Apps, General Questions, Using Apps Using Formulas
/blog/posts/2023/powerapps-not-in/featured-image.jpg

PowerApps `not in`

Hsiang published on
Photo by Sigmund on Unsplash “not operator along with the custom named condition operators is not allowed” Operator <> or NOT In. In and Exactin For example in an Items of Gallery : 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 With( { userlevel_isnot_banker: First(colSession).UserLevel <> "Banker", isnotteamhead: First(colSession).CurrLevel <> "RO", isnotbanker: First(colSession).CurrLevel <> "Banker", ro: First(colSession).
Read More
 Powerapps, not in, Operators, Powerplatform, Microsoft