Answered

Use the split function in a gallery or other alternative

(0) Share

Report

Posted on by SeguM

Hi everyone,

I need help with a problem. I'm trying to use the Split function in a Gallery that has a SharePoint list as its data source. The problem I'm having is that the field I'm trying to apply the function to isn't text and therefore doesn't allow me to do the job.

Filter(
 DDBB; HRBP = "HRBP - OK";
 )

In this example I use Filter to filter the gallery, where I want to select by the word HRBP that is equal to "HRBP", but only up to "-". Therefore there is no way that it works: It does not work like this:

Filter(
 DDBB; HRBP = First(Split("HRBP - OK","-"));
 )

The sharePoint field containing "HRBP - OK" is STATUS Any idea how it could be solved? thank you

Categories:

Building Power Apps

I have the same question (0)

All responses (11)

Answers (1)

Sort by

Clue 187 on at

Like
a
(0)

Report
Copy link

Link copied!
If the case is that the text always is in the beginning you can use StartsWith([full text], [beginning of text to check]). StartsWith() will return true or false.
Filter( DDBB; StartsWith("HRBP - OK", HRBP) )

Was this reply helpful? Yes No
SeguM 90 on at

Like
a
(0)

Report
Copy link

Link copied!

Thank you very much for your answer Clue,
The problem is that the data are variable.
Thank you

Was this reply helpful? Yes No
Clue 187 on at

Like
a
(0)

Report
Copy link

Link copied!

Alright, you can either use the "in" operator to see if a certain text is within a field or "StartsWith" if the text you are looking for is always at the beginning.
If you require more assistance, please share a screenshot of the filter and provide more information and details about what you are doing:)

Was this reply helpful? Yes No
SeguM 90 on at

Like
a
(0)

Report
Copy link

Link copied!
I've managed to make it work for me, and it does it correctly. The only problem is that it displays delegation warnings.

Filter( DDBB; HRBP =Left(Fase;Find(" - ";Fase)-1); )

I guess the problem is the Left and Find functions, but I think there is no alternative.

Was this reply helpful? Yes No
v-bofeng-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Segu1 ,

Based on your description of your needs, I'm afraid delegation warnings are inevitable. Please check this link:

Power Apps delegable functions and operations for Dataverse

Best Regards,

Bof

Was this reply helpful? Yes No
Clue 187 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Segu1, I'm not sure that is the best way to do it. StartsWith() should be an alternative. If you could provide a screenshot of the code that would help in solving the problem:)
Thank you!

Was this reply helpful? Yes No
Clue 187 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @v-bofeng-msft,
As @Segu1 specified, they are using SharePoint Lists as their data source. So while you are correct in that the functions are not listed as delegable, the link you provided is for Dataverse.

Here is the one for SharePoint: SharePoint - Connectors | Microsoft Learn

StartsWith() Should be an option for the method they're using as the text seems to be positioned at the start of the string.

Was this reply helpful? Yes No
SeguM 90 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi Clue,
I'm trying to upload an example, however the string to extract is variable, for example it could be like this:

Filter( DDBB; STATUS =Left(Fase;Find(" - ";Fase)-1); )

STATUS can be HRBP, or Manager.... And Fase would be, for example, HRBP - OK, Manager - OK, Manager - KO....

Filter when start to delimiter matches STATUS.

I think I have explained myself better now

Was this reply helpful? Yes No
Verified answer

Clue 187 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi,
I hope this helps as a solution for you:
Code:
Filter( DDBB; StartsWith(Fase, STATUS) )

Please get back to me if this worked! 🙂

Was this reply helpful? Yes No
SeguM 90 on at

Like
a
(1)

Report
Copy link

Link copied!

Thank you very much, it's perfect, the warnings have already disappeared.

👌😉

Was this reply helpful? Yes No