cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
gmeunier
Frequent Visitor

Issue on special characters

Hi everyone,

 

To make it simple, I created a list in which I store Teams Name and ID.

I want to update that List only with newly created Teams.

 

Thus I have one filter on the Teams ID which looks like something 89765-ehk8-...

Therefore I add brackets but still I do not get the right output, the filter just does not work.

 

If I filter on the name (though not recommended) I get the same issue if the name has spaces inside or special characters.

 

The condition expression is the following : empty(body('Obtenir_les_éléments_2')?['value'])

 

gmeunier_0-1614210976590.png

 

Any help appreciated !

 

Gerald

 

1 ACCEPTED SOLUTION

Accepted Solutions
Masa_
Helper I
Helper I

@gmeunier 

Step 1 Add Apply to each.

Step 2 Move or create a condition inside Apply to each and try the empty function below.
Note: Overwrite the ['Column_name'] with the column name in your sharepoint list.

 

empty(items('Apply_to_each')?['Column_name'])

 

Below is a sample

2021-02-25_13h27_24_result.jpg

 

2021-02-25_13h48_15.png

 

2021-02-25_13h28_10_result.jpg

 

2021-02-25_13h28_19_result.jpg

 

2021-02-25_13h28_32_result.jpg

 

--------------------------------
If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

View solution in original post

2 REPLIES 2
Masa_
Helper I
Helper I

@gmeunier 

Step 1 Add Apply to each.

Step 2 Move or create a condition inside Apply to each and try the empty function below.
Note: Overwrite the ['Column_name'] with the column name in your sharepoint list.

 

empty(items('Apply_to_each')?['Column_name'])

 

Below is a sample

2021-02-25_13h27_24_result.jpg

 

2021-02-25_13h48_15.png

 

2021-02-25_13h28_10_result.jpg

 

2021-02-25_13h28_19_result.jpg

 

2021-02-25_13h28_32_result.jpg

 

--------------------------------
If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

View solution in original post

gmeunier
Frequent Visitor

Hi there,

 

Thank you for your input, I did make it work your style. It has effectively nothing to do with characters.

I am a newbie with power automate and its logic has its own logic to me sometimes.

 

The full Flow

 

gmeunier_0-1614251870450.png

 

gmeunier_1-1614251938787.png

gmeunier_2-1614252074508.png

 

gmeunier_4-1614252237117.png

gmeunier_5-1614252312896.png

 

 

 

 

Helpful resources

Announcements
User Groups Public Preview

Join us for our User Group Public Preview!

Power Automate User Groups are coming! Make sure you’re among the first to know when user groups go live for public preview.

New Super Users

Meet the Power Automate Super Users!

Many congratulations to the Season 1 2021 Flownaut Crew!

Power Platform ISV STudio

Power Platform ISV Studio

ISV Studio is the go-to Power Platform destination for ISV’s to monitor & manage applications post-AppSource publish.

Users online (67,936)