Jehanne @ Tech/Home DIY Lv1

Tech/Home DIY Lv1, main as @minomiyabi #PowerApps #PowerAutomate #PowerPages #Sharepoint #HomeDIY 初心者備忘録ですが一助となれば。Hope my notes help someone! 🇺🇸🇯🇵

[Jehanne @ Tech/Home DIY Lv1 @jehanne_tech]

Hello World! I’m an illustrator/animator but I sometimes work for very light levels of engineering based on #PowerApps #PowerAutomate (#MicrosoftFlow) #Sharepoint for necessary reasons. Here I leave solutions found. Love to #Follow each other so can be more helpful! 🇯🇵👇

[Jehanne @ Tech/Home DIY Lv1 @jehanne_tech]

[MEMO] #PowerApps Type Def when importing JSON data - Before casting to non-text type you need Text cast first : e.g. Boolean(Text(Value.FeePaid))
Think this initial Text not as casting, but vessel to let App correctly recognize what it gets.

[Jehanne @ Tech/Home DIY Lv1 @jehanne_tech]

2022..ok 🙃
https://t.co/UhVPUjQBvk

[Jehanne @ Tech/Home DIY Lv1 @jehanne_tech]

[MEMO] Select Nth item in a gallery #PowerApps
Select(Gallery1, N)
Is this a new feature or they had it long ago? I was creating a column to bool on/off all the time til now... 初歩恥…え、でもどこにも文献なかったよ(T-T) ちなみに第三引数にはChild Controlを指定できるらしい。。

[Jehanne @ Tech/Home DIY Lv1 @jehanne_tech]

