Easy conditions, i need your help

(0) Share

Report

Posted on by Community Power Pla...

Hi everyone,

I would like to share you my issue. It's incredible but i don't want to waste more time.

The meaning of this flow is to collect data from sharepoint list, and to put it in a excel file.

this is seems to be easy, but it's not because, i have a condition. If a value equals 1, last line sharepoint list data filled the row line in excel completly, and if it equals 2, just a half line.

the systems don't see my condition. each, it goes even if data fulfiled the first choice.

The results of the turn, it's success. So i can't show you, error message. Please, help, i had to resolve it next week.

it's in french, in my example, you can see that my condition is begin by, but before, i tested with equals (there is an error, data from sharepoint list it is string) and contains, but nothing happens.

thanks by advance for all the pepole would like help me.

Categories:

General topics

I have the same question (0)

All responses (15)

Answers (0)

Nived_Nambiar 18,136 Super User 2025 Season 2 on at

Like (0)

Report
Copy link

Link copied!

Hi @Anonymous

Sorry i did not get your question properly, could you explain it better ?

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report
Copy link

Link copied!

Hi @Nived_Nambiar

Thank you very much for your attention to my problem.

Let me rephrase that. I need to transfer lines from a sharepoint list into an Excel table. There are two variables in the sharepoint list that are important, and I'm going to call them Variable1 and Variable2.
There are 2 possible cases, either Variable1 = 1 and Variable2 = 3 or 4, in which case I only transfer half of the sharepoint list line to the excel table. If Variable1 = 2 and Variable2 = 1 or 2, then I fill in the whole line.
My problem is that in the second case, even if I have the corresponding values, it never enters this choice. In the condition, I have the impression that I've tried everything with (contain, begin with,...)
I need to render this stream as quickly as possible, it's already expected.

Was this reply helpful? Yes No
GdarmonAbra 77 on at

Like (1)

Report
Copy link

Link copied!

Hi,
You can try considering working with filter array instead of Case.
Use data operations in Power Automate (contains video) - Power Automate | Microsoft Learn
and use conditions on the filter arry - example for the second case
@And(equals(item()?['Variable1 '],2),@or(equals(item()?['Variable2 '], 1,equals(item()?['Variable2 '], 2)))
Br,
Gill

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report
Copy link

Link copied!

Hello, I'm coming back to you because I don't understand. Using "compose", I have defined variable names for the output values of the array. (Variable1 et Variable2).
The last operation on my values is to remove any spaces.
And then it displays this message even though I only have "string" type values.
What should I do? I want to compare these values and make my "Yes" choice possible.
Thanks in advance for your feedback.

Was this reply helpful? Yes No
VictorIvanidze 13,079 on at

Like (0)

Report
Copy link

Link copied!

Show the action Choix... in the edit mode.

Was this reply helpful? Yes No
GdarmonAbra 77 on at

Like (0)

Report
Copy link

Link copied!

please share more info on you data source,
what is the input from SharePoint ?

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report
Copy link

Link copied!

Yes, these are lines imported from a sharepoint list, and the values in this sharepoint list are answers to questions from a Forms.
I don't control the type of my data, which is why I've included it in these variables.

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report
Copy link

Link copied!

Hi, is it ok ?

Was this reply helpful? Yes No
VictorIvanidze 13,079 on at

Like (0)

Report
Copy link

Link copied!

No, I've asked for action "Choix si Claims ou non" in edit mode.

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report
Copy link

Link copied!

I changed the values coming from the sharepoint list directly to variables (with a string type).
And in a second step, I've added an operation where I remove spaces from strings. I thought it might have come from there.

Was this reply helpful? Yes No