cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Perez
Level: Powered On

PoawrAppsID in flow results

Hi,

I’m new to the flow and power apps capabilities and will be happy to get assist with this issue i encountered:

I built a flow that get a form results and update it into an excel sheet.

the flow is ending successfully but when looking at the result it is not was quite what i was expecting.

1. on the excel one new column was added: "__PowerAppsId__" (I didn’t define it as part of my form or my flow)

2. this new row contains 465 rows with values and only after it my data showed.

 

other than data was ok, as expected, only it appears in line 465...

Not sure why it is happening and would appreciate your help.

 

Thanks in advance

Eyal

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: PoawrAppsID in flow results

 

Hi @ bangorkeith,

 

Once you create a connection to an Excel table in microsoft flow,your table will create a  "__PowerAppsId__" column automatically, this is the ID for that row, that you can later specify the row in a Flow.

 

You could refer to link below to learn more about the "__PowerAppsId__" column:

https://powerusers.microsoft.com/t5/Connecting-to-Data/Generate-ID-values/td-p/26713

 

 

Regards,
Alice Zhang

View solution in original post

2 REPLIES 2
Community Support Team
Community Support Team

Re: PoawrAppsID in flow results

 

Hi @ bangorkeith,

 

Once you create a connection to an Excel table in microsoft flow,your table will create a  "__PowerAppsId__" column automatically, this is the ID for that row, that you can later specify the row in a Flow.

 

You could refer to link below to learn more about the "__PowerAppsId__" column:

https://powerusers.microsoft.com/t5/Connecting-to-Data/Generate-ID-values/td-p/26713

 

 

Regards,
Alice Zhang

View solution in original post

Perez
Level: Powered On

Re: PoawrAppsID in flow results

Hi @v-yuazh-msft

thanks for your reply.

it helped a lot.

i understood that the issue was becouse my inital table was with 450 empty rows and the flow just created the new row starting at 451.

 much appreciated.

 

Eyal

 

Helpful resources

Announcements
thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

firstImage

Incoming: New and improved badges!

We've given our badges an overhaul and also added some brand new ones!

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

sixthImage

Power Platform World Tour

Find out where you can attend!

seventhimage

Webinars & Video Gallery

Watch & learn from the Power Automate Community Video Gallery!

Top Kudoed Authors (Last 30 Days)
Users online (5,186)