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. 🙂
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.
Hope this helps
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:
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:
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.
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 😞
Check out the announcement of Power Platform content at Microsoft Ignite!
Join us for an in-depth look at the new Power Automate features and capabilities at the free Microsoft Business Applications Launch Event.
Features releasing from October 2020 through March 2021