[MEMO] Kinda Stop-moaning stuff x2 #PowerApps :
- ComboBox: default selected items: Using { } is for the selection display column only. You match "value" but show "name": Filter(col, value=#) not {value:#}
- Patch: wanna use self column? Use With to context

[Jehanne @ Tech/Home DIY Lv1 @jehanne_tech]

[MEMO] User-Defined Function really makes work wiser. By UDF types in Settings you can custom your own type like Record or Table. 大量のコンポーネントで煩雑になっていたアプリ内がスマートに（そして若干速くなった??）効率と歩幅がアップ！#PowerFx #PowerApps
https://t.co/qA1NByiDoS

[Jehanne @ Tech/Home DIY Lv1 @jehanne_tech]

・ #PowerAutomate Child Flowにメール送信はタブー?　親でそのフロー呼んだ時に「Update the child flow for action to end with a response action」と怒られる。単にRespondつけても変わらず、メールアクションを外すと通る。末尾にしか入れてないので途中に入れるとどうなるかは不明。

[Jehanne @ Tech/Home DIY Lv1 @jehanne_tech]

自分には難易度中の上なアプリ実装ラッシュで気づいたこと色々メモ：
・ #PowerApps グローバル変数・コンテキスト変数って格納ではなくラベリングが正しい考え方? (今更)
UpdateContextやSet以外の別所で変更されたらしっかり変わっていた (要検証) ※コレクションで応急した
続↓

[Jehanne @ Tech/Home DIY Lv1 @jehanne_tech]

Revision: I meant to say,
- RGBA to Hex :
JSON(RGBA(...) or UI color property, JSONFormat.IgnoreUnsupportedTypes)
=Double-quotated Hex (remove DQs by Substitute etc- Char(34) is ")

- Hex to RGBA :
Hex2Dec(each 2 digits of hex) for R, G, B, A

[Jehanne @ Tech/Home DIY Lv1 @jehanne_tech]

[MEMO] Dynamic Color Handling Basics #PowerApps
- from UI: JSON(###.Fill, JSONFormat.IgnoreUnsupportedTypes) = Hex (need to parse some chars)
- RGBA to Hex: ColorValue(RGBA(...)) = rgba hex (e.g. #33aa55ff)
- Hex to RGBA: Hex2Dec(each 2 digits of hex) for R, G, B, A

[Jehanne @ Tech/Home DIY Lv1 @jehanne_tech]

Using JSON detail: https://t.co/fHIM13Cuhj

[Jehanne @ Tech/Home DIY Lv1 @jehanne_tech]

コパ導入からずっと地味に作業を妨げて��たコイツの即席対処法😅 ソースからとりあえず消しとく（Chrome系ならInspect、"btnShellCopilotContainer"というHTMLエレメントを削除） #PowerApps

[Jehanne @ Tech/Home DIY Lv1 @jehanne_tech]

inline formatNumber() expression :
To keep leading zero placeholder, use 0 instead of # - like '00'. # skips when hits leading zero-s.
Jonathan from Pragmatic explains it:
https://t.co/wFvAIBHeuk

[Jehanne @ Tech/Home DIY Lv1 @jehanne_tech]

[MEMO] Wait, didn't int(1.23) work before? #PowerAutomate
int(float(1.23))もinvokeされるので、美しくないが…
-Round (四捨五入) ... Format Number (インライン formatNumber(), see link)
-RoundDown ... splitで小数点前とる
-RoundUp ... splitで小数点前とって +1
https://t.co/BOVRG4XsjE

[Jehanne @ Tech/Home DIY Lv1 @jehanne_tech]

PowerApps V2トリガーになって表れたFileインプットでフロー実装。上記不安定な件を別角度から解決できそう
https://t.co/YW4Xwoyh2N

[Jehanne @ Tech/Home DIY Lv1 @jehanne_tech]

#PowerApps #PowerAutomate Multiple Email Attachments - dataUriToBinary(<ATTACHMENT_ITEM>['File']) sometimes does/doesn't write the file data correctly. When not working, adding ?['$content'] goes well as I resolved it weeks ago. Are they fixing right now? 日本語コメ欄>

[Jehanne @ Tech/Home DIY Lv1 @jehanne_tech]

先日つぶやいたFlow経由のEメール複数添付の件： 一部"正常"にbase64のデータ部分だけを抽出しなくても単に dataUriToBinary(<添付アイテム>['File']) で通るようになった。が一部はやはり $contentを抜き取らないと、ファイル実体は受信するも���の中味が読めないFlowもある。MS側で現在修繕中とか??

[Jehanne @ Tech/Home DIY Lv1 @jehanne_tech]

Office: DAY OFF!! #Microsoft365
Tech: Good news, each cloud is working😇
Office: YOU🫠💀🎃🪦
#PowerPlatform

[Jehanne @ Tech/Home DIY Lv1 @jehanne_tech]

Solved with Azure Functions.
https://t.co/NlvZRZFilY
With AF's HTTP Trigger with a little simple code that passes request, the intuit's host app can shoot the webhook to the shorter AF-issued URL as a proxy.
Azure Front Doorも試したがコスパ高なFunctionsでサクッと解決できた。

[Jehanne @ Tech/Home DIY Lv1 @jehanne_tech]

You may have received this - MS renewed endpoint URLs. My Intuit App for webhook does not support longer URL than 255 chars.
The old URL will be gone by Nov 30.
I tried to find workarounds. What else can I do??😭
https://t.co/1lgv4X9S1W #PowerAutomate #PowerPlatformCommunity

[Jehanne @ Tech/Home DIY Lv1 @jehanne_tech]

[MEMO] Not sure if official but many tell :
Displaying images in GDrive : Setting as anyoneWithLink doesn't work with the shared link/webContentLink/webViewLink - This gives charm : ttps://drive.google.com/thumbnail?sz=w[SIZE]&id=[FILE_ID]
*SIZE might matter for fast loading

[Jehanne @ Tech/Home DIY Lv1 @jehanne_tech]

[MEMO] Also to copy files locally in GDrive - Copy File connector is tricky at Source URL - If the file is restricted, Shared Link / webContentLink returns Sign In HTML even with the connectors signed in properly.
file.get & Create File connector was the workaround this time.

[Jehanne @ Tech/Home DIY Lv1 @jehanne_tech]

できないことに違和感があるなら基本を見直そう定期。
[MEMO] Get Blob content via GDrive API - file.get + alt=media
How could I ever miss that🫣
https://t.co/nsHIOGRAzb
#PowerAutomate #PowerPlatform #GoogleDrive #API

[Jehanne @ Tech/Home DIY Lv1 @jehanne_tech]

【覚書】#PowerAutomate each等ループ内でのconcat() インラインは遅い? Composeブロックで事前整形して使った方が半分以下の処理速度で済む。同フロー内での1ケース比較だけど何度か実証済。#PowerPlatform