Delegation Woes - Workaround needed for Filtering on a SharePoint Choice Field

%3CLINGO-SUB%20id%3D%22lingo-sub-139741%22%20slang%3D%22en-US%22%3EDelegation%20Woes%20-%20Workaround%20needed%20for%20Filtering%20on%20a%20SharePoint%20Choice%20Field%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-139741%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20a%20simple%20Workforce%20Task%20Tracking%20App%20I%20build%20with%20a%20couple%20custom%20lists.%20A%20key%20field%20is%20the%20Status%20column%20which%20indicates%20if%20a%20task%20is%20Not%20Started%2C%20Started%2C%20or%20Complete.%20For%20reporting%20on%20each%20task%2C%20I%20need%20to%20pull%20in%20a%20record%20set%20of%20tasks%20by%20Status.%20I%20am%20using%20the%20phrase%20below%20in%20my%20formula.%20I%20am%20getting%20the%20blue%20squiggly%20that%20that%20Status.Value%20is%20not%20delegate-able.%26nbsp%3B%20Any%20options%20to%20bypass%20this%3F%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CPRE%3EFilter('Store%20Task%20Template'%2CStatus.Value%3D%22Complete%22)%3C%2FPRE%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-139741%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EPowerApps%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESharePoint%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-145244%22%20slang%3D%22en-US%22%3ERe%3A%20Delegation%20Woes%20-%20Workaround%20needed%20for%20Filtering%20on%20a%20SharePoint%20Choice%20Field%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-145244%22%20slang%3D%22en-US%22%3E%3CP%3ETo%20get%20round%20Delegation%20woes%2C%20I%20have%20been%20adding%20my%20SharePoint%20List%20information%20to%20a%20Collection%20within%20the%20App.%20I%20then%20use%20the%20Collection%20data%20within%20Galleries%20but%2C%20connect%20the%20Forms%20to%20SharePoint%20Lists%20so%20when%20you%20do%20a%20select%20from%20a%20Gallery%2C%20the%20Form%20is%20already%20filtered%20to%20the%20correct%20SharePoint%20List%20ID.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-145031%22%20slang%3D%22en-US%22%3ERe%3A%20Delegation%20Woes%20-%20Workaround%20needed%20for%20Filtering%20on%20a%20SharePoint%20Choice%20Field%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-145031%22%20slang%3D%22en-US%22%3EDelegation%20in%20SharePoint%20with%20powerapps%20is%20very%20limited.%20How%20I%20got%20around%20this%20issue%20is%20to%20create%20another%20text%20column%20on%20the%20SharePoint%20list%20(ex%20StatusValue).%20Then%20use%20a%20Microsoft%20flow%20that%20triggers%20whenever%20a%20SharePoint%20item%20is%20created%20or%20modified%20that%20will%20copy%20the%20Status%20value%20into%20the%20newly%20created%20StatusValue%20column.%20Now%20in%20powerapps%20set%20your%20filter%20to%20use%20the%20StatusValue%20column.%3CBR%20%2F%3E%3CBR%20%2F%3EYou%20may%20be%20able%20to%20get%20away%20without%20the%20flow%20if%20everyone%20will%20be%20accessing%20the%20date%20from%20a%20powerapps.%20In%20that%20case%20you%20could%20just%20set%20the%20StatusValue%20right%20from%20within%20powerapps.%3C%2FLINGO-BODY%3E
Highlighted
Deleted
Not applicable

I have a simple Workforce Task Tracking App I build with a couple custom lists. A key field is the Status column which indicates if a task is Not Started, Started, or Complete. For reporting on each task, I need to pull in a record set of tasks by Status. I am using the phrase below in my formula. I am getting the blue squiggly that that Status.Value is not delegate-able.  Any options to bypass this?

 

Filter('Store Task Template',Status.Value="Complete")
2 Replies
Highlighted
Delegation in SharePoint with powerapps is very limited. How I got around this issue is to create another text column on the SharePoint list (ex StatusValue). Then use a Microsoft flow that triggers whenever a SharePoint item is created or modified that will copy the Status value into the newly created StatusValue column. Now in powerapps set your filter to use the StatusValue column.

You may be able to get away without the flow if everyone will be accessing the date from a powerapps. In that case you could just set the StatusValue right from within powerapps.
Highlighted

To get round Delegation woes, I have been adding my SharePoint List information to a Collection within the App. I then use the Collection data within Galleries but, connect the Forms to SharePoint Lists so when you do a select from a Gallery, the Form is already filtered to the correct SharePoint List ID.