I have two lists one is DatesTable and the other is SummaryList
DatesTable - this is continuous every Thursday.
| WeeklyDate |
| 9-Sep-2020 |
| 16-Sep-2020 |
| 23-Sep-2020 |
SummaryList
| WeeklyDate | Answer1 | Answer2 | Status | Name |
| 9-Sep-2020 | Test1 | Test2 | Completed | Arthur morgan |
So the gallery will consist of two tables, a button will show depending on the WeeklyDate of my SummaryList.
Basically gallery will only fetch 1 row but I also want to fetch rows from WeeklyDate of the DatesTable which are
| 16-Sep-2020 |
| 23-Sep-2020 |
I also want my button in my gallery to change that if gallery take rows from the DatesTable my button text will be "New" if from SummaryList "Amend"
Thank you

Report
All responses (
Answers (