cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Anonymous
Not applicable

Delegation with Sharepoint

Hi,

 

I know this question have been asked alot of times before but I can't seem to find a proper answer to this one and would really appriciate if someone can help me with this. So I am using the following formula:

 

If(IsBlank(SelectedServiceProvider) && IsBlank(SearchBoxText.Text), Filter('BI Services List_5', Vertical = SelectedVertical),!IsBlank(SelectedServiceProvider) && !IsBlank(SearchBoxText.Text), Filter('BI Services List_5', StartsWith(Product,SearchBoxText.Text) && Vertical = SelectedVertical && ServiceProvider = SelectedServiceProvider),!IsBlank(SearchBoxText.Text) && IsBlank(SelectedServiceProvider),Filter('BI Services List_5', StartsWith(Product,SearchBoxText.Text) && Vertical = SelectedVertical), !IsBlank(SelectedServiceProvider) && IsBlank(SearchBoxText.Text), Filter('BI Services List_5', Vertical = SelectedVertical && ServiceProvider = SelectedServiceProvider))

 

Where SelectedVertical is a variable from previous screen and SelectedServiceProvider is a variable from my filter screen. The code ssems to work fine for some of the records so I think that this is right but it does not show all of the information - due to which I think the issue is due to delegation. Is there a workaround for my formula without changing the code.

 

Thanks in advance. 🙂

6 REPLIES 6
Anonymous
Not applicable

Re: Delegation with Sharepoint

When I say that it does not show all the information I mean it does not seeem to work for all the records in the sharepoint. thanks

Dual Super User
Dual Super User

Re: Delegation with Sharepoint

Hi

Have you identified an example of a SP List record that is not currently working? If so, I usually recommend to go to Run History, select the Flow execution that failed, and inspect the output of the action block/trigger that is providing SP list item content as output.

If the column is not there, you will probable need to consider the result is NULL. If so, as far as I know, there is a workaround that is to use the function coalesce() from WorkFlow DEscription Language to deal with NULL values.

https://docs.microsoft.com/en-us/azure/logic-apps/logic-apps-workflow-definition-language

 

Hope this helps





If anybody solved your question, remember to mark its post as a solution!

Proud to be a Flownaut!





Community Support Team
Community Support Team

Re: Delegation with Sharepoint

Hi @usmanijaz,

 

Do you type the formula that you provided in formula box of a PowerApps app?

How many records stored in your SharePoint list?

Further, how many records display in the screen of your PowerApps app?

 

The limit of the amount of data that can be processed locally is 500 records. If the amount of records is more than 500, the first 500 records would be scanned. If the desired record number is more than 500, these records would not be considered or returned by Filter function.

 

In addition, the if function tests one or more conditions until a true result is found. If a true result is found, a corresponding value is returned. The formula that you provided would filter records based on If conditions. More details about If function, please check the following article:

If function in PowerApps

 

Please check if the formula that you provided would filter records that you desired based on If condition.

 

More details about Delegation in PowerApps, please check the following article:

Delegation

 

 

Best regards,

Kris

Community Support Team _ Kris Dai
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Anonymous
Not applicable

Re: Delegation with Sharepoint

Thank you @v-xida-msft for your reply.

 

Yes I typed that formula in the formula box of powerapp on gallery. I have 560 records in total on sharepoint. But I do think that my formula is fine and not sure to why is it not working with all the rows in sharepoint but just with some. And as you mention about the If Function - Is my formula not right according to that? 

 

Thanks in advance for all the help.

 

Kind Regards,

Usman

Anonymous
Not applicable

Re: Delegation with Sharepoint

Hi @efialttes Thank for the reply. Yes I know few of the rows that are not working with the app. I am not sure what this run history is and how to go through with workflow definition langauge and where to apply it 😞 

Dual Super User
Dual Super User

Re: Delegation with Sharepoint

Hi again

I thought you were implementing a Microsoft Flow, but finally realized you are using powerapps.

Sorry for the misunderstanding





If anybody solved your question, remember to mark its post as a solution!

Proud to be a Flownaut!





Helpful resources

Announcements
thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

firstImage

Incoming: New and improved badges!

We've given our badges an overhaul and also added some brand new ones!

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

sixthImage

Power Platform World Tour

Find out where you can attend!

seventhimage

Webinars & Video Gallery

Watch & learn from the Power Automate Community Video Gallery!

Users Online
Currently online: 78 members 4,340 guests
Please welcome our newest community members: