PowerApps - Avoid Delegation warnings using Search in Power Automate, and Parse output JSon

preview_player
Показать описание
This video explains how to search large dataset (SharePoint List) in Power Canvas App without giving Delegation warnings.
Video also explains how to Parse result using String Operation without using Experimental ParseJson Method.

Sample Formuale & Function
----------------
Set(flowOutPut,Split(SearchFinancialFlow.Run(TextInput1.Text).output,"|"));
Clear(financialColl);
ForAll(flowOutPut,
Collect(financialColl,
{
Country:Last(Split(Last(FirstN(Split(ThisRecord.Value, ","), 1)).Value,":")).Value,
Product:Last(Split(Last(FirstN(Split(ThisRecord.Value, ","), 2)).Value,":")).Value,
UnitSold:Substitute(Last(Split(Last(FirstN(Split(ThisRecord.Value, ","), 3)).Value,":")).Value,"}","")
}
)
)
Рекомендации по теме
Комментарии
Автор

Thank you for this helpful method. Looking forward to the next related video about Parse JSON.

geralddahl
visit shbcf.ru