I'm needing some help from the experts here. The flow that I'm creating needs to pull the most recent entry made to a Sharepoint list and send an email to a group email account (ideally in a PDF format) that contains the column values of the most recent entry. The flow runs, however, the email I received contains all the entries on the Sharepoint list and the HTML table does not seem to be working correctly. I know I'm missing a few things here, just not sure what:
The email I receive does pull the Station, however, it also contains the following before the yellow highlighted station:
Thanks in advance!
Hi @Shaguar357 ,
Judging from the screenshot you provided, this column is the Choice column.
I have tested both multi-select and single-select for your reference:
Here is list:
Here is flow:
xpath(xml(json(concat('{"root":{"choices":', item()?['multipleChoice'],'}}'))),'/root/choices/Value/text()')
For single selection we need to pay attention to a few things:
Here is result:
Best Regards
Cheng Feng
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.