Hello, this gallery filter isn't working and giving me
"You don't have permission to view this data"
The data source is Sharepoint, and I have full access, this is the formula:
SortByColumns( Filter( OnlineTickets, ClosedTickets=true Or (ClosedTickets=false And (OnlineTicketStatus="الطلب مفتوح" Or OnlineTicketStatus="تم التعامل" Or OnlineTicketStatus="الطلب مرسل" Or OnlineTicketStatus="انتظار العميل" Or OnlineTicketStatus="تم التجهيز" Or OnlineTicketStatus="تم التوثيق" Or OnlineTicketStatus="تم التوقيع")), VarUserRole.Text="Super" Or (VarUserRole.Text="Inputer" And (OnlineStageOneDepartmentName=VarUserDepartmentName.Text Or VarUserDepartmentName.Text=OnlineStageTwoDepartmentName Or VarUserDepartmentName.Text=OnlineStageThreeDepartmentName Or VarUserDepartmentName.Text=OnlineStageFourDepartmentName Or VarUserDepartmentName.Text=OnlineStageFiveDepartmentName Or VarUserDepartmentName.Text=OnlineStageSixDepartmentName Or VarUserDepartmentName.Text=OnlineStageSevenDepartmentName Or VarUserDepartmentName.Text=OnlineStageEightDepartmentName)), MyTickets=false Or (MyTickets=true And OnlineCurrentDepartmentName=VarUserDepartmentName.Text), ClosedTickets=false Or (ClosedTickets=true And OnlineCurrentDepartmentName="أرشيف"), IsBlank(TextInput2) Or (OnlineCustomerID=TextInput2.Text Or ID=Value(TextInput2.Text))) ,"ID", Descending)
When VarUserRole.Text is Super, it is working fine, but if I change it to Inputer, it won't work and give me this permission error.
Thanks
Stay up tp date on the latest blogs and activities in the community News & Announcements.
Dive into the Power Platform stack with hands-on sessions and labs, virtually delivered to you by experts and community leaders.
User | Count |
---|---|
213 | |
209 | |
85 | |
57 | |
36 |