web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / HELPPPPPPPP MSFlow >...
Power Automate
Unanswered

HELPPPPPPPP MSFlow > Excel

(0) ShareShare
ReportReport
Posted on by

Hello Guys 

 

So I have created this form 

forms.PNG

 

For ever house we have onsite and i need the ms form to update this excel sheet 

table.PNG

 

I have made this flow 

1.PNG2PNG.PNG

 

the string in the  filter array = string(outputs('Get_response_details')?['body/r3e3ed22d1fdc4815ab674f3a4e9cfe2b'])

the condition field is = empty (body('Filter_array'))

 

the idea being ever house gets a ms form to fill in ever month and depending on if the date is the same/empty  it will update the row or it will create a new row 

 

the problem is when i run this i get this error 

3.PNG

and it dosnt update at all it just add a new row all the time 

 

4.PNG

 

More info below 

 

5.PNG

6.PNG

7.PNG

 

Categories:
I have the same question (0)

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 525 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 324 Moderator

#3
abm abm Profile Picture

abm abm 232 Most Valuable Professional

Last 30 days Overall leaderboard