Unanswered

Power Automate Sharepoint apply to each greyed out but flow succesful (no results)

(0) Share

Report

Posted on by WCEDsystems

I have a flow that when an item is updated within one list, grabs the rest of the information on the secondary list and populates some Word Files. There are two lists that are used for this, one that has all the quotes and the other that has all the notification details.

I get the address from the quote that was updated and then I get the notification from the other list by using Filter Query field_2 eq 'ADDRESS'.

Items that do not require the notification details generate just fine, but all the other word files enter an apply to each loop and while running are greyed out and do not produce any doc files. What is the issue here? Why can I not see what the error is within the apply to each loop?

I'm only a beginner so any help would be greatly appreciated! Thanks

Categories:

Using flows

Screenshot 3.png

Screenshot 1.png

Screenshot 4.png

I have the same question (0)

All responses (5)

Answers (1)

Verified answer

v-jefferni on at

Like (0)

Report

Hi @WCEDsystems ,

It's due to no outputs from the Get items action. Are you sure there is exact same Address value in the second list as in the variable? What's the variable value in the history?

Best regards,

Was this reply helpful? Yes No
WCEDsystems 36 on at

Like (0)

Report

Far out, it was a data validation issue, the addresses were different!

@v-jefferni I have some weird addresses that have apostrophes in them - 24 O' Brien Street in example. What's the best way to transform this address to work with flows? I'll need the address printed at it's original state once the flow is finished.

Thanks for your help!

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

Like (0)

Report

Hi @WCEDsystems ,

In which list the Address column values include apostrophes, one or both?

Best regards,

Was this reply helpful? Yes No
WCEDsystems 36 on at

Like (0)

Report

This issue should be present in both lists. Each job on the Jobs sharepoint list will have a notification record on the "notifications" list.

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

Like (0)

Report

Hi @WCEDsystems ,

I think you can use Filter array so you can use expressions to remove apostrophes from both sides.

Best regards,

Was this reply helpful? Yes No