Then, I have a button using ClearCollect and ForAll against a table of stores to create a table of tasks with one row per store. That is displayed in a gallery for a preview. Then, a button uses another ForAll and a Patch function to write it all into a ShareP...
Anyway, don't want to get in too much, but Collections are nice, especially to cache and work off that data, you can easily use a command like ClearCollect(LocalCollectionname,'dbo.datatable') and quickly create a collection, and then manipulate th...
ForAll(Sequence(CountRows('Staff Name')),Patch('Clinical Supervision',Defaults('Clinical Supervision'),{'Staff Name': Last(FirstN('Staff Name',Value)).Result,'Job Title': Last(FirstN(JobTitle,Value)).Result,Email: Last(FirstN(Email,Value)).Result,...
Question 1:Is there a way to use GroupBy and other non-delegating functions in the app while still accessing the entire SharePoint List (instead of the app only collecting the first 500 entries, which is the limitation we have right now). If Not, Question 2:Is...
1/ In PowerApps an Input Task item is created and saved. 2/ A button runs a ForAll function for each item in the Store List. It creates a table (collection?) with the Store Number plus the field from the input task list. 3/ this populated table is displayed in a galle...
1/ In PowerApps an Input Task item is created and saved. 2/ A button runs a ForAll function for each item in the Store List. It creates a table (collection?) with the Store Number plus the field from the input task list. 3/ this populated table is displayed in ...
ForAll(Sequence(CountRows('Staff Name')),Patch('Clinical Supervision',Defaults('Clinical Supervision'),{'Staff Name': Last(FirstN('Staff Name',Value)).Result,'Job Title': Last(FirstN(JobTitle,Value)).Result,Email: Last(FirstN(Email,Value)).Result,'...
ForAll( Sequence(CountRows('Staff Name')), Patch( 'Clinical Supervision', Defaults('Clinical Supervision'), { 'Staff Name': Last( FirstN( 'Staff Name', Value ) ).Result, 'Job Title': Last( FirstN( JobTitle, Value ) ).Result, ...
Update 28/07 Looking at the SP site recently, the 'weird' characters seemed to have changed to just which seems to suggest this is an HTML issue but not sure how as no HTML is used in the formula??? Please clickMark as Best Response&...
(0, 0%, 100%, 0.5)","keywordColor":"#0076a9","functionColor":"#d3284b","variableColor":"#c14700","__typename":"PrismThemeSettings"},"rte":{"bgColor":"var(--lia-bs-white)","borderRadius":"var(--lia-panel-border-radius)","boxShadow":" var(--lia-p...