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

Community site session details

Session Id :
Power Automate - Building Flows
Unanswered

Post Adaptive Card and Wait for a response - with Excel file from Sharepoint with lots of Emails to send at once

(0) ShareShare
ReportReport
Posted on by 8

I have a recurring flow that:

 

- List Rows in an excel table being pulled from an excel file in Sharepoint Documents.

- Apply to each - value from body/each of the above Listed Rows.

- Condition that if the Sent date/time column contains No, then Yes it is true and below actions:

- Post an adaptive card and wait for a response

- Update a row - to update the Sent column to utcNow()

 

The issue is - it runs perfectly... except, on my excel file, I have hundreds of rows of different emails... and it waits for the first email to submit their response on the adaptive card prior to moving to the second..... and so on... and so on.... 

I will be continuing to add emails to this list.  And I need to them to all send at the same time.

 

Can you help me please?

I have the same question (0)
  • ManishSolanki Profile Picture
    15,089 Super User 2025 Season 2 on at
    Re: Post Adaptive Card and Wait for a response - with Excel file from Sharepoint with lots of Emails to send at once

    Hi @hiltgena 

     

    You could use an alternative action 'Post card in a chat or channel' which would not pause the execution of the flow:

    ManishSolanki_0-1709873139463.png

     

    In that case, you need to set up a separate automate flow to capture each response. You need to select the trigger as 'When someone responds to an adaptive card'. To get the row identifier from each response, you could set the value in the read only or hidden text field and use the same in automate flow for updating the row in excel after user respond.

     

     

    If this helps & solves your problem, please remember to give a 👍 and accept my solution as it will help others in the future.

     

  • hiltgena Profile Picture
    8 on at
    Re: Post Adaptive Card and Wait for a response - with Excel file from Sharepoint with lots of Emails to send at once

    So what is interesting.... I just saw a video referencing this trigger "When someone responds to an adaptive card"... But I do not have this????  How do I get this?  Any ideas?

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Chiara Carbone – Community Spotlight

We are honored to recognize Chiara Carbone as our Community Spotlight for November…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 560 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 347 Moderator

#3
Expiscornovus Profile Picture

Expiscornovus 262 Most Valuable Professional

Last 30 days Overall leaderboard