cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
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
Highlighted
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

Highlighted
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



Each time you click on any of our inspiring answers 'Thumb up' icon...
...an ewok scapes from the stormtroopers.

Be grateful, Thumbs up! Save the Galaxy for free!


Escribo sobre Power Automate en:
https://medium.com/anyone-can-automate/

Proud to be a Flownaut!



Highlighted
Community Support
Community Support

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.
Highlighted
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

Highlighted
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 😞 

Highlighted
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



Each time you click on any of our inspiring answers 'Thumb up' icon...
...an ewok scapes from the stormtroopers.

Be grateful, Thumbs up! Save the Galaxy for free!


Escribo sobre Power Automate en:
https://medium.com/anyone-can-automate/

Proud to be a Flownaut!



Helpful resources

Announcements
firstImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

firstImage

Join the new Power Virtual Agents Community!

We are excited to announce the launch of Power Virtual Agents Community. Check it out now!

firstImage

New & Improved Power Automate Community Cookbook

We've updated and improved the layout and uploading format of the Power Automate Cookbook!

thirdimage

Power Automate Community User Group Member Badge

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

Top Solution Authors
Top Kudoed Authors
Users online (11,473)