Hello Community,
I created a flow to update an Excel table depending on an ID (name DocID). The ID is a numeric.
I retrieve and transfer the data using a webhook, which contain a simple JSON body. In the next step I choose the action "List rows present in a table". Afterwards I try to compare and filter the ID getting from the webhook with the excisting IDs in the table. If the result ist empty, Excel should create a new row otherwise the excisting row should be updated. I also know that the returned IDs from Excel are in string format.
My filter array looks like that:
The expression of "value" is
And the comparison is
Thanks a lot.
Hi @MisterBean
If you looking to compare the ID then your below expression you currently using is not quite right.
triggerBody(outputs('List rows present in a table')?['body'])
This will return the whole list rows. If your excel Id column is called ID then you should try the below
item()?['ID']
Thanks
If you liked my response, please consider giving it a thumbs up
Proud to be a Flownaut!
Learn more from my blogThanks a lot.
Unfortunately the problem still exist. And I found a second curiosity.
In the first picture you can see the data received by the webhook:
Afterwards the flow didn't find the ID, which is not correct due to the "filter array" condition and create a new row, which is logical correct. But this row is empty. All entries are "null":
But the should correspond to the data of the first picture.
This is the corresponding data assignment:
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.
Learn to digitize and optimize business processes and connect all your applications to share data in real time.