Unanswered

Can we know if a field is in a collection?

(0) Share

Report

Posted on by JhonaOB365

Good afternoon, everybody.

Please, can you help me with the following question?

On weekdays, I received an eamil and I have to filter the data table (It's in an email body). Next, I send email to our suppliers.

Are there any way that allow me compare each code supplier of data table in email body with my data supplier. Then, if my code supplier is there, send automaticly email.
I attach part of email body.

Thanks for read.

A hug!

Jhonatan Ora

Categories:

General topics

All responses (2)

Answers (0)

Sort by

Paulie78 8,424 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

Yes, it is possible for sure. Parsing that table into a JSON array is your first step really. Where is your supplier data stored?
JhonaOB365 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi, @Paulie78.

Thanks for your answer.
Below attached image with supplier codes.

Currently, a flow is already running that captures the data in the table and takes it to an excel. After that is that I do the filter and send the mail to each provider by using a macro in VBA. What I can think now is that I no longer have to generate the submission to the excel file, but that, once the data in the mail table is captured, compare the codes with the RUC codes of my database, if equality is met, the mail is sent, if you do not move on to the next code to do the analysis .

Thanks.

Best regards,

Jhonatan Ora