How can I add new row if there are no matching data in Excel 365

How To
,
1

Hi,

I’m trying to build user registration scenario using chat app and Excel 365.
When user initiate chat, refer to Excel table containing user list, and if there are no matching rows, I would like to add new row with this user.
Matching key is User ID from chat app.
if user is already existing, update matching record with latest data like Name, latest update.

Tried several approaches, but not able to create filter or modules working for this purpose.
Any good ideas to accomplish this?

2

Hi @TAIKI_FUKUNAGA

Welcome to Make Community!

Could you please share the screenshot of the scenario or module you tried to identify the errors?

If you require additional assistance, please don’t hesitate to reach out to us.
MSquare Support
Visit us here
Youtube Channel

2 Likes
3

image
image2240×1064 223 KB

Here’s current scenario, only storing Chat historical record into Excel 365.
Our next step is to store User record into another spreadsheet, when user triggering chat interaction has no previous history in the records.