Update/create new item in a Calendar List based on excel file

(0) Share

Report

Posted on by Francesca2

Hi, I have an excel file that I want to use to update or create a List only if a specific value matches (Class ID).

I've build a scheduled flow that runs once a day.

I got excel data with "List Rows", then I got list items with "Get items", and I compared the value "Class ID" using a Condition (screenshots "Condition"). If condition is true the list should be updated with Update Items, if false I've no actions and then I terminate

In my test I've 3 rows in excel and 2 rows in the list, and I have only a Class ID match.

The flow runs successful, but the condition is not working and does not recognize the match (screenshot "Not Specified").

I've tried to add a compose to format as a string the Class ID in both the excel and the list and compare them, but I get the same issue.

Can anyone help?

Categories:

Building flows

NotSpecified.JPG

Condition.JPG

I have the same question (0)

All responses (4)

Answers (1)

Verified answer

v-jefferni on at

Like (0)

Report

Hi @Francesca2 ,

Didn't know how you create your flow, but I made flow with different logic for your reference:

Best regards,

Was this reply helpful? Yes No
Francesca2 7 on at

Like (0)

Report

Hi @v-jefferni , thanks for the help! I changed the logic and I was able to update the items in my list.
Now I was thinking to add a branch or to create a separate flow to create new items that are in the excel file, but not in the list. Do you think it's the right approach?

Was this reply helpful? Yes No
v-jefferni on at

Like (1)

Report

Hi @Francesca2 ,

You can use create item action in the if no branch to add items in Excel table but not in the list to the list.

Best regards,

Was this reply helpful? Yes No
Francesca2 7 on at

Like (0)

Report

Hi @v-jefferni, I've used create item action in the if no branch, but the condition runs as true and the item is not created. Any other advice?

Lenght.JPG

ConditionNotMet2.JPG

ConditionNotMet.JPG

Was this reply helpful? Yes No