PowerApps - Avoid Delegation warnings using Search in Power Automate, and Parse output JSon
Автор: M365 & Modern Tech Hub
Загружено: 2023-04-19
Просмотров: 1180
Описание:
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,"}","")
}
)
)
Повторяем попытку...
Доступные форматы для скачивания:
Скачать видео
-
Информация по загрузке:
