Forum Discussion
Deleted
Dec 23, 2017Delegation Woes - Workaround needed for Filtering on a SharePoint Choice Field
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 ...
Kurt Marvin
Jan 15, 2018Copper Contributor
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.
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.