Skip to main content

Notifications

Power Apps - Power Apps Pro Dev & ISV
Unanswered

Flow is triggered but still doesnt work properly

(0) ShareShare
ReportReport
Posted on by 4

Hello,

I have created a flow in Power Automate (added to solution in Power Apps) that is triggered when a column in Dataverse connected to Dynamics 365 is modified.
After being triggered by a change in one table, the flow lists rows in another one to search for a specific record.
Then, the change is applied also to that table.
The problem is that the "List rows" action works only when I manually trigger the flow.
In other cases, the flow still runs but "List rows" returns an empty array.
Help would be appreciated.

  • JC-22080829-0 Profile Picture
    JC-22080829-0 4 on at
    Flow is triggered but still doesnt work properly
     
    The issue is that when I activate the flow everything works but in case some other users "list rows" action does not output any rows but when I re-run it everything is alright again.
     
    Here is a simplyfied diagram of my flow:
     
    When row is added, modified or deleted{
    Change type: create or modify;
    table name: tableA
    Scope: organization;
    selected column: x;
    run as: proces owner
    }
    |
    v
    List rows{
    table name: tableB
    filter rows: (idColumn from tableB) eq (value of idColumn from tableA) //tables represet diffrent stages of same business proces                                     //with specific id shared by all related tables
    }
    //List outputs 1 or 0 records. Depends if next business stage exists
    |
    V
    Update row{
    row id: (id of row on tableB)
    (here all the changes from tableA are updated in tableB)
    }
  • Mark Nanneman Profile Picture
    Mark Nanneman 976 on at
    Flow is triggered but still doesnt work properly
    Can you post some more screenshots and more information?

    The issue would most likely be with the filter on your List Rows action.
     
    Presumably you are using a value from the trigger to search your other table, and it's not finding anything on the other table.

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

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,445

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,741

Leaderboard