Skip to main content

Notifications

Power Automate - Building Flows
Unanswered

Flow stopped working after adding variables

Posted on by 211

I'm attempting to build a flow that is triggered when a new item is created in a Sharepoint list.  The flow worked until I added Select and Create HTML table variables.  Any suggestions would be appreciated.   Please let me know if additional details would be helpful.  

Shaguar357_0-1673645505548.png

Shaguar357_1-1673645929029.png

 

  • grantjenkins Profile Picture
    grantjenkins 11,057 on at
    Re: Flow stopped working after adding variables

    @Shaguar357 Sorry for the late reply. After you run your flow, open your Get items and click on Show raw outputs for the OUTPUTS. This should open a new window with the content returned from Get items.

     

    grantjenkins_0-1674397305625.png

     

  • Shaguar357 Profile Picture
    Shaguar357 211 on at
    Re: Flow stopped working after adding variables

    Hi @grantjenkins ,

     

    Where do I find the Click to download from the Get Items?  I'm not seeing it.  

    Shaguar357_0-1673878485336.png

    I did add the Header info, but that didn't seem to change anything.  The flow does run and I'm receiving an email, but still no info from the Sharepoint list.

     

    Thanks!

  • grantjenkins Profile Picture
    grantjenkins 11,057 on at
    Re: Flow stopped working after adding variables

    What you have is correct with respect to value (not value-Item).

     

    Can you check that you are receiving items from your Get items action. After running the flow, you can open the Get items action and click on Click to download.

     

    Looking at your Create HTML table actions, it looks like you don't have any headers specified. This might be the issue since they will be used as the Table headers.

  • Shaguar357 Profile Picture
    Shaguar357 211 on at
    Re: Flow stopped working after adding variables

    Hi @grantjenkins ,

    Thanks for your input.  I took the Select out and kept the Create HTML table.  The flow ran successfully, an email was received, however, it did not return the items from the Sharepoint list. 

     

    Shaguar357_0-1673723152771.png

    When you say the Create HTML table uses the value from Get Items, which value are you referring to?  I have a "value- Item" and "value".   I tried both and neither brought in the items from the list.  

     

    Thanks again for your help!

  • grantjenkins Profile Picture
    grantjenkins 11,057 on at
    Re: Flow stopped working after adding variables

    Your Select and Create HTML table shouldn't be within an Apply to each. If you're just getting the items returned and using a subset of the fields to build up your HTML table, then you would likely just have the following. Note that the Create HTML table input uses value from Get items.

     

    grantjenkins_0-1673664322544.png


    ----------------------------------------------------------------------
    If I've answered your question, please mark the post as Solved.
    If you like my response, please consider giving it a Thumbs Up.

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

November 2024 Newsletter…

November 2024 Community Newsletter…

Community Update Oct 28…

Power Platform Community Update…

Tuesday Tip #7 Community Profile Tips…

Welcome to a brand new series, Tuesday Tips…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 143,532

#2
RandyHayes Profile Picture

RandyHayes 76,308

#3
Pstork1 Profile Picture

Pstork1 64,050

Leaderboard